Current Position:Home > Print multiple sections in report

Print multiple sections in report

Update:10-11Source: network consolidation
Advertisement
How do I print multiple sections in a report?
For example, if I have 5 select statements in my data section and want to print them seperately, one after the other, how would I do that?
I do not want to merge the data together. I want it to be like 5 reports concatenated together.
Query1 Title
Query1Results
Query2 Title
Query2Results
... etc ...

The Best Answer

Advertisement
What you need to do is create a new main frame for each query. The easy way that use to do this is create the section of the report and let the wizard create the frames for me. Then I move them around to make the section look the way I want it to. Then I open a new report. This one I'll build it using the second query. Then again use the wizard to setup the frames. Then you'll select the main frame from the second report using the frame selet button copy it and paste the layout into the first report. You will want to paste it under the first section. A little trick here is to first draw a small line right above where you want the second section. The paste the second section. This will make sure the the second section is close to where you want it. If you do not do this Reports will put it on top of the first section a lot of times. You'll have to recreate the data model again, but that is easier then setting up all the framing on a complex layout. Then repete the second report step until you have done all the queries or sections you want.
I hope that helps,
Tom
  • Print multiple sections in report Update:10-11

    How do I print multiple sections in a report? For example, if I have 5 select statements in my data section and want to print them seperately, one after the other, how would I do that? I do not want to merge the data together. I want it to be like 5

  • Print Multiple copies of report, and resetting Page number for each copy. Update:10-11

    Dear frnds! i am using developer 6i reports i have a problem. i want to Print Multiple copies of report, and resetting Page number for each copy" that is 4 copies of an invoice is required 1 - for user copy 2- gate copy 3- accounts office 4- office c

  • Need to print multiple sections in a group Update:10-11

    We have print customer invoices. Along with each invoice, we have to send 1.     A Cover Letter that is always one page 2.     Terms and conditions. This could be between 1 to 3 pages Our requirement is to have separate page numbering for each of the

  • Crucial - Printing Multiple Copies of Report Update:11-30

    Greetings to all! I have a situation to suggest a solution for this. I nee to call a Oracle Report from the Oracle Apps. When the user fires the "Print" from the invoice screen, - I need to initiate three copies of the same invoice. - Each copie

  • Printing- multiple sections and no comments Update:11-30

    Hi, This problem has occured only since upgrading to Lion. I have been trying to print a document from Word 2011, with reviewer's comments included. When I send directly to the USB connected printer, reviewer's comments are not printed and the docume

  • How to print multiple footers for each page in RTF template xml report. Update:10-11

    Hi, How to print multiple footers for each page in RTF template xml report. i am able to print ( two sets ) ... up to last page ( one template ) and for last page ( another template). i want to change the footer information based on the group value p

  • Group footer. Want to print one section in the body of report Update:11-30

    I am working on an invoice. It has two groups:                 Detail line                 Invoice number In crystal the invoice number group header is ran than the detail line group fires. After all the detail lines are printed for that invoice numb

  • How to get Report Builder to print a section on the same page Update:10-11

    I have a section of my report that is three bands. A header band, the detail band, and a total line band. Sometimes this section will get split up and print part on the next page. So basically I need for this section to print on the same page. I know

  • Printing multiple reports on a single page Update:10-11

    i have a transaction report of 5-6 lines after printing i want the printer head to stop and print the next transaction report immediately. what properties need to set up/ what are escape sequencee and how are they used? nullWhat controls are you usin

  • Simple Statement w/ subreport prints multiple pages Update:11-30

    Hello all, I have a CR 2008 migrated from older version (CRW 32 6,0,1,135  with VB6 driving the report) that is printing multiple pages when it should be only printing 1 page. This report is a Statement that shows customer info and account balances.