Dynamic Reports using multiple sub-summaries

Discussion created by SteveMartino on Mar 13, 2014
Latest reply on Mar 14, 2014 by Stephen Huston

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.