Sub/grand Total on Subreport

[ZENYO]

Hello, I'm tryin to add three subreports to my main report. The report is month by month report showing revenue and profits for current and previous year. the problem I'm having is that Crystal 10 can't handle all the formulas (over 50) there are 4 formulas for each month. 4 "total" formulas and 4 for each quarter. The report was starting to crash. Note: this is why I can't use shared variables to pass sub totals from subreports, once again to many formulas for crystal to handle.

The main report - Grouped by Class (1), sku (2). Month by month revenue with sub total on class, subtotal on sku and grand total
Subreport 1 (Working fine)- month by month profit, sub total on sku only, inserted into group 2 footer (sku) in main report and linked by sku field and date params.

Subreport 2 (Not Working) - month by month profit, sub total on class only. inserted into group 1 footer (class) in main report and linked by sku field and date params.

Subreport 3 (Not Working)- month by month profit, Grand total. inserted report footer in main report and linked by sku field and date params.

The subreports that are not working are showing incorrect totals.

All reports are using the same paramaters, same tables and groupings. I realy feel like I'm missing something simple.

Any suggestions

 

[lbass]

You should not be linking sub2 and sub3 by sku, as it will then pick up only the last sku value in the class group, or in the case of sub3, the last sku value in the report.

I don't think the issue with the number of formulas is a CR issue. I have never noted this kind of behavior.

-LB

 

[ZENYO]

Thanks LB, I'll have a look at the links again.

I have a report with all the formulas, the report works great but crw32.exe is crashing everytime I try to edit a formula. If I edit 1 formala --> save and close (takes up to 2 min.) it's fine. If I try to edit a formula --> save and then try to work on another formula crw32.exe pays a visit to Dr. Watson...

Thanks

 

[lbass]

Try to verify the database and also check set location. Then also check to make sure you don't have any formulas/running totals referencing any tables that you have already somehow removed from the report. I've seen this happen if you get a message asking whether to remove a table when there are still fields in the report and you say yes, and then somehow not all field references get removed.

-LB