I am building a report which is going to be used as a sub-report from within several other master reports. The sub-report is pretty simple: one Table in the details section bound to a data source displaying a bunch of records, and a few header rows displaying column headers. I want to include a header which displays some information about the records on the page such as 'Records #1 through #20" on page 1 and "Records #21 through #40" on page 2, etc. This seems like the perfect application for the 'PageExec' function, however since I am using this as a sub-report anything in the Page Header and Footer will not be displayed. Is there a way to do such a header value on each page of a sub-report?
I also tried looking into using the 'RunningValue' function but was unable to figure out a 'scope' value which would allow me to do such a thing. Is it possible via some other method?
I also tried looking into using the 'RunningValue' function but was unable to figure out a 'scope' value which would allow me to do such a thing. Is it possible via some other method?