Crosstab Parameter

[cguyreports]

I have created a cross tab and for my column I have a date field and have selected for group options column to be printed for each week.

I would like to add a parameter to my report that changes my grouping option, I would like the user to have the ability to select, "printed for each week", "printed for each day", or "printed for each month".

Could anyone help me.
Thanks, so much!

 

[lbass]

Create a discrete string parameter {?Date Interval} with default options of "Day", "Week", and "Month" and then create a formula:

if {?Date Interval} = "Day" then {table.date}) else
if {?Date Interval} = "Week" then {table.date} -
dayofweek({table.date})+1) else
if {?Date Interval} = "Month" then
date(year({table.date}), Month({table.date}),01)

Use this formula as your column field. You do not need to set any group options, since the parameter will determine the interval.

-LB

 

[cguyreports]

Thank you I will try this. I really appreciate your time.