Pass UniqueID to Report Server =>no dropdownlist)

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

Pass UniqueID to Report Server =>no dropdownlist)

Author

Topic

bubberz
Constraint Violating Yak Guru

289 Posts

Posted - 2005-07-22 : 11:17:41

Here's my situation:

I've got a hyperlink, and will append a uniqueID to the link in order to pull specific information so the user doesn't have to sift through 500+ IDs from a dropdownlist. They will be taken to the report server and automatically get information for a specific ID w/o using the dropdownlist.

I'm trying to look in my book, and it looks like the hyperlink's NavigateURL will be something like (my field would be PackageID):

"http://servername/ReportServer/"&Fields.PackageID.Value.

Does this look correct?

I'm also having trouble setting the report parameter in order to use this value in the URL.

Thanks!

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2005-07-22 : 13:05:23

You need to have some rs: and rc: pieces on your URL or in a Form. See this MSDN article for more info.

---------------------------
EmeraldCityDomains.com

bubberz
Constraint Violating Yak Guru

289 Posts

Posted - 2005-07-22 : 13:13:41

Thanks AjarnMark!

I'll check it out!

jhermiz

3564 Posts

Posted - 2005-07-22 : 13:29:20

See this as well:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=52572

Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url]

bubberz
Constraint Violating Yak Guru

289 Posts

Posted - 2005-07-22 : 13:49:16

Thanks jhermiz/AjarnMark!

I've got the UniqueID in the URL, it looks like the report is still looking for something in the SQL WHERE clause. Is there some setting I have to change in Report Parameters? I'm sure that's probably where it is.

Thanks!

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2005-07-22 : 14:15:39

In the Dataset definition you can map the query parameters to the Report parameters. Or, if you name them the same, they will automatically map. ALL report parameters (except possibly those that have defaults) have to be passed in on your URL.

---------------------------
EmeraldCityDomains.com

jhermiz

3564 Posts

Posted - 2005-07-22 : 15:11:29

Not to mention the issues that may arise from parameters that accept nulls :).

It would help to post your stored procedure and the listing of all your parameters and whether or not nulls are allowed.

Jon

Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url]

bubberz
Constraint Violating Yak Guru

289 Posts

Posted - 2005-07-22 : 16:17:13

Here's the query:
SELECT * FROM WP_GInfo
WHERE (WP_GInfo.WP_PID = @WPPIDParam)

For @WPPIDParam, I've set it's expression as:
= Parameters!WPPIDParam.Value

Available Values are "Non-Queried"
Default Values are "None"

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2005-07-22 : 16:46:33

SO, is that the UniqueID that you referred to previously that was being passed in on the URL? Make sure the spelling is the same as the Report Parameter name. Otherwise it looks like it should work okay. Getting any particular message or just no records returned?

---------------------------
EmeraldCityDomains.com

bubberz
Constraint Violating Yak Guru

289 Posts

Posted - 2005-07-22 : 16:52:49

Here's how I set the hyperlink:
Dim strWPPID = Request.QueryString("WPPID").ToString()

HyperLink1.NavigateUrl = "https://server/Reports/Pages/Report.aspx?ItemPath=%2fMigration%2fWP&WPPIDParam=" & strWPPID & ""

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources