I am using WF 7.6.0 and Excel 2003.

My report lay out will be


Graph1 Graph2

Tab.report Graph3

means that graph1 and graph2 should be displayed side by side and in the next row Tab.report and graph3 must be displayed side by side. All the reports must be displayed in a single Excel sheet. Giving sample code is appreciated.

Thanks in advance.

Prasanna,

There are only about 1000 examples of Compound reporting on this site. Please use the FIND button above.

Also, Please Update your Signature

I see you typed it in at the top, but, there is more to it...

Tom

Thanks for the reply tom.

I found the reports which are in style sheets which are made by using NOBREAK.

I found reports which are on the same page which are in a sequential order which can be made of using OPEN.

Here I need side by side reports in a single sheet.

I am not able to find the examples can you please send the link..

Prasanna,

Use the Compound Report Painter in Developer Studio.

You missed the part about updating your signature!!!

Tom

You will also find recommendations to load the data into Excel and then use VBA to generate the graphs.

I would recommend using PDF as the output medium despite what your users may think that they want. The output format is better suited to the output layout that you want to create using WF.

I know that this is your first post, but learn early that there is a wealth of information on the forum if only you look for it. Get into the habit of using the search facility (top right) and actually reading the results. You will learn more than you will just by receiving a possible solution or method. You will also earn respect from other users on this forum who give their time and knowledge for free to those who demostrate that they deserve it.

T

When I am creating a report in procedures In the create with option I had the options

procedure viewer- which I am selecting after that it is asking for the master file and after selecting that the the GUI is opening with the fields in the master file.

Report painter - which I am selecting after that it is asking for the master file and after selecting that the the GUI is opening with the fields in the master file.

PDF layout painter - which I am able to do the compound PDF reports.

SQL report wizard
graph assiistant
advanced graph assistant
text editor

These are the options I am getting. Please give the path like you have given for updating the signature.

Prasanna,

I gave you the instruction link above. It explains the How To by Sir Francis in updating your profile...

You have found the correct area to create a Compound Report. When you open the PDF Layout Painter, you can create the Graphs and Reports. Over to the right, in the Properties box, is a list of properties; click on Output Format and EXCEL will be one of your choices.

Have Fun!!!

Tom

I am able to find only 2 options there

PDF
DHTML

I am not able to find the EXCEL.


I had updated the signature.

Prasanna,

OK, you are on 7.6.0. EXCEL is obviously not available on that version. You CAN still output into EXCEL, "I think" after creating in PDF. You'll have to change:

ON TABLE PCHOLD FORMAT PDF

to

ON TABLE PCHOLD FORMAT EXCEL or EXL2K

You DID update your signature. THANK YOU!!!

Tom

The EXCEL output option for PDF Layout Painter is available for 762.

However, based on what you want, I think PDF is the preferred output format especially since you want graphs.

Careful Ginny, there's that thinking alike again

T

Tony, It didn't seem like your initial suggestion was getting through so I thought I'd repeat it.

Ginny, Thanks for the support, 'preciate it

T

Thanks tony, tom & ginny. In 7.6.2 I had that option and I will try and let you know.

I had tried that and I am not able to get the output in excel..

I had changed the output format in the properties and also I tried it changing in the code.

Is there any other way to do this.

Prasanna,

Here is some sample code on how to place 2 graphs side-by-side above a report in EXCEL.

Hopefully, this will give you an idea on how to accomplish your task:

  
-SET &ECHO=ALL;
-SET &APPFOLDER  = 'baseapp/';
-SET &USERID     = GETUSER('A8');
-SET &LC_USER    = LOCASE(8, &USERID, 'A8');
-SET &GIF_FILE1  = &LC_USER || 'graph1' || '.jpg' ;
-SET &PATH       = &APPFOLDER || &GIF_FILE1;
APP FI GRAPH2 DISK &PATH
-RUN
GRAPH FILE CAR
SUM 
     RETAIL_COST AS ''
ACROSS COUNTRY
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET HAXIS 520
ON GRAPH SET VAXIS 205
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH PIE
ON GRAPH SET GRMERGE ON
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 2
ON GRAPH HOLD AS GRAPH2 FORMAT JPEG
ON GRAPH SET STYLE *
TYPE = REPORT,  FONT=VERDANA, SIZE=9, $
TYPE = HEADING, FONT=VERDANA, SIZE=10, STYLE=BOLD, $
ENDSTYLE
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setFontName(getDataText(),"Verdana");
setDepthAngle(65);
setPieDepth(45);
restoreAllSlices();
setPieFeelerTextDisplay(2);
setPieTilt(25);
setPieLabelDisplay(0);
setDisplay(getPieLabel(),true);
setLegendAutomatic(false);
setFontStyle(getLegendText(),2);
setFontStyle(getPieSliceLabel(),2);
setTextFormatPreset(getPieSliceLabel(),5);
setFontSizeInPoints(getTitle(),12);
setFontSizeAbsolute(getPieSliceLabel(),true);
setFontSizeInPoints(getPieSliceLabel(),8);
setFontSizeAbsolute(getLegendText(),true);
setFontSizeInPoints(getLegendText(),9);
setTextFormatPattern(getDataText(),"$#,###,###,###.##");
setFontSizeInPoints(getO1Label(),9);
setFontSizeInPoints(getY1Label(),9);
setFontSize(getDataText(),10);
setFontSizeAbsolute(getTitle(),true);
setFontSizeInPoints(getTitle(),12);
setLegendMarkerPosition(0);
setTransparentBorderColor(getChartBackground(),true);
setRect(getPieFrame(), new Rectangle(-15500,-13500,27000,27000));
setRect(getFrame(), new Rectangle(-10400,-10000,25000,30000));
setTextString(getTitle(),"TOTAL RETAIL COST BY COUNTRY");
ENDSTYLE
END
-RUN
-SET &GIF_FILE2  = &LC_USER || 'graph2' || '.jpg' ;
-SET &PATH       = &APPFOLDER || &GIF_FILE2;
APP FI GRAPH2 DISK &PATH
-RUN
GRAPH FILE CAR
SUM 
   COMPUTE PROFIT/P13.2M = RETAIL_COST-DEALER_COST; AS ''
