1 page of data - 1027 copies of it 1

[cmpgeek]

this is absolutely bizarre, and i hope someone else has expereinced it lol

i have written a report with 3 subreports in it - each in its own detail section... the numbers all look good... everything "computes" correctly... the only problem is that it wants to print 1027 pages of the same data! the subreports are all small in size - 5 or 6 lines max - so they all fit on one page... and every page after the first is exactly the same as the first one... i am at a complete loss here...

would having all the subreports in seperate detail tables compared to seperate groups be what is making a difference?

when i run each subreport by itself it only previews the 4 or 5 lines on 1 page... but when i run the big report i get the 1027 pages...

i think i need a drink... lol
ShannonLea

 

[lyanch]

Your main report is based on some query that returns 1027 rows.. so the detail is printed once for each row in the main report.

Lisa

 

[cmpgeek]

it is a broad selection criteria:

{CASEMAS.SH_DATE} in {?date range} and
{CASEMAS.SH_SITE} = "OR"

but i am not sure how to pull in what i need for the subreports without first entering it into the main...

ShannonLea

 

[lyanch]

What data from the main report do you need for the subreports? If it is summary data from the main then if you place the subreports in the report footers they will only print once.

If your not using the data from the main report then you might need to change your SQL for the main report.

Lisa

 

[cmpgeek]

there is actually nothing in the main report except for the subreports... ShannonLea

 

[cmpgeek]

instead of putting them in seperate detail sections i moved them to seperate report footer sections and that did the trick...

thank you so much Lisa for your help!

sometimes i think i really DO need someone to hit me in the head with a lol ShannonLea