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?
willyou 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.
"willp" <willp@.discussions.microsoft.com> wrote in message
news:F5DEF118-8B44-40F8-B6ED-CA5F428DD259@.microsoft.com...
> 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?
> will|||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?
"willp" wrote:
> 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?
> will|||is the 'snapshot' xml data?
"avnrao" wrote:
> 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.
> "willp" <willp@.discussions.microsoft.com> wrote in message
> news:F5DEF118-8B44-40F8-B6ED-CA5F428DD259@.microsoft.com...
> > 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?
> >
> > will
>
>|||This is not currently possible in a reasonable way.
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||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
"Donovan R. Smith [MS]" wrote:
> This is not currently possible in a reasonable way.
> --
> Thanks.
> Donovan R. Smith
> Software Test Lead
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
Showing posts with label re-run. Show all posts
Showing posts with label re-run. Show all posts
Wednesday, March 28, 2012
Tuesday, March 20, 2012
Save Query Template
Does reporting service allow to save user input query ? i.e. If user re-run the report, their default selection criteria are displayed automatically.If you mean saving the values of parameters as a per-user default this is
not supported in v1.0, but it is on our wishlist.
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:FB6666ED-2AD1-4A0D-A707-94041C287732@.microsoft.com...
> Does reporting service allow to save user input query ? i.e. If user
> re-run the report, their default selection criteria are displayed
> automatically.
not supported in v1.0, but it is on our wishlist.
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:FB6666ED-2AD1-4A0D-A707-94041C287732@.microsoft.com...
> Does reporting service allow to save user input query ? i.e. If user
> re-run the report, their default selection criteria are displayed
> automatically.
Subscribe to:
Posts (Atom)