ACROSS COUNTRY
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET HAXIS 520
ON GRAPH SET VAXIS 205
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH PIE
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 2
ON GRAPH HOLD AS GRAPH2 FORMAT JPEG
ON GRAPH SET STYLE *
TYPE = REPORT,  FONT=VERDANA, SIZE=9, $
TYPE = HEADING, FONT=VERDANA, SIZE=10, STYLE=BOLD, $
ENDSTYLE
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setFontName(getDataText(),"Verdana");
setDepthAngle(65);
setPieDepth(45);
restoreAllSlices();
setPieFeelerTextDisplay(2);
setPieTilt(25);
setPieLabelDisplay(0);
setDisplay(getPieLabel(),true);
setLegendAutomatic(false);
setFontStyle(getLegendText(),2);
setFontStyle(getPieSliceLabel(),2);
setTextFormatPreset(getPieSliceLabel(),5);
setFontSizeInPoints(getTitle(),12);
setFontSizeAbsolute(getPieSliceLabel(),true);
setFontSizeInPoints(getPieSliceLabel(),8);
setFontSizeAbsolute(getLegendText(),true);
setFontSizeInPoints(getLegendText(),9);
setTextFormatPattern(getDataText(),"$#,###,###,###.##");
setFontSizeInPoints(getO1Label(),9);
setFontSizeInPoints(getY1Label(),9);
setFontSize(getDataText(),10);
setFontSizeAbsolute(getTitle(),true);
setFontSizeInPoints(getTitle(),12);
setLegendMarkerPosition(0);
setTransparentBorderColor(getChartBackground(),true);
setRect(getPieFrame(), new Rectangle(-15500,-13500,27000,27000));
setRect(getFrame(), new Rectangle(-10400,-10000,25000,30000));
setTextString(getTitle(),"TOTAL PROFIT BY COUNTRY");
ENDSTYLE
END
-RUN
DEFINE FILE CAR
 IMAGE1/A200='<img src=http://localhost:8080/approot/baseapp/&GIF_FILE1>';
 IMAGE2/A200='<img src=http://localhost:8080/approot/baseapp/&GIF_FILE2>';
 X1A/A15         = '<TABLE>';
 X1B/A15         = '<TR>';
 X1C/A20         = '</TR>';
 X1D/A10         = '</TABLE>';
 X1E/A30         = '<TD COLSPAN=5 align="left">';
 X_END/A5        = '</TD>';
 X2A/A30         = '<TD COLSPAN=5 align="right">';
END
TABLE FILE CAR
HEADING
"<X1A<X1B<X1E<IMAGE1<X_END<X2A<IMAGE2<X_END<X1C<X1D"
"</12 "
SUM
  DEALER_COST/P13.2M AS 'Dealer Cost'
  RETAIL_COST/P13.2M AS 'Retail Cost'
    COMPUTE PROFIT/P13.2M = RETAIL_COST-DEALER_COST; AS 'Profit'
  SALES/P13.2M AS 'Sales'
  SEATS AS 'Seats'
BY COUNTRY AS 'Country'
BY CAR AS 'Car'
BY MODEL AS 'Model'
BY BODYTYPE AS 'Body Style'
ON COUNTRY SUBFOOT
" "
ON TABLE SET PAGE-NUM OFF
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.400000,
     RIGHTMARGIN=0.050000,
     TOPMARGIN=0.000000,
     BOTTOMMARGIN=0.000000,
     ORIENTATION=LANDSCAPE,
     SQUEEZE=ON,
$
TYPE=TITLE,
  STYLE=BOLD, SIZE=10, FONT=VERDANA,
$
ENDSTYLE
END
-RUN

I'm sure there are other ways, this is 1 example...

Tom

Good method Tom, however, I would be inclined to use inferred urls in the image tags so that you don't have to modify the source to allow it to run successfully on different machins.

Prasanna,

The important consideration, as Tom's post shows, is where you place the image output of you graph and how you pull those images into your output.

Here, Tom has used URLs within an HTML Table tag set and has taken advantage of the fact that the "Excel" output from WebFOCUS is XML.

A simple rule of thumb for incorporatin gimages in any of your outputs (merged, compound etc. etc.) is to consider how that output needs the image to be included.

PDF - the image is part of the data stream and therefore it needs to be stored on the reporting server and / or filedef'd properly to allow it to be found and built at the reporting server.

HTML - needs the image to be in a valid format for use within your target browser of choice and be accessable by the web server via a URL.

Excel - can be problematic unless you utilise you knowledge on how the WebFOCUS "Excel" output is delivered - i.e. in XML form.

T

Tom, Thanks for the code. It works great. And I am trying for 2 tabular reports to be side by side like the graphs. But, we are not able to get this. Can you suggest me any solution for this?