SQL Reporting, Pass Parameters from web form

Hello,

I am trying to pass a year and a user_id to a report that I created for SQL report.  I am trying to send the two variables to the report when they click on a link.  the variables are global also.  does anyone know how to go about doing this?
LVL 1
DB_FuryAsked:
Who is Participating?
 
tpi007Connect With a Mentor Commented:
Assuming the following:
RS Website: http://reportingsample.com
ReportFolder: FolderLevelOne
ReportName: SampleReport
 Parameters1: userid=fred
Parameter2: year=2010
http://reportingsample.com/Reports/Pages/Report.aspx?ItemPath=%2fFolderLevelOne%2fSampleReport&rs:Command=Render&userid=fred&Year=2010
 
 
 
 
 
0
 
DB_FuryAuthor Commented:
oh I guess i thought it was going to be more complicated than that! thanks
0
All Courses

From novice to tech pro — start learning today.