Groups | Blog | Home
all groups > sql server reporting services > september 2004 >

sql server reporting services : saving report data within rdl


willp
9/16/2004 5:27:01 PM
is it possible to include the data results from the query into the .rdl?
then rather than re-run the query each time, the viewer could see the report
with data and then be given the option to refresh? would i have to extend the
schema for rdl to do this?

avnrao
9/17/2004 12:54:47 PM
you can use snapshots. snapshot runs the report (at regular intervals if
specified) and stores the data. when asked for snapshot with ID, it renders
that particular data.

[quoted text, click to view]

willp
9/22/2004 1:33:02 PM
is the 'snapshot' xml data?

[quoted text, click to view]
willp
9/22/2004 2:01:48 PM
let me clarify..I'm hoping that I will be able to have one file that is an
..rdl xml file that contains the snapshot data and all the report formating
and query information as well. is this scenario possible?



[quoted text, click to view]
Donovan R. Smith [MS]
9/23/2004 10:01:45 AM
This is not currently possible in a reasonable way.

--
Thanks.

Donovan R. Smith
Software Test Lead

willp
10/5/2004 10:47:02 AM
so then the only way to do this (deliver the data, query and the formatting
information) is by creating a .RDL file (which is XML) and a snapshot file
(which is NOT XML)..and delivering both of these to the consuming
application..

is this correct?

willp



[quoted text, click to view]
AddThis Social Bookmark Button