Two Page Report Generates 1000+ Pages of Same Data 1

[OldGrayMare]

I am using CRXI; my main report consists of 20 subreports. I am passing a parameter from the main report to all 20 subreports. When I run the report, which consists of 2 pages, thousands of pages are generated of the same first 2 pages. It appears to be hung in some sort of loop with the first two pages and generates them many times.

Does anyone know what could cause this problem?

Thanks so much,

Rachel

 

[lbass]

The subreports should be placed in report header or report footer sections, with all other sections suppressed.

-LB

 

[OldGrayMare]

Thank you, LBass.

I am using a report designed by someone else where all of the subreports are in the details section, which prints fine. (I cannot see how to include a sample of the report here.) All I did was add a parameter to the existing report so that I can print data from one state agency instead of all state agencies.

 

[lbass]

Did you add a table to the container report when you added the parameter? I think your subs are repeating for each detail, and I still think you should try moving the subs to a report header or footer section.

-LB

 

[OldGrayMare]

Does each subreport need to be in a separate footer section, or can they all go into the same footer section?

Rachel

 

[lbass]

It depends upon whether they might overlap--if so, then separate sections are necessary.

-LB

 

[OldGrayMare]

Thank you, LB. I will create 20 separate Report Header sections, move the 20 subreports in the Details section to their own separate Report Header sections and see what the outcome is.

I appreciate your persistence in answering my questions

 

[OldGrayMare]

Hi, LB:

We figured out the problem with getting 1000+ copies of pages 1-2 on the report! We left all the subreports in the details section BUT deleted agency selection criteria from the main report. So, the main report contains the Agency parameter field but no selection criteria, while the subreports contain no agency parameter fields but each subreport does contain the selection criteria for ?agency.

I'm unsure why this fixes the problem, but it does.

--Rachel

 

[lbass]

If you were referencing a table in the main report, then the subreports would repeat for each row in that table, if placed in the detail section. By removing the table references, the table wasn't 'activated' and you removed the problem--that was why I asked about a container report table a few posts ago.

-LB

 

[OldGrayMare]

Thank you for your feedback, LBASS. I did not understand your question above about "adding a table to a container report." I'm new & learning.