Multi page Form Letter

[dnivaras]

Can I have a Letter spanning more than one page. I create a new report with the Form Letter template. But could not make the form Frame to span more than one page.

 

[cmkedu]

I have a similar problem with a complex report containing sub_reports. I need it to span more than one page and cannot figure out how to accomplish that.

 

[steever]

Hi,

Try putting your main query in the 'header' section of a list report and your subqueries in the main body. As you scroll through each record of your main query (in the header), related records in your subquery/s will appear in the body.

No, you will not be able to have multiple queries spanning many pages. I tried this! Our client wanted a huge report, one that involved us creating 20 subquerys. The only way to get that many into a report would be to have it span more than 1 page!! I went back and forth with Cognos with this one, before finding out it wasn't possible. You can only get what you can get on the page - maybe a few subqueries with no guarantees on what the final product will look like. Crystal handles this type of reporting much better - it is better for form like reporting and reports that involve many subqueries. Good luck!

Steve