Hello Forum, trying to see if the following is possible.
I have 5 different reports set up (based on the same table). I am trying to do this off of one report.
I know I can have multiple sub summaries set up on the same report. Then by clicking "Sort Records..." in the records menu, I get the report I want. That works fine.
What I'm trying to figure out is can I create a field to pick which report I want, pass the report name dynamically to sort, rather then open up the sort menu and manually change the field to sort on.
If it's possible, I think I'm almost there, if it's not, I spent alot of time figuring out what not to do. I tried a script that, based on the report picked, runs a simple script. That gives me 1 report, 1 main script, with 5 hard coded sorts. This might be all I can do. Just don't know if (how) I can pass the field I want to sort by dynamically.
Any help or guidance would be greatly appreciated.