SQL Reporting Services - Anyone an expert?

imnotso

Can I have tabbed reports ie (more than 1 report using on sp) on SQL reporting services 2000? So it would look similar to more than 1 Excel spreadsheet. Any help welcome... Harvey

Mark J Miller

I'm working on a project which loads 8 reports at once. Each report queries the same data but just aggregates it differently. So what I had to do was 'preload' the data first, aggregate it and store the results (the aggregates not the actual data - too much) in a permenant table. Then I load the reports and they each just query the results table and display the reports (charts). The reason for this approach was that the query which was common to each report took at least 3 minutes to run and sometimes a lot more. I haven't investigated what you're suggesting, and I'm using 2005. But I don't think it's possible as each report uses a separate connection and they don't load syncronously.

Mark's blog: developMENTALmadness.blogspot.com

imnotso

Thanks Mark, but I'm just running one query, say on sales in a year, I then want the report to split into 12 tabbed reports, one for each month. Is this possible in SQL reporting Services 2000, I have been told someone has seen it once !!

Mark Churchill

You can filter your dataset from your sproc after the fact for your table/matrix.

Mark Churchill Director Dunn & Churchill Free Download:
Diamond Binding: The simple, powerful, reliable, and effective data layer toolkit for Visual Studio.

imnotso

Hi, Thanks for the help Mark, Filter my dataset in reports designer you mean? Harvey

Mark Churchill

Yep, on the tabled data region you should be able to set filters. Fine for smaller datasets. If the dataset you are getting back from your sproc is large, I'd probably lean towards filtering it server side and getting one dataset for each month...

Mark Churchill Director Dunn & Churchill Free Download:
Diamond Binding: The simple, powerful, reliable, and effective data layer toolkit for Visual Studio.

imnotso

Hi, that works but if filter is set to January I only get back January data of course, someone claims to have seen 1 query produce 1 report but with 12 tabbed sections, much like an excel spreadsheet with 12 workbooks. I'm not sure this is possible. Any one know ?