Focal Point
[SOLVED]Compound Report In Excel Format - Top and Bottom

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2757018486

December 06, 2016, 02:04 PM
v_ani
[SOLVED]Compound Report In Excel Format - Top and Bottom
I've two combined compound report in Excel "bytoc" format. Is it possible to show the one at Top of the report and other report at the bottom in Excel with Bytoc. I appreciate your help.Thank you

This message has been edited. Last edited by: Tamra,


WebFOCUS 8
Windows, All Outputs
December 07, 2016, 08:34 AM
Diane
I think this case explains what you are asking for:

https://techsupport.informatio...om/sps/60482009.html


WebFOCUS 8.1.0.5m
December 07, 2016, 12:11 PM
v_ani
Diane ,
Thanks for you reply, I also tried the option you have pointed to the case. But I want the two reports on the same sheet with Bytoc option. One report shows as title of the heading and other report show as bottom of the report in the same Sheet.


WebFOCUS 8
Windows, All Outputs
December 07, 2016, 02:03 PM
j.gross
So why are you fixated on BYTOC?

BYTOC, in Excel format, produces a separate worksheet for each sort-break of the outermost sort key.

If you want two sections, one over the other on a single sheet, use BY (and perhaps SKIP-LINE) without the BYTOC option.