My report has a sub-report for Freight Hours using a formula as a lookup. I get the hours, but need a Shared NumberVar so I can use the hours (which all works fine) and multiply by it's Unit Cost.
My main report needs to summarize the detail lines in a Group Footer using sum (without showing the detail lines which also contains the sub-report for the Freight Hours). Since CR won't let you use Running Totals on Shared Variable I had to use create Formula Fields using WhilePrintingRecords for summing Freight Cost for the Item, Customer & Company (adding these to details section b with reset Formula Fields setting the Variable to 0 in its respective Header)
The problem is, if I hide or suppress the detail lines, WhilePrintingRecords will not evaluate so my Group sums correctly the Qty, Sale Price, Cost of Goods Sold, but shows the Freight Cost (the Sub-Report) as 0. Therefore the Profit/Loss does not deduct the Freight Cost.
If I show all the details a, b, c, the report runs perfectly (but they only want to see the summary not every detail line)
Is there a way to hide the detail lines, but let CR calculate the Fromulas based on WhilePrintingRecords (I don't want to shrink the detail lines as some Items might have 50 detail lines others 1, so even minimal detail height will still make the report's look inconsistent)
Other than creating another Sub-Report to bring in the summary line, with a the current Sub-Report for the Freight Hours is there another way of getting the report to treat the Sub-Report value so that it can be summed or use Running Totals?