asked on

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

ASKER CERTIFIED SOLUTION

simon_kirk

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

csmithivh

ASKER

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

csmithivh

ASKER

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

csmithivh

ASKER

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

csmithivh

ASKER

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