Hi,
I am working on a report that essentially tracks data for a collection of clients. I have used the page set function in the page toolbox in order to automatically generate one page per client. My report works as intended except for the fact that it generates pages for clients who do not have any data in my query.
To clarify, my report has filters in place which specify a certain date range. Not every client has information during this date range. Thus, I am generating blank pages for clients who do not have any information to display. My report has a singleton generated based on a field such as [client name] on each page. I think this could possibly be the issue since the singleton will repeat on each generated page. Is there a way to fix this or at least to filter out the blank pages?
Thanks