Is there a way to allow user specific sorting in reports? The users have limited access to what they can view, but there are a few fields I would like them to have the option to sort by. LastName, EntryDate, CategoryofCare.
Is there a way to allow user specific sorting in reports? The users have limited access to what they can view, but there are a few fields I would like them to have the option to sort by. LastName, EntryDate, CategoryofCare.
I suggest you have a form with reports and selections available.
Then select, push a button and the proper report in appropriate sort order is presented.
See Martin Green's site for more info.
Thanks, I have kind of altered the way I am doing this and now have an Option Button "SchedulerStatSelect" with 4 radio buttons in it indicating the field to sort by. I wanted to have it so one of the buttons is selected and then a button for the desired report is run. For instance if they select 'Last Name' radio button and then click on the 'Routine Report' command button, it would run the Routine Report that is sorted by last name.
Edit: Figured it out using Cases Now if only I could stop being blind and figure out how to mark this as solved
Last edited by Ekhart; 08-10-2016 at 08:21 AM.