SQL Server Performance Forum – Threads Archive

URL Parameter

I’ve got the parameter set in the URL, but the report isn’t rendering the data. Is there something I have to set for the Report Parameter?
I’ve got:
Default Value = "None"
Available Values = "Non Queried" The prompt is still showing….could this be the issue? If I copy from the URL the value I want to pass, then click View Report, it works. I want the user to NOT have to do this. The SQL is: SELECT * FROM WPG WHERE (WPG.WP_PID = @URLParam) The name of the parameter is URLParam.
Thanks!

---

In Crystal Reports, you can use CR.ShowpopupMenu=False from the Front End See if you are able to simulate the same in Reporting Services Madhivanan Failing to plan is Planning to fail

---

Thanks for the info! I got the URL parameter figured out.

---

Well. Can you tell us how you solved it? Madhivanan Failing to plan is Planning to fail

---

I wish I could….but am not too sure how I got it to finally work. I went through the "Hitchhiker’s Guide" over and over till I got it right. Thanks!

---

]]>