I have a report on CR-XI that uses two subreports to gather information, then I perform a simple calculation on the result, which I would like to graph on a line chart, but the chart doesn't show up.

details:

DSO (Days Sales Outstanding) = ARBalance / 365 Days Sales
subreport1 gathers ARBal from the GL.
subreport2 gathers 365 Days Sales
subreports are inserted in the main report section "Da"
subreport contains the Formula variable to gather the value:
i.e.)

WhilePrintingRecords;
Shared NumberVar myAcctBal := Sum({GL.AccountBal})
 #(Selection criteria exist for the one account I need)

Main Report Section "Db" contains the Forumla Variable that extracts the subreport returned value:
i.e.)

 WhilePrintingRecords;
 Shared NumberVar myAcctBal;
 myAcctBal

Main report has a formula to calculate DaysReceivables as ARBal/365DaysSales

Main report is grouped by month.

So, the report detail looks like this:

 Oct, 2010    83829.78    707293.28    43.3
 Nov, 2010    81107.47    700730.07    42.2
 Dec, 2010    88303.85    697045.39    46.2
 Jan, 2011    78687.77    687228.38    41.8
 Feb, 2011    85644.65    692134.55    45.2
 Mar, 2011    91203.92    684341.16    48.6
 Apr, 2011    84246.91    680742.19    45.2
 May, 2011    89612.86    692837.29    47.2
 Jun, 2011    94767.42    625402.05    55.3
 Jul, 2011    96052.19    691731.30    50.7
 Aug, 2011    99620.07    700320.09    51.9
 Sep, 2011    96502.75    704092.22    50.0
 Oct, 2011    91834.68    638864.94    52.5

I insert a chart in the report header (or footer) to show the DSO over time, thusly:

Line chart:

for each record (Month)
show @DaysReceivables (Don't Summarize)

But, the chart is blank.  Not just no data, but no chart at all.  (It exists, I can select it, and the outline appears when I hover over it, but theres nothing there!)

Is this a bug, or a problem with the way I've set up the chart?  Can anyone help?

I put the same chart into the report footer, and got a slightly different, but equally inconclusive result. 

While the header chart is blank (no outline, no grid lines - nothing), the footer chart shows the outline and axes, etc, but only one data point that has (the date and value of) the last point in the data set.  The range axis shows the date (of the last point) and then record numbers (1, 2, 3, ...) for the remainder of the data, but no values.

I'll try to post a screen shot...




Edited by Rocquestar - 14 Dec 2011 at 4:10am

DBlank:

THanks for the input.  I'll eliminate the prospect of a header chart (it doesn't matter if it's in the header or footer to me)

See the last post, which I edited to include the footer screenshot.

I've played quite a bit, but can't get anything better than you see above.  I'll keep at it, though, and post any updates here.