5 Replies Latest reply on Feb 9, 2016 2:16 AM by Stu412

    Run a script quicker to capture variables and set fields


      Hi all


      I'm doing some work whereby I need to copy around 15 variables from a data table to a warehouse/reporting table.  This is to reduce lag time when running the report as there are many summaries involved over many columns.


      The question I'm looking for help on is regarding the speed of the script.  Currently, I set 15 variables, change layout, set 15 fields, end.


      Is there a way that the whole 'set variable x 15, change layout, set field x15' routine could be made faster?


      The script itself is really basic, literally 15 rows of variable setting, change a layout, 15 rows of field setting.  The variables themselves are based on summary calculations from a found set of around 400 records on average.


      Thanks in advance