Min and Max of Group Series
Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20068
Printed Date: 18 May 2024 at 2:00am
Topic: Min and Max of Group Series
Posted By: EddiRae
Subject: Min and Max of Group Series
Date Posted: 30 Sep 2013 at 8:48am
Hello,
I have a chart that I need to display ages across the bottom. I can give the minimum age and the maximum age, but I want ALL ages in between to be displayed.
For example, if my data has an age of 15 on one record and then 20 on the next record, then I need to have a place holder form 16, 17, 18, and 19.
Any thoughts on how to accomplish this?
Thanks in advance,
Eddi Rae
|
Replies:
Posted By: lockwelle
Date Posted: 30 Sep 2013 at 9:26am
a stored proc could do this...I was going say a command object for an excel spreadsheet (or a numbers table) and somehow filter out the values that are over/under the max/min.
should be fairly simple in a stored proc with a numbers table to fill in the missing values.
HTH
|
Posted By: EddiRae
Date Posted: 06 Oct 2013 at 3:22am
There isn't going to be anything that is under the minimum or over the maximum.
I need ALL the values between the minimum and maximum to show on the graph even if I don't have values to chart. That is my predicament.
Thanks for your help in advance
Eddi Rae
|
Posted By: lockwelle
Date Posted: 07 Oct 2013 at 4:46am
here is why I said filter out the values outside of the min/max...
you need a numbers a table, or the concept of a just a bunch of numbers that you can join on to fill in the missing values. Crystal won't print what isn't in the dataset, so you need to get the missing values into the set...but if you min is 3 and your number table starts at 0, you will need to remove the 0.1.2....
In a stored proc you could just add in the values that are missing, but it's the same difference, as again you would joining to a numbers table.
The trick is to add in the missing values
|
|