7 Replies Latest reply on Mar 14, 2014 4:10 PM by Stephen Huston

    Dynamic Reports using multiple sub-summaries

    SteveMartino

      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.

      Thanks

      Steve