Grouping based on Prompt on Date

[raja2008]

Hello Everyone!

Using crystal reports XI R2 .

I have a report with grouping based on date.

I was wondering if there is a way to change the grouping option to be changed between "Each day", "Each week" ,"Each month" based on the selection in a prompt.

Basically when the user picks "Day" from the prompt,the grouping should be on Day ,If they pick "Week" grouping should change to week.


Please help.

 

[lbass]

Use a formula like this as your group field:

if {?Parm} = "Daily" then
{table.date} else
if {?Parm} = "Weekly" then
{table.date}-dayofweek({table.date}) + 1 else
if {?Parm} = "Monthly" then
{table.date}-day({table.week})+1

When you insert a group on this, choose "on change of day".

-LB

 

[raja2008]

That works beaytifully,

Thank you very much.