Posted 29 January 2018, 5:57 pm EST
I have a project where we need to create reports for a SQLite database. We do not have an ODBC driver so we are using a data set provider in Active Reports. We have had great success with this.
One of the requirements is to create a single report of nine single page reports. We created and ran all of the single page reports just fine. When I created the single report with sub reports, I setup code to change the data set based on sub report.
Now every page was then adding a blank page. So for a report that was supposed to be 9 pages is now 18.
Since I had created all the complex reports and separate queries, I used the method to change the data set between reports.
To further test our situation, I created a simple project that duplicates the issue just using data sets and no database as attached. I really need a solution as creating two copies of the reports is not feasible. Is there a setting I am missing?
