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
 Question Mark in URL

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/ShipmentDetailsReport

My 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/ShipmentDetailsReport

My 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]
Go to Top of Page

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.
Go to Top of Page

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]
Go to Top of Page

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
Go to Top of Page

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.
Go to Top of Page

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]
Go to Top of Page
   

- Advertisement -