Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Create new report page per batch?

Author  Topic 

djorre
Yak Posting Veteran

94 Posts

Posted - 2009-07-24 : 07:08:05
Hi friends,

I got a question. I use a web application with a reportviewer control. In the application the user can choose a number of batches to run a report on. These batch numbers (variable ammount) go (comma-seperated) into one off the report parameters, the fired stored procedure splits them and returns a query in the form of batchNr, Values.

In order to split the batches in the report I could use grouping on the batch column, but I want it different. I want every batch starting on a new report page. So that the previous batch ends at a page, and the next batch is on the next page.

I was told that you could do this with sub-reports but I don't see how. So i'm stuck. Can anyone please help?

Thanks in advance, Joris

   

- Advertisement -