I need to print Service Contract invoice in Summary/Details Fashion.

Summary will be in first page and in portrait
and detail will be in next page and in landscape.

Could you please tell me how to achieve this using single spool.

Summary and Detail should come one after another on single Print.

eg.
Summary 1 ( Portrait)
Detail 1 (Landscape)
Summary 2 ( Portrait)
Detail 2 (Landscape)

This should be interesting to see what other responses you get. Typically the summary contains total or sum functions and the only way I see to get that first is to do it in the session script. Then send the totals to the report just like a details line. Easiest way I can think of reversing it.

At least one other method comes to mind, but would probably be more complicated in the long run.

Look up the spool functions - that may show you some options.

All in all, looks to me like too much programming anyways, just for cosmetic gains.

So, unless it was dictated by customer demand and is a definite requirement, I would prefer to stay with 'standard' report writing, wherein I would to a minimum amount of programming and let the report writer system do all the work.

I have done something similar by printing a different report per page, where each can have a different orientation, font, etc. Use the 'brp' calls and close them in the right order. The limitations are that you can't do totals/counts/page numbers within the report - you must do the calculations in your program script and pass them to the report. Since the orientation is handled by the device, you will also have to know the device names for the landscape and portrait device that supports the same physical device.

u can use something like setting spool.orientation value in report script.... i m not pretty sure since i havnt tried ... u can give it a try :cool: