Link to home
Start Free TrialLog in
Avatar of cgettel
cgettel

asked on

Crystal Reports: Passing Parameters to SubReports > Report goes into infinite loop

Crystal Reports: Passing Parameters to SubReports > Report goes into infinite loop and keeps spewing the same data over and over until I hit the stop icon.  

Report > Select Expert > Record

Main Report:
{INVOICE.INV_DATE} in {?ReportStartDate} to {?ReportEndDate}

Each of three SubReports:
{INVOICE.INV_DATE} in {?Pm-?ReportStartDate} to {?Pm-?ReportEndDate}
Each SubReport contains the exact same statement.

If I run the Subs separately, I get one copy of each set of data. Perfect.

If I run the Main Report, I get into the loop where I get infinite copies of each SubReport, page after page. Not perfect.  

Any clue as to how I'm getting into this loop?  Or more importantly, how I can eliminate the looping?  User generated image
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cgettel
cgettel

ASKER

I moved the subs to the footer. That gave me 70 blank pages then a single copy of each subreport.

I suppressed  the details. And now the report is perfect.

Many thanks mlmcc!