How to chart based on formulas using summary fields?

[SteveBell]

I'm using CR v8.0 connecting to Baan ERP via the DLL interface.

I've developed a report that:[ol][li]Retrieves[ul][li]relevant inventory transactions for each part from the transaction history (to establish a usage level for the last 12 months)[/li]
[li]part-specific info (standard price, safety stock level) from the item master table[/li][/ul][li]totals the transaction quantity by part[/li][li](this is the tricky part) uses formulas and global variables to figure out how much of the value of the existing inventory will be consumed during consecutive four-week periods[/li][/ol]Here's an example of the output:

Part On-Hand Price Value Yearly Month Month ... Month Month
                            Use     1     2         5     6
   1     100   $20 $2000    240  $400  $400 ...  $400    $0

Further grouping takes place based on the family of the part number and groups of families.

Now for my questions:[ol][li]I want to draw a bar chart of the monthy numbers, but I can't because I use summary functions in the formulas to split the dollars up into buckets. Is there a way to fool CR into doing this, perhaps by passing the values to a subreport?[/li][li]Can I use a different technique to get the numbers split into the monthly buckets? Remember that I get the Yearly Use by adding up only some of the inventory transactions.[/li][/ol] Steve Bell

 

[kenhamady]

The only way to pass numbers to a subreport is as links or shared variables, and CR doesn't like to chart on either of these.

Post one of your formulas that uses a summary operation, and lets see if we can get to the same place without the summary. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.