sql server reporting services: reporting views -- sql server reporting services

reporting views

James Huang
9/28/2004 6:22:13 PM

sql server reporting services:

Hi

We are using SQL reporting services as the reports engine on our projects.

Some reports come with a table view and a chart view. User wants to see
(print) the table report first by default. The chart report is optional.

The original approach is to have a link (button) on the first report; user
can click on it to see the chart report. However, since two trips will be
made to the data source, user might see different data because of the delay.
Is there a way to avoid that? We want two reports to have the same data.

Does SQL reporting service provide "Views"? So users can retrieve the
report and select different views without going back to the data source?

Thanks in advance!

Re: reporting views

Brian Welcker [MSFT]
9/29/2004 6:39:38 AM

You can't build two different reports on the same query execution but what
you could do is have both the table and the chart in the same report. Set
the visibility propery on each to a parameter that tells which to display.
Have a link on the report that toggles between them.

--
Brian Welcker
Group Program Manager
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]