?
Solved

Pulling up a SQLReport using URl Parameter

Posted on 2006-07-13
5
Medium Priority
?
1,831 Views
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

"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
Comment
Question by:csmithivh
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
5 Comments
 
LVL 14

Accepted Solution

by:
simon_kirk earned 1000 total points
ID: 17106143
0
 

Author Comment

by:csmithivh
ID: 17107615
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
 

Author Comment

by:csmithivh
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
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
 

Author Comment

by:csmithivh
ID: 17110171
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
 

Author Comment

by:csmithivh
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.

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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

762 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