catssolutions
New member
- Local time
- Today, 09:14
- Joined
- Aug 13, 2007
- Messages
- 6
Hi all, I have a report that I want users to be able to change the groupings and or sorting of the report from a simple form.
They would have a droup down list of all the report fields and they can select how to group it Ie data, ref 1 or ref 2.
I tried doing a conditional grouping looking at the form field and typing =[field1] but this is not working.
What would be the best way about this?
any help would be deeply appreciated as I do not want to have 6 seperate reports for the same data
regards
They would have a droup down list of all the report fields and they can select how to group it Ie data, ref 1 or ref 2.
I tried doing a conditional grouping looking at the form field and typing =[field1] but this is not working.
What would be the best way about this?
any help would be deeply appreciated as I do not want to have 6 seperate reports for the same data
regards
