Groups | Blog | Home
all groups > sql server reporting services > november 2004 >

sql server reporting services : Pop-Up Report



vblay NO[at]SPAM yahoo.com
11/15/2004 3:18:37 PM
I created a report I call from another report using "jump to a report"
option. The called report is opening in the same browser. I need to
open it in the new window, and if possible to make it a pop-up
(smaller size). I didn't find any straight way to do it.

Any workaround?

Teo Lachev [MVP]
11/15/2004 9:17:23 PM
You need to use Jump to Url navigation action. For maximum flexibility, you
may want to use javascript code which uses window.open, e.g:

window.open("<expression-based report URL here>" & "&rs:Command=Render",
"_blank", "location=no,toolbar=no,left=100,top=100,height=600,width=800")

--
Hope this helps.

---------------------------------------------
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---------------------------------------------

[quoted text, click to view]

vblay NO[at]SPAM yahoo.com
11/17/2004 8:33:06 AM
Thanks a lot for your responding!

I tried this different ways, and failed...

As an example please take a look at this (in 'Jump to URL'):

= "window.open('http://www.google.com')"

It doesn't work... can you tell me what am I doing wrong?...

Thanks again!


[quoted text, click to view]
vblay NO[at]SPAM yahoo.com
11/17/2004 12:00:38 PM
Thanks for the responce!

I tried what you recommended, and failed - I probably do something wrong...

Simple example: I put this to 'Jump to URL':

= "window.open('http://www.google.com')"

It didn't eat it. Can you take a look, please, and tell me what's wrong.

Thanks a lot!



[quoted text, click to view]
Yoshi
11/17/2004 9:19:38 PM
How can you tell if you have SP1 installed or not?

[quoted text, click to view]

Teo Lachev [MVP]
11/17/2004 10:04:58 PM
= "javascript:window.open('http://www.google.com')"

--
Hope this helps.

---------------------------------------------
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---------------------------------------------

[quoted text, click to view]

Teo Lachev [MVP]
11/17/2004 10:16:10 PM
And make sure that you have RS Service Pack 1 installed since javascript
navigation was introduced in SP1.

--
Hope this helps.

---------------------------------------------
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---------------------------------------------

[quoted text, click to view]

Scott Allen
11/17/2004 11:57:13 PM
One way is to go to the Report Server URL and check the version
number. ie http://machine/reportserver.

Version 8.00.0878 will be SP1.

--
Scott
http://www.OdeToCode.com/blogs/scott/

[quoted text, click to view]
Yoshi
11/18/2004 8:13:24 AM
Very nice!

Thanks Scott
[quoted text, click to view]

NI
1/5/2005 10:41:02 AM
This works only on the reportserver, i.e. when i view reports
http://servername/reportserver/... but the java scrip doesnt work when i view
reports on the report manager like this http://servername/reports/..

Plz suggest somethng


[quoted text, click to view]
Teo Lachev [MVP]
1/5/2005 9:56:41 PM
Not sure what you mean by not working. The Report Manager simply requests
the report by URL. Can you try the folllowing report and let me know if it
works?

--
Hope this helps.

---------------------------------------------
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---------------------------------------------

[quoted text, click to view]


