That charting on print time formula issue

[AZdesertdog]

Using CR10 with MSSQL

I have a report that obtains a number of days by using a running total and then I need to associate a 'score' to that number with a formula such as:

if {#Days2Bill} >= 12 then 1 else
if {#Days2Bill} in 11.9 to 11.6 then 1.2 else
if {#Days2Bill} in 11.5 to 11.2 then 1.4 else
if {#Days2Bill} in 11.1 to 10.8 then 1.6 else
if {#Days2Bill} in 10.7 to 10.4 then 1.8 else
if {#Days2Bill} in 10.3 to 10 then 2

My goal is to have a simple gauge chart the points at a number between 1 and 2. But since the above is a print time calc I have to do that subreport deal for the chart. I've tried to follow the instructions on the cr9_charting_print_time.pdf but I think my solution should be much easier since I just want to pass one number back to populate the chart. I've tried making the above a variable and passing to the subreport but I keep getting a 'blank' chart even though I can see the shared variable in my subreport and on my main report. Any help would be appreciated. THANKS!

 

[hassanvoyeau]

Is the chart on the subreport based on the parameter field?

 

[AZdesertdog]

I think the answer is yes. I only have the subreport so that I can have a chart on the main report with this value. From what I read, I need to pass the value to the subreport and chart it there.

 

[AZdesertdog]

Is it possible to pass the print time data to a subreport and then back into a chart that lives on the main report or does the chart and data both need to live on the subreport?

 

[hassanvoyeau]

I am using 8.5 and I was not able to create a chart with fields other than fields from the tables themselves. So I am not sure how you are creating this chart with one value.

 

[Dan3D]

I think you could do this with our CRChart replacement library. The @DP macro would allow you to override the single data point in the gauge at "print time".

You can download a free eval here:

http://www.threedgraphics.com/tdg/noteworthy/crystalreports.asp

DISCLAIMER: This product costs money. I work for the company that makes this product. There may be other solutions that I am not aware of.

Dan Weingart
OEM Technical Manager
Three D Graphics, Inc.

http://www.threedgraphics.com