Interate through a dataset

  • I will try to explain this as best I can and as briefly as I can.

    I have setup a blank "shell" report. This report is passed an ID parameter which is used to pull two datasets. The first dataset will use dthe ID to pull the header information. In that dataset, I use one of the fields to tell me the "type" of inspection this ID refers to. That type is used as a parameter for the 2nd dataset that calls a sproc that will return a variable number of rows that indicates how many subreports will be needed on this report.

    My question is: how do I iterate thru this 2nd dataset in order to toggle visiblity/call/add the correct subreports? I see the functions for FIRST/LAST/ROWNUMBERS w/ scope but I'm not sure if this is what I need.

    If this is an easy question, I apologise in advance. However, any/all responses are appreciated! 😀

    Tomm Matthis

Viewing post 1 (of 1 total)

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