Show mutltiple tables seperated by page breaks using Active Reports, C# and SQL Server

Question

I am using Active Reports 7 with C# and SQL Server. I have a query which has a parameter say AUDID. I want to show data based on this parameter as below.

1. when AUDID = AUD1, then show the data for AUD1, which gets the data from the SQL query

2. when AUDID = AUD1 and AUD2 which are checkboxes, then the same data should show on different reports 1 for AUD1 and the other for AUD2 (the same query is used to get the data for different AUD's)

3. when AUDID = ALL, we need to show a tabled data for each AUD in different pages

Could you please suggest me what can be solution to create such a report?

Thanks

Answer 1

is the data coming back as a single resultset? or do you issue two queries to get each AUDID?

if they are both in the same resultset then create a group on AUDID and you can set pageBreakAfter on the groupfooter so the new AUDID would end up on a new page.

if you would like send your requirements to tech support on our site activereports.grapecity.com and one of our engineers can help you further.