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.
Author |
Topic |
jodpro32
Starting Member
5 Posts |
Posted - 2005-06-30 : 11:43:11
|
I am working with an application that is allowing me to do a redirect when a button is clicked. I want to redirect them to one of my SQL Reports, BUT the URL I am trying to give it has a question mark in it and the application does not like it. Any suggestions on how to remove the question mark from the url and get the link directly to my report to work?Here is the link:http://localhost/reportserver?/ReportProject2/ShipmentDetailsReportMy report is ShipmentDetailsReport in the ReportProject2 directory...Thanks for helping me!!! |
|
jhermiz
3564 Posts |
Posted - 2005-06-30 : 12:11:05
|
quote: Originally posted by jodpro32 I am working with an application that is allowing me to do a redirect when a button is clicked. I want to redirect them to one of my SQL Reports, BUT the URL I am trying to give it has a question mark in it and the application does not like it. Any suggestions on how to remove the question mark from the url and get the link directly to my report to work?Here is the link:http://localhost/reportserver?/ReportProject2/ShipmentDetailsReportMy report is ShipmentDetailsReport in the ReportProject2 directory...Thanks for helping me!!!
You have to give us more info, what kind of app (language???).Why is the app inserting question marks?REPLACE() ? Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
jodpro32
Starting Member
5 Posts |
Posted - 2005-06-30 : 12:20:29
|
I am using Iron Speed Designer using VB.net. It has has custom code wizard that is asking for a URL for the redirect. It will manage the parameters for you, that is why I want to use it. BUT, I can't seem to get to my SQL reporting services reports without having a question mark in the URL, I would think there is a way?? I may be wrong. |
 |
|
jhermiz
3564 Posts |
Posted - 2005-06-30 : 12:22:06
|
quote: Originally posted by jodpro32 I am using Iron Speed Designer using VB.net. It has has custom code wizard that is asking for a URL for the redirect. It will manage the parameters for you, that is why I want to use it. BUT, I can't seem to get to my SQL reporting services reports without having a question mark in the URL, I would think there is a way?? I may be wrong.
Cant you strip the question mark out if its vb.net ?Look at the string functions and replace().Jon Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
jodpro32
Starting Member
5 Posts |
Posted - 2005-06-30 : 12:23:22
|
One more thing. The app is not inserting the question mark. Sql reporting services is. I try to bring up my report on the browser, without touching my application, just using IE, and this is what SQL or the browser is giving me. I am trying to take the link to my report and put it in the application custom code wizard which is choking on the question mark, it is looking for a parameter right after. Anyway, just need a way to get to my SQL report without a question mark in the URL.JOE |
 |
|
jodpro32
Starting Member
5 Posts |
Posted - 2005-06-30 : 12:24:38
|
That is the only link I have found that will bring up my report...?? Strange. |
 |
|
jhermiz
3564 Posts |
Posted - 2005-06-30 : 12:26:42
|
quote: Originally posted by jodpro32 One more thing. The app is not inserting the question mark. Sql reporting services is. I try to bring up my report on the browser, without touching my application, just using IE, and this is what SQL or the browser is giving me. I am trying to take the link to my report and put it in the application custom code wizard which is choking on the question mark, it is looking for a parameter right after. Anyway, just need a way to get to my SQL report without a question mark in the URL.JOE
Question marks are parameters in URL. Does your report allow the end user to select parameters? I don't understand why you are having this issue, I open reports in vb.net applications all the time. I only use the question mark when I have a parameter.I really think something is wrong with your report or the procedure behind the report. It looks like it is expecting a parameter to pass to it.Post the stored procedure and any relevant code. Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
|
|
|
|