Chart results for parm on sub-report

[LT2]

Using CRXIr2 w/SQL Svr

I wrote a SQL script as the command for a Client Treatment History report that includes: clientid, treatment date, service code, units, cost, payor & invoice num.

I have a chart I created through Advanced Chart Expert to change on group2 clientID (desc), (Top 10) and Sum of @ActualPd to display The Top 10 Most Expensive Clients based upon the amounts paid for each.

Does anyone know if I could use the results of this chart (using clientid) as a paramter for a sub-report to give further statistics on these particular clients? If so, how could I do this? I'd have to reference the clientid in my sub-report script but unsure how to reference a chart result.

Any ideas welcome.
LT

 

[Madawc]

If you duplicated the 'chart result' in a formula field, that could be passed to a subreport in a lower section. Does that help?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Do you mean you want to drilldown from the chart? You can do that with group charts, without using a sub. So if you have a group in your main report with an inserted summary, you can do a group sort and then you can hide the group and details sections, and then insert a chart in the report footer. Then you can drill into individual group instances by clicking on the bar.

-LB