I have a report which (simplified) looks a bit like this...
Job Number: AB1234
VALUE SOURCE RESERVED INVOICED?
100.00 costing R-TIM- Y
356.00 costing R-TIM- N
500.00 costing A-TIM- Y
-50.00 costing U-TIM- Y
350.35 stock Y
122.00 puchase Y
999.00 puchase N
It's easy enough to sort the data and get subtotals for these in the usual way. However, the above report is actually a subreport, and I need to pass the result of each subtotal as a separate, shared variable to a main report. I think I can only declare the "automatic" subtotals as a shared variable once, so the wrong info would be passed to the main report if I used the obvious method of subtotalling...
I could work out a conditional sum / array formulae in Excel to create "manual" subtotals based on the possible combinations of SOURCE / RESERVED / INVOICED but am not sure if a similar / equivalent can be done In Crystal (8.5)? I would like to think think such a "manual" formula could be placed in a report footer to pass the relevant results to a main report?
I'm new here (first post) and a relative novice with crystal so be gentle with me...
Thanks.
Job Number: AB1234
VALUE SOURCE RESERVED INVOICED?
100.00 costing R-TIM- Y
356.00 costing R-TIM- N
500.00 costing A-TIM- Y
-50.00 costing U-TIM- Y
350.35 stock Y
122.00 puchase Y
999.00 puchase N
It's easy enough to sort the data and get subtotals for these in the usual way. However, the above report is actually a subreport, and I need to pass the result of each subtotal as a separate, shared variable to a main report. I think I can only declare the "automatic" subtotals as a shared variable once, so the wrong info would be passed to the main report if I used the obvious method of subtotalling...
I could work out a conditional sum / array formulae in Excel to create "manual" subtotals based on the possible combinations of SOURCE / RESERVED / INVOICED but am not sure if a similar / equivalent can be done In Crystal (8.5)? I would like to think think such a "manual" formula could be placed in a report footer to pass the relevant results to a main report?
I'm new here (first post) and a relative novice with crystal so be gentle with me...
Thanks.