Collection of data

  • Hi

    I have a report which has a matrix table, it is grouped on location so location 1, location 2 etc and in each location is a set of results. In the group footer is a couple of calculations which basically places an asterix if a criteria is not met.

    What I need to do is for each location if the cell contains a asterix then add the location to an array or collection so I can display the the locations in a text box which is at the top of the report outside of the matrix table.

    I have no idea on how to do this. Any advise on where to start?

    Thanks

    R

  • Can you move the calculations for the asterisk into the dataset, i.e. into the SQL? If so, you could perhaps create a second dataset sharing the logic to hold only the locations required for the text box.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply