Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Blank chart, even though data is there Post Reply Post New Topic
Author Message
Rocquestar
Newbie
Newbie
Avatar

Joined: 02 Oct 2009
Online Status: Offline
Posts: 9
Quote Rocquestar Replybullet Topic: Blank chart, even though data is there
    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?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 13 Dec 2011 at 7:36am
try it in the report footer
IP IP Logged
Rocquestar
Newbie
Newbie
Avatar

Joined: 02 Oct 2009
Online Status: Offline
Posts: 9
Quote Rocquestar Replybullet 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...




Edited by Rocquestar - 14 Dec 2011 at 4:10am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
IP IP Logged
Rocquestar
Newbie
Newbie
Avatar

Joined: 02 Oct 2009
Online Status: Offline
Posts: 9
Quote Rocquestar Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.