Technical Questions: Blank chart, even though data is there

Print Page | Close Window

Blank chart, even though data is there

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15149
Printed Date: 02 May 2024 at 4:18am

Topic: Blank chart, even though data is there

Posted By: Rocquestar
Subject: Blank chart, even though data is there
Date Posted: 13 Dec 2011 at 7:12am

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?

Replies:

Posted By: DBlank
Date Posted: 13 Dec 2011 at 7:36am

try it in the report footer

Posted By: Rocquestar
Date Posted: 14 Dec 2011 at 3:50am

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...

Posted By: DBlank
Date Posted: 14 Dec 2011 at 4:00am

the header version will not work because you are using variable formulas with whilprintingrecords.

I have not tried to use this type of data in a chart so I am not sure how it would act on the 'for each record' option.

I would play with those options a bit to see how it impacts the chart.

Posted By: Rocquestar
Date Posted: 14 Dec 2011 at 4:12am

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.

Print Page | Close Window