Dynamic grouping by formula

[ker0k3n0]

Hello everyone,

I am working on a report, that would prompt the user to select grouping by Date or by Name. So I create two group formulas using case: if user select 1, Group1 = Date, Group2 = Name. If the user select 2, Group1 = Name, Group2 = Date. But when i run the report, i get an error message asking the date needs to be a text field.

If i convert it to text field, the date is not sort in order anymore, i.e 7/1/10, 7/10/10, 7/2/10... since it is text fields now. How do I make my dynamic grouping to work with date or text fields?


Thanks for your time!
Phoebe

 

[IanWaterman]

Change you text date to Format 'YYYYMMDD'

This will then sort correctly, if you want group to display in normal format, then go to change expert and use a formula for Group name to show preferred format.

Ian