Is This Possible,

[tonygr]

I have a report with a select statement which brings up records defind by user i.e. dates. this report is often used as a monthly report so :1/1/06 to 31/1/06.
What I would like to do is to be able to show in another graph the same infomation but for a longer date period i.e. 1/1/03 to todaysdate, so it acts of its own accord.
The way in which i envisage this happening is through a formular and then us the chart expert and select this formular as a column or whatever. I know the normal route for this type of thingy is to create a subreport or open up the select to include these records then suppress other info via formulars. Can anybody shed some light and give some much appreciated guidance.
regards in advance
Tony

 

[Madawc]

You can write a formula field that creates various intervals. I did one with code like

if Year({Command.Birthdate})< 1985
then "a) Before 1985"
else
if Year({Command.Birthdate})< 1993
then "b) Year " & Totext({@Customer_24}, "yyyy")
else
"c) Month " & Totext({@Customer_24}, "yyyy") 
         & " mth " & Totext({@Customer_24}, "MM")

I've done this for both charts and crosstabs, in Crystal 10. I think version makes a difference to what crosstabs will accept, and you should always say what your version is.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[tonygr]

Thank you for the quick responce.
Sorry About That,
Crystal version XI developer edition.
Your responce seems to be in line with what i was thinking.
I will have a play and let you know how it goes.
thanks
Again
Tony