Grouping on variable intervals #2 1

[suecobb]

I found a post on grouping on variable intervals, but it's not quite what I'm looking for. I am using Crystal 10 and the report runs against a .ttx file passed in from an application. I have data with a date field and I need to group on the date field based on the interval the user chooses at run time. I'm guessing this will be passed to me as a parameter, but I don't have that information from the programmer yet. The choices presented to the user are day, week, month, quarter, or year, so it's more complicated that just the number of days in each interval. It will have to take into consideration what day each interval starts. Any ideas? Is there an easy way to do this?

 

[lbass]

Set up a parameter {?Interval} with options like "Annually", "Quarterly", etc., and then create a formula to insert a group on:

select {?Interval}
case "Annually" : date(year({table.date}),1,1)
case "Quarterly" : date(year({table.date}), (datepart("q",{table.date})*3)-2,1
case "Monthly" : {table.date}-day({table.date}) + 1
case "Weekly" : {table.date}-dayofweek({table.date})+1
case "Daily" : {table.date}

-LB

 

[suecobb]

Thank you so much! I'll try it.