Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Graph and Report resize

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Graph and Report resize
 Login/Join
 
Silver Member
posted
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,


WebFOCUS 8
Windows, all Outputs
 
Posts: 29 | Registered: August 22, 2017Report This Post
Platinum Member
posted Hide Post
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


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 183 | Location: Indiana | Registered: December 05, 2017Report This Post
Silver Member
posted Hide Post
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 ??


WebFOCUS 8
Windows, all Outputs
 
Posts: 29 | Registered: August 22, 2017Report This Post
Virtuoso
posted Hide Post
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


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Graph and Report resize

Copyright © 1996-2020 Information Builders