begin 666 JavaScriptTest.rdl
M/#]X;6P@=F5R<VEO;CTB,2XP(B!E;F-O9&EN9STB=71F+3@B/SX-"CQ297!O
M<G0@>&UL;G,](FAT=' Z+R]S8VAE;6%S+FUI8W)O<V]F="YC;VTO<W%L<V5R
M=F5R+W)E<&]R=&EN9R\R,# S+S$P+W)E<&]R=&1E9FEN:71I;VXB('AM;&YS
M.G)D/2)H='1P.B\O<V-H96UA<RYM:6-R;W-O9G0N8V]M+U-13%-E<G9E<B]R
M97!O<G1I;F<O<F5P;W)T9&5S:6=N97(B/@T*(" \4FEG:'1-87)G:6X^,6EN
M/"]2:6=H=$UA<F=I;CX-"B @/$)O9'D^#0H@(" @/%)E<&]R=$ET96US/@T*
M(" @(" @/%1E>'1B;W@@3F%M93TB=&5X=&)O>#$B/@T*(" @(" @(" \4W1Y
M;&4^#0H@(" @(" @(" @/%!A9&1I;F=,969T/C)P=#PO4&%D9&EN9TQE9G0^
M#0H@(" @(" @(" @/%!A9&1I;F=";W1T;VT^,G!T/"]0861D:6YG0F]T=&]M
M/@T*(" @(" @(" @(#Q0861D:6YG5&]P/C)P=#PO4&%D9&EN9U1O<#X-"B @
M(" @(" @(" \4&%D9&EN9U)I9VAT/C)P=#PO4&%D9&EN9U)I9VAT/@T*(" @
M(" @(" \+U-T>6QE/@T*(" @(" @(" \<F0Z1&5F875L=$YA;64^=&5X=&)O
M>#$\+W)D.D1E9F%U;'1.86UE/@T*(" @(" @(" \2&5I9VAT/C N,C5I;CPO
M2&5I9VAT/@T*(" @(" @(" \5VED=&@^,6EN/"]7:61T:#X-"B @(" @(" @
M/$%C=&EO;CX-"B @(" @(" @(" \2'EP97)L:6YK/CT@(FIA=F%S8W)I<'0Z
M=F]I9"AW:6YD;W<N;W!E;B@G:'1T<#HO+W=W=RYG;V]G;&4N8V]M)RPG7V)L
M86YK)RDI(CPO2'EP97)L:6YK/@T*(" @(" @(" \+T%C=&EO;CX-"B @(" @
M(" @/%1O<#XP+C5I;CPO5&]P/@T*(" @(" @(" \0V%N1W)O=SYT<G5E/"]#
M86Y'<F]W/@T*(" @(" @(" \5F%L=64^0VQI8VL@;64\+U9A;'5E/@T*(" @
M(" @(" \3&5F=#XP+C@W-6EN/"],969T/@T*(" @(" @/"]497AT8F]X/@T*
M(" @(#PO4F5P;W)T271E;7,^#0H@(" @/%-T>6QE("\^#0H@(" @/$AE:6=H
M=#XR:6X\+TAE:6=H=#X-"B @/"]";V1Y/@T*(" \5&]P36%R9VEN/C%I;CPO
M5&]P36%R9VEN/@T*(" \5VED=&@^-BXU:6X\+U=I9'1H/@T*(" \3&5F=$UA
M<F=I;CXQ:6X\+TQE9G1-87)G:6X^#0H@(#QR9#I3;F%P5&]'<FED/G1R=64\
M+W)D.E-N87!4;T=R:60^#0H@(#QR9#I$<F%W1W)I9#YT<G5E/"]R9#I$<F%W
M1W)I9#X-"B @/')D.E)E<&]R=$E$/CED-#4Y-F,X+60R-V8M-&8S8BTY930W
M+3 S,C(U.#@R.#9F8CPO<F0Z4F5P;W)T240^#0H@(#Q";W1T;VU-87)G:6X^
M,6EN/"]";W1T;VU-87)G:6X^#0H@(#Q,86YG=6%G93YE;BU54SPO3&%N9W5A
..9V4^#0H\+U)E<&]R=#X`
`
end
NI
1/6/2005 6:15:03 AM
I do not see any report here??? What I mean by not working is, I have a link
on a report, that should bring up the pop up. In the jump to url field I have
javascript:window.open blah blah. The java script is fine, because when I hot
f5, it deploys, and opens http://<servername>/reportserver/...<report path>
right. The embedded URL works fine here. But when a user browses to the same
report by going to http://<servername>/reports/...report path, the report
comes up, but the embedded URL java script doesnt work. No java script error
at the bottom. the pop up wouldnt work.

Thanks

[quoted text, click to view]
Teo Lachev [MVP]
1/7/2005 11:00:44 AM
Does voiding the javascript call help?

= "javascript:void(window.open('http://www.google.com','_blank'))"

--
Hope this helps.

---------------------------------------------
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---------------------------------------------

[quoted text, click to view]

NI
1/10/2005 11:01:02 AM
nope doesnt work.

[quoted text, click to view]
NI
1/10/2005 11:19:03 AM
I do not see any attached report. Also did it work for you when you see the
same report by going to http://<servername>/reports and not
http://<servername>/reportserver. It works for me with the reportserver url,
but doesnt work with the reports url.

Thanks

[quoted text, click to view]
NI
1/10/2005 11:59:03 AM
Atleast I know I stated it THRICE in this link that its
http://servername/reports and not http://servername/reportserver (this being
the fourth time). And why I do not want to use that instead of
http://servername/reportserver, because http://servername/reports has a nice
UI, and http://servername/reportserver is so bland. Also in a number of posts
here in the groups, it was advised that we use advertise
http://servaname/reports to our users, so that they can set their own
subscriptions. How can I set subscriptions if you browse reports through
http://servername/reportserver. There you go - I have given you 2 reasons as
to why I need http://servername/reports and not
http://servername/reportserver.

Thanks

[quoted text, click to view]
Bruce L-C [MVP]
1/10/2005 1:11:28 PM
I just tried this out and it does work. I did the following. Created a
report with a single textbox saying Open Up In New Window, then right mouse
click, properties, advanced , navigation tab, jump to url. I copied and
pasted in the below. Sure enough in IE I get a new window to open up. I've
attached the report to this post.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]


begin 666 Test2.rdl
M/#]X;6P@=F5R<VEO;CTB,2XP(B!E;F-O9&EN9STB=71F+3@B/SX-"CQ297!O
M<G0@>&UL;G,](FAT=' Z+R]S8VAE;6%S+FUI8W)O<V]F="YC;VTO<W%L<V5R
M=F5R+W)E<&]R=&EN9R\R,# S+S$P+W)E<&]R=&1E9FEN:71I;VXB('AM;&YS
M.G)D/2)H='1P.B\O<V-H96UA<RYM:6-R;W-O9G0N8V]M+U-13%-E<G9E<B]R
M97!O<G1I;F<O<F5P;W)T9&5S:6=N97(B/@T*(" \4FEG:'1-87)G:6X^,6EN
M/"]2:6=H=$UA<F=I;CX-"B @/$)O9'D^#0H@(" @/%)E<&]R=$ET96US/@T*
M(" @(" @/%1E>'1B;W@@3F%M93TB=&5X=&)O>#$B/@T*(" @(" @(" \4W1Y
M;&4^#0H@(" @(" @(" @/%!A9&1I;F=,969T/C)P=#PO4&%D9&EN9TQE9G0^
M#0H@(" @(" @(" @/%1E>'1$96-O<F%T:6]N/E5N9&5R;&EN93PO5&5X=$1E
M8V]R871I;VX^#0H@(" @(" @(" @/$-O;&]R/D)L=64\+T-O;&]R/@T*(" @
M(" @(" @(#Q0861D:6YG0F]T=&]M/C)P=#PO4&%D9&EN9T)O='1O;3X-"B @
M(" @(" @(" \4&%D9&EN9U1O<#XR<'0\+U!A9&1I;F=4;W ^#0H@(" @(" @
M(" @/%!A9&1I;F=2:6=H=#XR<'0\+U!A9&1I;F=2:6=H=#X-"B @(" @(" @
M/"]3='EL93X-"B @(" @(" @/%1O<#XP+C8R-6EN/"]4;W ^#0H@(" @(" @
M(#QR9#I$969A=6QT3F%M93YT97AT8F]X,3PO<F0Z1&5F875L=$YA;64^#0H@
Bruce L-C [MVP]
1/10/2005 1:46:33 PM
Ahh, it is working for you, just not with reports syntax instead of
reportserver. Let me ask you this, why do you need reports rather than
reportserver? All the URL I create use reportserver. That might be a better
way to solve you problem is figure out why you feel the need to use the
reports syntax instead of reportserver syntax and see if there isn't a way
to use the reportserver method.

I think a lot of people answering the posts thought it didn't work for you
at all (at least that is how I interpreted it, I might have missed the post
where you stated this).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]
NI
1/10/2005 1:55:04 PM
hehhehe..Bruce...you got me wrong again. Oke herez the deal...I have a report
say report1, just a simple report. My users browse to the report by going to
http://servername/reports. Works just fine. On this report, report 1, I have
a link whihc points to a normal web page like http://google.com. This URL is
not to a separate report. Its to a normal web page. Now with the embedded
url, when I deploy my report, and the users browse to that
http://servename/reports/report1 the embedded url, doesnt work.

Hoep this clears up

[quoted text, click to view]
Bruce L-C [MVP]
1/10/2005 2:50:55 PM
This is what I use for the drill through and using jump to url:

=Globals!ReportServerUrl & "?/Inventory/By WSP&wpro_strm_no= 240024"

You can hide the toolbar or show it using the rc:Toolbar=False to hide,
defaults to showing the toolbar.

If they start and browse themselves they will get the full UI, if you jump
to URL using the above format you get the full UI, if you jump to URL
forcing it to open in another window then you get the subset. This is what I
did:

= "javascript:void(window.open('" & Globals!ReportServerUrl &
"?/Inventory/By WSP&wpro_strm_no= 240024 ','_blank'))"
You have the toolbar but not the rest.

So it seems like your choice is, force it to open in another window and you
can get the toolbar but not the tabs at the top. Do a jump to report or jump
to url without opening in another window and you do get the tabs at the top.

I see no way around this behavior.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services


[quoted text, click to view]