Why does my Parameter end up with a question mark

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

Why does my Parameter end up with a question mark

Author

Topic

icw
Constraint Violating Yak Guru

378 Posts

Posted - 2009-05-19 : 11:41:30

I am sending a parameter dynamically from my HEAT service desk software.
My URL is

http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fHEAT+Reports%2fPast+Calls+AlderleyA&rs%3aCommand=Render&Custid={|CallLog.CustID}

When the report server pops up it has the right name in the Parameter box but it always appears with a question mark at the end and therefore doesn't find any data.
e.g. If the Custid is SmithT the report shows SmithT?
I can't figure out why

TIA

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-05-19 : 13:19:45

where are you using above url?

icw
Constraint Violating Yak Guru

378 Posts

Posted - 2009-05-19 : 13:29:20

Using it from within the heat software.
it brings up a browser window inside a tab in the software

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-05-19 : 13:30:35

can you try the url directly and see if it renders report correctly?

icw
Constraint Violating Yak Guru

378 Posts

Posted - 2009-05-19 : 14:33:18

I can run it from IE. but not using exactly the same string. if you look at the string it is using it has a dynamic field at the end so if I run it in a web browser externally to the software I have to supply a parameter value.
so if i do

http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fHEAT+Reports%2fPast+Calls+AlderleyA&rs%3aCommand=Render&Custid=Adamsp

this works fine

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources