Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Pulling up a SQLReport using URl Parameter

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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

597 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