Attached please find a screen shot of something I am trying to work on. The top box is a text box which obtains the job number dynamically from a data set. The table itself used this value to find all machine numbers that are currently running that job number. So far this works out quite well. But I need some other ideas or some ideas on how to complete what I would like. In the second column I would like to place the current running totals from that machine. The totals are actually in SQL Tags. The only thing I am not quite sure of is how to add a SQL tag to a query so that it will display the proper data. Looking for ideas and/or suggestions.
Here is what would be an example. In the screen shot show you see machine 43 is running the job which is shown at the top. In the column next to the machine number I would like the SQL tag count43 which just so happens to be the SQL tag that contains the live count. In some cases we might have as many as 6 machine running the same job so you would see all 6 machines with their running totals, then maybe as an added bonus show the accumulated total at the bottom.
Thanks and have a great day.