Solved

Pulling up a SQLReport using URl Parameter

Posted on 2006-07-13
5
1,830 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 250 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

How to increase the row limit in Jasper Server.
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, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

690 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