Crystal Reports 2008 - Graph Help

I have a line graph, which plots two items. One of those items is a "Target" line, but the target needs to change each month (without me going in a moving the line each month).

The graphs work great when there is more than one group returned on the X axis. Unfortunately, my Target line does not appear if only one group is returned on the X Axis.

Graph Configuration: Line Chart, plotting two lines. One of the lines I have formatted the series to display as a Riser.

I have attached my graph configuration, as well as a visual of what I'm trying to do.
graph-issues.pdf
LVL 14
LinInDenverAsked:
Who is Participating?
 
PCIIainConnect With a Mentor Commented:
Alternatively, can you fudge the data to add a single entry for a group where the group field is ' ' and the value is 0 (with the target field set)? Then you'd get a minimum of two bars, but one would have no header and no value....
0
 
PCIIainCommented:
Hmm, would it make sense to alter the graph to show entries on the X axis even if the value if 0?

Eg, if this is sales, by salesperson, list all the salespeople even if they have sold nothing in the period?

Then there'd be more than one entry on the X-axis and this problem would be hidden.
0
 
LinInDenverAuthor Commented:
Hi PCIIain - I'll play with it a little bit. I was thinking about "the fudge" as well  - I'm just not sure if I can do it predictably with only those with one market.

It is basically a report by Market - some markets only have one location, while others have more than one.
0
 
LinInDenverAuthor Commented:
Hi PCIIain - I'll play with it a little bit. I was thinking about "the fudge" as well  - I'm just not sure if I can do it predictably with only those with one market.

It is basically a report by Market - some markets only have one location, while others have more than one.
0
 
PCIIainCommented:
I wouldn't bother, Just have a dud column at the beginning of the graph each time. As long as you don't wind up with too many locations, it'll not make enough difference.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.