reporting views

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!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.
"James Huang" <jianh@.avanade.com> wrote in message
news:unjgemapEHA.324@.TK2MSFTNGP11.phx.gbl...
> 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!
>