Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / November 2005

Tip: Looking for answers? Try searching our database.

Open a new report in a new window from existing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Stuart@ICS - 30 Nov 2005 18:22 GMT
Hello all:
I need to open a new RS report from an existing RS report when the user
selects a distinct week # field.
I realize I right click the field / Properties / Advanced / Navigation I
believe I need to use the jump to URL.

I suspect I need a java script to create the new window with the report.

Can someone provide for me an example of the Java script necessary and
clarify my directions.

Also, does anyone know if this is explained WHERE I can find it in the
Hitchhikers Guide to Reporting Services - I have a copy and can not find the
resolution.  I understand it is in Teo's book MS RS in Action; which I dont
own.  All suggestions are welcome.

Thanks you in advance

Stuart
inventoryguy@hotmail.com
Bruce L-C  [MVP] - 30 Nov 2005 21:41 GMT
This was introduced with SP1 which might be why it is not in your book. Here
is the syntax:

Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"

If you remove the format and encoding it will come up in HTML (the default
format if nothing is specified)

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> Hello all:
> I need to open a new RS report from an existing RS report when the user
[quoted text clipped - 16 lines]
> Stuart
> inventoryguy@hotmail.com
Stuart@ICS - 30 Nov 2005 22:26 GMT
Hello Bruce:
I get a URI Scheme is not valid error when I test the report.

My goal to to have a link off a field in report 1 when clicked open another
RS report in a new window.
The line I used is:
"javascript:void(window.open("https://server/ReportServer?%2fPRJfolder%2fRPTname"
& "&rs:Command=Render", "_blank",
"location=no,toolbar=no,left=100,top=100,height=600,width=800"))"
We have SP1 loaded.

Can you tell me where we have errored in our code?
If we need to pass parameters how would the line be different, I the
similances of that in your code but would like to make certain of all your
suggestions.
Again, thank you for the help.

Stuart

> This was introduced with SP1 which might be why it is not in your book.
> Here is the syntax:
[quoted text clipped - 28 lines]
>> Stuart
>> inventoryguy@hotmail.com
Bruce L-C  [MVP] - 30 Nov 2005 23:04 GMT
One thing I suggest, try it without any report first. Open up another web
page, google or whatever. Then you can make sure that you are using it
properly. Then open a report. One thing I am not sure of is the syntax you
you for location etc).

Looking at you have done, you are not doing what I did. I have single quotes
in places where you modified it to use double quotes. You are assembling a
string here. I use double quotes only between strings and then I have and &
concatenating the string. Look at mine closely, it was a working example.
The only place double quotes are used will have an ampersand either before
it or after it depending on whether I am starting a new string or ending it.
Looking at yours (not even worrying about what you have actual put there)
but without a doubt it is totally wrong just because of your use of double
quotes.

One easy thing to do, have a text box in a report. No dataset. Just a report
with a single text box. Set the source of the textbox to this expression so
you can see the result. Until you get the quotes correct it will keep
erroring out. Then once you have that correct you can see what your
resulting string looks like.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> Hello Bruce:
> I get a URI Scheme is not valid error when I test the report.
[quoted text clipped - 47 lines]
>>> Stuart
>>> inventoryguy@hotmail.com
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.