Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: How to Zero out values from a line graph Post Reply Post New Topic
<< Prev Page  of 3
Author Message
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 01 Sep 2011 at 5:36am
you are stumping me on this one...
lets try 2 formulas
lets convert the date field to the first of the month (call it "DateConverted")
dateserial(year(table.date),month(table.date),1)
Let's convert the tabledescription to another text (call it "NewText")
if table.tabledescription = "table1" then "SALE" else
if table.tabledescription = "table2" then "RETURN" else 'ERROR"
 
in your chart on change of use @DateCOnverted set to monthly and then @NewText under that
in the Show Values continue to use Struc_ID set to count
 
Does this give you anything better?
IP IP Logged
moontide
Groupie
Groupie
Avatar

Joined: 23 Feb 2011
Online Status: Offline
Posts: 78
Quote moontide Replybullet Posted: 01 Sep 2011 at 7:19am
I used all the instructions you put forth. Now, in the legend box I see a green line saying 'Sale', a yellow line saying 'Return' and a blue line saying 'Error' and the lines are again, all over the chart.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 01 Sep 2011 at 7:30am
OK.
Go into the select expert and add in a criteria
Not (isnull(table.date))
that should get you down to only have 2 Legend Entries and the 'ERROR' label should be gone.
 
Let's make another formula and call it "counting"
if isnull(table.struc_id) then 0 else 1
now in the chart expert replace your Show Value with the new formula field @counting set as a SUM (should defualt to that)
Does this give you what you wanted/expected?
IP IP Logged
moontide
Groupie
Groupie
Avatar

Joined: 23 Feb 2011
Online Status: Offline
Posts: 78
Quote moontide Replybullet Posted: 01 Sep 2011 at 7:53am
Ok I did all of that, but I'm getting the same results as before. No change.  I see all three lines again.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 01 Sep 2011 at 8:50am
I'm stumped at this point.
IP IP Logged
moontide
Groupie
Groupie
Avatar

Joined: 23 Feb 2011
Online Status: Offline
Posts: 78
Quote moontide Replybullet Posted: 01 Sep 2011 at 9:08am
I was stumped myself and tried everything, nothing worked. I may just have to do seperate charts for each count and work it from there which is the only other option, but thanks for the effort you put in to help..really appreciate it!!..THANKS again !.
IP IP Logged
<< Prev Page  of 3
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.