Issue: Report is thrashing, and doesn't respond(have to kill crystal)
Environment: Running BO XI locally on Win7 Pro x64
Report details: running against SQL 2005 DB.
This report runs great currently, but I'm trying to implement a modification.
I'm adding fields to a subreport.
I duplicated the formulas, params,and running totals ON the subreport field explorer so that I could access some of the same data that the report uses.
Is soon as I place a formula field onto the subreport and run it, the report dies a slow death....
E.G.
if I make the formula equal:
if datediff("m",{ServiceSetups.StartDate},{ServiceSetups.CancelDate}) in 2 to 7 then "umm" Everything is great, and I get "umm" on my report.
If I replace "umm" with say, {commission}, which is currently used in the Main report, it dies...
I'm sort of new to subreports...
Thanks lads,
Rich