Hello ,
I am trying to create a report with it having a graph somehow the size of the graph is less compared to the report whose width I have increased, Can anyone kindly suggest a way in which I can make the size of the report in line to that of the graph ??
I am posting the code here :
TABLE FILE FEB_2018
PRINT
COMPUTE ERROR/D6 = IF CR_CATEGORIE EQ 'Error' THEN 1 ELSE 0;
COMPUTE MAJOR/D6 = IF CR_CATEGORIE EQ 'Major' THEN 1 ELSE 0;
COMPUTE MINOR/D6 = IF CR_CATEGORIE EQ 'Minor' THEN 1 ELSE 0;
COMPUTE PROJECT/D6 = IF CR_CATEGORIE EQ 'Projekt' THEN 1 ELSE 0;
COMPUTE STD/D6 = IF CR_CATEGORIE EQ 'Standard Customizing' THEN 1 ELSE 0;
COMPUTE YEAR/YY=YEAR_OF_CREATING; NOPRINT
COMPUTE YEAR1/A4YY = EDIT(YEAR); NOPRINT
COMPUTE MONTH/M=MOUNT_OF_CREATION; NOPRINT
COMPUTE MONTH1/A2 = EDIT(MONTH); NOPRINT
COMPUTE MONTHYEAR/A7= YEAR1 |'.'| MONTH1; NOPRINT
-*COMPUTE MYMONTH/A30 = DECODE MOUNT_OF_CREATION (1 'Jan' 2 'Feb' 3 'Mar' 04 'Apr' 05 'May' 06 'Jun' 07 'July' 08 'August' 09 'September' 10 'October' 11 'November' 12 'December'); NOPRINT
BY YEAR_OF_CREATING
BY MOUNT_OF_CREATION
BY MYMONTH AS 'Period'
-*BY CR_CATEGORIE
WHERE YEAR_OF_CREATING GT '2016' AND MOUNT_OF_CREATION GT '0';
WHERE STATUS EQ 'Open';
ON TABLE HOLD AS FEB2018 FORMAT ALPHA
-*ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END
-RUN
-*-EXIT


GRAPH FILE FEB2018
SUM
ERROR
MAJOR
MINOR
STD
PROJECT
-*BY YEAR_OF_CREATING
BY MONTHYEAR AS ''
-*BY MYMONTH AS 'Period'
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB ON
ON GRAPH SET 3D ON
ON GRAPH SET VZERO OFF
ON GRAPH SET GRID ON
ON GRAPH SET GRAPHSTYLE *
ON GRAPH SET HAXIS 1770
ON GRAPH SET VAXIS 605
ON GRAPH SET UNITS PIXELS
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 3
ON GRAPH SET GRAPHSTYLE *
setTextString(getTitle(),"New CR's");
setTextDisplay(getTitle(),true);
-*setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setFillColor(getSeries(0),new Color(53,125,145));
setFillColor(getSeries(1),new Color(0,60,125));
setFillColor(getSeries(2),new Color(71,164,189));
setFillColor(getSeries(3),new Color(112,183,205));
setFillColor(getSeries(4),new Color(160,202,217));
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setDepthRadius(0);
-*setUseSeriesShapes(true);
setMarkerSizeDefault(100);
-*setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setLegendDisplay(false);
setLegendAutomatic(false);
setTitleDisplay(true);
setLegendDisplay(getSubtitle(),false);
setFillMissingData(0);
setDataTextDisplay(false);
setDataTextPosition(5);
setStackedDataValueSum(false);

*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setTextRotation(getO1Label(),0);
END


TABLE FILE FEB2018
SUM ERROR
OVER MAJOR
OVER MINOR
OVER STD
OVER PROJECT
ACROSS YEAR_OF_CREATING AS ''
ACROSS MOUNT_OF_CREATION AS ''
-*SUM
-* YEAR_OF_CREATING
-* MOUNT_OF_CREATION AS 'Period'
-*PRINT ERROR
-*OVER MAJOR
-*OVER MINOR
-*OVER STD
-*OVER PROJECT
-*BY YEAR_OF_CREATING
-*BY MOUNT_OF_CREATION AS 'Period'
ON TABLE SET SPACES 7
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$

TYPE=REPORT, BORDER=ON, GRID=ON, SQUEEZE=OFF, FONT=ARIAL,
$
END
-*-EXIT


TABLE FILE FEB_2018
PRINT
COMPUTE ERROR/D6 = IF CR_CATEGORIE EQ 'Error' THEN 1 ELSE 0;
COMPUTE MAJOR/D6 = IF CR_CATEGORIE EQ 'Major' THEN 1 ELSE 0;
COMPUTE MINOR/D6 = IF CR_CATEGORIE EQ 'Minor' THEN 1 ELSE 0;
COMPUTE PROJECT/D6 = IF CR_CATEGORIE EQ 'Projekt' THEN 1 ELSE 0;
COMPUTE STD/D6 = IF CR_CATEGORIE EQ 'Standard Customizing' THEN 1 ELSE 0;
BY YEAR_OF_CREATING
BY MOUNT_OF_CREATION
-*BY CR_CATEGORIE
WHERE YEAR_OF_CREATING GT '2016' AND MOUNT_OF_CREATION GT '0';
WHERE STATUS EQ 'Closed';
ON TABLE HOLD AS FEB2018 FORMAT ALPHA
-*ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END
-RUN

This message has been edited. Last edited by: FP Mod Chuck,

Is this a compound report? If so, you can use the COMPOUND LAYOUT Section to set the DIMENSION of each.
For example:
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='prop_with_names^Margins_Left=0.5^Margins_Top=.25^Margins_Right=0.5^Margins_Bottom=.25^thumbnailscale=4', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=Letter, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, $
COMPONENT='report01', TEXT='report01', TOC-LEVEL=2, POSITION=(0.520 0.312), DIMENSION=(7.125 10.500), ARREPORTSIZE=DIMENSION, $
--Deb

No this is not a comppund report but I am trying to get a solution for a compound report, since I would also want it to be extracted in excel.
Do you have a suggestion as to how I may progress with that ??

Asamant59

Give a compound report (Document) a try. In app studio create a New / HTML/Document and then choose the Document (PDF, Excel ...) radio button option. From there you can add the Report and Graph. With Excel each object will show in a separate tab within Excel