Click here to Skip to main content
15,909,953 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi ,


i developed some reports in SSRS 2008 R2 which is accepting parameters and exporting to excel from URL after clicking on URL.

ex:

SQL
http://local:8080/ReportServer/Pages/ReportViewer.aspx?%2fReport+Project5%2ftest&rs:Command=Render&rs:format=excel


now my requirement is i have to fix the default report browser in URL as google chrome or internet explorer i.e after clicking on URL the excel report should open
either from IE or GoogleChrome

how can i implement it.

Thanks in advance
Posted
Updated 30-Dec-12 23:28pm
v2

1 solution

AFAIK a link may not force a specific browser to be used.

You may look at the UserAgentString to identify the browser and post a message (or redirect) if it isnt IE or Chrome.

cheers
 
Share this answer
 
Comments
FranklinRemo 31-Dec-12 6:57am    
Kalyan ,
i know this , but the actual reason before posting this question is ,
our report url is asking username and password for opera , firefox and safari etc.. browsers.
so to fix this issue we have to fix the browser in URL itself.because out client sholudn't accept the above issue to over come this we should fix browser in url itself
Kalyan_A 2-Jan-13 4:41am    
hi mate,

I do not think its possible. The OS will always open a URL with the default browser.

you may already know this. the reason it prompts for username/password is because the site (SSRS) is setup for basic or integrated security. IE being native to windows passes the windows credentials to the server. Even IE would prompt for a password if you provide FQDN unless the site is part of trusted websites or classified as intranet website.


i am not sure its possible unless the client uses a IE shortcut on desktop to access your site. The only suggestion i have is (repeat) -

1. Setup the homepage of the site for anonymous access (no username/password)
2. The homepage will check the browser and display an appropriate message. If its IE, transfer to the SSRS page. else, display a warning and a link to manually access the site.

Cant think of anything else. all the best.

Cheers

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900