sql server reporting services: How to read session variable and pass it as a parameter ? -- sql server reporting services

How to read session variable and pass it as a parameter ?

siddharthksinha NO[at]SPAM gmail.com
3/16/2005 9:27:13 PM

sql server reporting services:

Hi there

I am using MSSQL Server 2000 Reporting services to generate my web report,
my query regarding this is that i want to read session variable and pass
it as a repot parameter to the reporting server, in order to get the
desired report.I will be highly obliged if any body could help me out
in this issue.

from

SUMIT RAHI
Animon Software Solutions

Re: How to read session variable and pass it as a parameter ?

Paul Turley
3/18/2005 5:31:59 PM

If you want to pass a session variable, I assume that you are launching your
report from a webform or ASP page (?)
....if so, set the URL to a string like:
"http://localhost/reportserver?/MyReportFolder/MyReport&rs:Command=Render&rc:Parameters=False&MyParam1="
& Session.Item("MySessionVariable")

You could use this string to set the NavigateURL property of a HyperLink
control to either open a blank browser window or target a frame on the page.

Paul Turley, MCSD, MCDBA, MSF, MCT
nospam at scout-master.com

[quoted text, click to view]