Date Ranges and Grouping Issues

[floydian99]

Hello, I need some help on Grouping a set of Date Ranges.

I have a request for a report that would summarize data (Hours worked) based on a Date Range (Start Date and End Date). However the users want to enter in multiple date ranges (no set amount). So I created a Date parameter, and selected the Allow multiple values and Range values options on the Parameter. The problem now is creating a group based on the values they entered in the date range. If anyone would know how to group by the array that is passed back from the date range parameter, or if there is another work around to this solution I'd be greatful. Thanks!

 

[lbass]

You could create a formula {@daterangegroups}:

if {table.date} in {?date}[1] then "First Group" else
if {table.date} in {?date}[2] then "Second Group" else
"Third Group" //add as many clauses as the maximum number of date ranges the user can enter

Then insert a group on {@daterangegroups}.

-LB

 

[floydian99]

Thanks that helped kick start the ideas. Thanks for the help, its much appreciated. Got it to work.