Looping through a dataset

crowt999

Hi all,

I have a need to search my dataset before displaying the rows on a report. If I find a row that I do not want to show, I can set a column to "N" or something like that.

I am using a scripted data set, and my basic idea was to loop through all of the rows retrieved in the 'beforeClose' event, secrching for the ones I do not want to show on the report.

Does anyone know if this is possible, or will work? Can I loop through the dataset as kind of a "pre-process" to clean up the data?

Many thanks
Dean