Wednesday, March 28, 2012

Saving Parameter's Values

Hi,
I have a report with some parameters. Can the values users enter for those
parameters for a given report run be saved in a Database?
Basically we would like parameters to always default to the last values a
user selected the last time he/she ran a report.
Is this supported out of the box? Any ideas on how this can be achieved?
ThanksHello Christians,
Based on my scope, this feature is not supported at present. To work around
this issue, you may want to implement your own report viewer and manage
parameter in session by your self. You may want to refer to the following
link for some reference
http://www.codeproject.com/aspnet/SQLRSViewer.asp
Hope this is helpful.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>Thread-Topic: Saving Parameter's Values
>thread-index: AcXU98RsnhvZYJ8GSCyqm1Rk/oJ1nA==>X-WBNR-Posting-Host: 66.225.146.61
>From: "=?Utf-8?B?Q2hyaXN0aWFucyBJenF1aWVyZG8=?="
<christians@.newsgroups.nospam>
>Subject: Saving Parameter's Values
>Date: Wed, 19 Oct 2005 14:55:06 -0700
>Lines: 11
>Message-ID: <D65100A1-CEAD-4DB8-83E9-7C6D4B831EA9@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:54661
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Hi,
>I have a report with some parameters. Can the values users enter for those
>parameters for a given report run be saved in a Database?
>Basically we would like parameters to always default to the last values a
>user selected the last time he/she ran a report.
>Is this supported out of the box? Any ideas on how this can be achieved?
>Thanks
>

No comments:

Post a Comment