• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1842
  • Last Modified:

Pulling up a SQLReport using URl Parameter

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

"http://ivhsqld/Reports/Pages/Report.aspx?ItemPath=%2fIVHTraining%2fTraining+Request"

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

Regards
0
csmithivh
Asked:
csmithivh
  • 4
1 Solution
 
csmithivhAuthor Commented:
Simon,

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

"=Fields!ParticipantID.Value"

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

Chris
0
 
csmithivhAuthor Commented:
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
http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fTraining+Request

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


Chris
0
 
csmithivhAuthor Commented:
Another thought as I continue working with this ...

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

example:
in vs2005 goto "Report" then "Report Parameters"

to make this work?

Chris
0
 
csmithivhAuthor Commented:
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.

http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fTraining+Request&ParParticipantID=2

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

http://ivhsqld/Reports/Pages/Report.aspx?ItemPath=%2fIVHTraining%2fTraining+Request&ParParticipantID=2

Any Ideas??

Chris
0
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

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now