Accessing QueryString from within a report.

I have a situation where MSRS is being used as a part of a number of web
based applications.
One of the requirements of these applications is that a SessionID can be
logged with every call made to an application component. The purpose of
this is to allow end-to-end auditing of all the user actions that have been
taken during the course of a session
The strategy that we were going to take with MSRS was to include a dummy
parameter SessionID in every report and then extract that parameter from the
MSRS logs. This strategy comes unstuck when snapshots are used. Parameters
in request for the rendering of a report based on a snapshot are discarded,
and the original parameters are placed in the execution log.
I was wondering if anyone else had come across a way to access the
querystring or user entered report parameters on a snapshot based report.
regards,
Adrian.Hello Adrian,
Based on my scope, it seems this behavior is as designed and we are not
able to access the query string when execution the report.
The workaround is to use a Web appliatoin and a proxy to reporting services
so that you will get more customized features. Also, it will bring more
coding work. The following link is just for your reference:
http://www.codeproject.com/useritems/SQLRSViewer.asp
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.
| Reply-To: "Adrian Russell" <adrianru@.avanade.com>
| From: "Adrian Russell" <adrianru@.avanade.com>
| Subject: Accessing QueryString from within a report.
| Date: Wed, 20 Apr 2005 09:25:19 +1000
| Lines: 22
| Organization: Avanade
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <OtdNRcTRFHA.3496@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 220-245-208-182-act.tpgi.com.au 220.245.208.182
| Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP1
2.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:48136
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I have a situation where MSRS is being used as a part of a number of web
| based applications.
|
| One of the requirements of these applications is that a SessionID can be
| logged with every call made to an application component. The purpose of
| this is to allow end-to-end auditing of all the user actions that have
been
| taken during the course of a session
|
| The strategy that we were going to take with MSRS was to include a dummy
| parameter SessionID in every report and then extract that parameter from
the
| MSRS logs. This strategy comes unstuck when snapshots are used.
Parameters
| in request for the rendering of a report based on a snapshot are
discarded,
| and the original parameters are placed in the execution log.
|
| I was wondering if anyone else had come across a way to access the
| querystring or user entered report parameters on a snapshot based report.
|
| regards,
|
| Adrian.
|
|
|