Printing Reports

[lovesr]

We are running a billing system. In this system we have 1400 Bills, 8 reoprts in a bill How can I generate all the bills in one print job.

 

[ZanyJanie]

I don't know if this will work in your case, but have you considered creating a report that contains each of your 8 reports as sub-reports?

 

[lovesr]

Yes The problem I am having with that is each of our reports have there own header and footer. when we use them as subreports we lose that.

 

[ZanyJanie]

You can get around the subreport header/footer problem by putting all of necessary headers/footers fields in your MAIN report. This does gets a bit tricky though.

For each of your subreports, you'll have to turn on the visible property for the fields you want printed and turn off the visible property for the other fields.

There are a number of forum postings that discuss how to do this. Try searching for "subreport headings" and it might help.

 

[lovesr]

Each report has a different Header and footer
This is nessesary for our bills. I hope I am just being to thick headed to understand what you are trying to tell me. Thank you for your time

 

[ZanyJanie]

It is tricky; but even with different headers/footers you can still put everything in the page header/page footer of your main report. Here's the basic concept of how this works.


PageHeader

text1 text2 text3
text4 text5 text6

For subreport#1 you only want to print text1, 2 & 3 ... for subreport#2 you only want text4, 5 & 6


Before printing subreport#1, run a function that sets the visible property for text1, 2 & 3 to true and text4,5 & 6 to false. That way, even though all of the fields are actually in the page header, you only print the fields you actually need for the particular subreport.

Before each of your subreports, you would run a similar function that turns on and off visibility for the appropriate fields.

 

[pbuethe]

How is this implemented? How do you determine when each subreport is being printed? Which property does it go in? Is this going in the subreports or the main report?

 

[pbuethe]

I found an easy way from another post. I made a group header in each subreport and put the headings of the subreports there. Also, you need to set Repeat Section on in the group header properties.