Pulling up a SQLReport using URl Parameter

Posted on 2006-07-13
Medium Priority
Last Modified: 2008-06-30
I'm new to SQL Reporting services and I think I'm close but can't seem to make it happen.

I am delevoping my report using Visual Studio 2005

I have a .RDL that looks like a paper form and the underlying table has two records in it

When I launch the report I can click on the next page button and the next record information is now in the form. That part is working perfectly.

In the form I have a "ParticipantID" field and in the underlying table I have a "ParticipantID" field (this field is the primary key)  

I want to call the report using a URL

the following URL works perfectly


Now the problem...

What I really want to do is pull up the specific record by passing the "ParticipantID"

I thought it should be something like this ...

"http://ivhsqld/Reports/Pages/Report.aspx?ItemPath=%2fIVHTraining%2fTraining+Request&rs:Command=Render& ParticipantID =2"

the url does not work as I hoped it brings the report up but brings me to my first record not record number 2

I am hoping some one can help me pull up ParticipantID =2

Question by:csmithivh
  • 4
LVL 14

Accepted Solution

simon_kirk earned 1000 total points
ID: 17106143

Author Comment

ID: 17107615

Thank-you for trying to help me.

Neither of your suggestions work...
I am assuming they work for you (that you tested your suggestion) and if that is the case I am wondering if there is a setting in the design of the report that I have incorrect.

Maybe a setting on the report server that the report resides on.

In the design of the report I have the following field "ParticipantID" with a value of


Is there something, maybe a property that would need to be turned off ... something that would override a url parameter?

More background - I do not think this should matter but I first built the form in access and I imported it


Author Comment

ID: 17108009
another clue.... maybe

I put the report on another report server and when I modify the url and attempt to pull up the report ..  I get a common message

"Reporting Services Error
An attempt was made to set a report parameter 'ParticipantID' that is not defined in this report. (rsUnknownReportParameter)

SQL Server Reporting Services "

Example url "http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fTraining+Request&ParticipantID=2&rs:Command=Render"

Example that does pull up the report

I can see the field that is named "ParticipantID" so it doesn't look like a versioning problem.


Author Comment

ID: 17110171
Another thought as I continue working with this ...

When I am designing the report... do I have to add a parameter

in vs2005 goto "Report" then "Report Parameters"

to make this work?


Author Comment

ID: 17111258
I'm close but not quite there ...
on my local machine
I added a parameter as described in my previous comment and made it hidden and loaded it to my local machine.


Works Great!

I loaded the same form to my server and

I get

The 'ParParticipantID' parameter is missing a value

when I go to the following  URL


Any Ideas??


Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…
Watch the video to learn how one can deal with PST file corruption issue with an outstanding Kernel for Outlook PST Repair Tool easily. Using this tool, non-technical users can swiftly perform the repair process to restore their essential data witho…

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question