Solved

How to display drill through report in new window

Posted on 2007-12-06
6
1,149 Views
Last Modified: 2012-05-05
I am using report viewer in my asp.net application. I have successfully applied summary report and drill through report. Right now if I click on the item on the summary report the drill through report replaces the summary report. What I want to do is pop the drill through report in a new window.

0
Comment
Question by:cswebdev
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 18

Expert Comment

by:PFrog
ID: 20426543
The only way to do this is to build up the URL of the destination report, and then use javascript to open the url.
Unfortunately you can not achieve what you want using the simple 'nagivate to report' destination.

Add the code to the report's custom code, then you can set the destination url of the item to be
   =Code.OpenURL("http://myServer/ReportServer?/Folder/ReportName&ParamName=ParamValue&rs:Command=Render")

Function OpenURL( URL as String) as String
	Return "javascript:void(window.open('" & URL & "','_blank'))"
End Function
 
or, if you want to control the position and details of the window...
 
Function OpenURL( URL as String) as String
	Return "javascript:void(window.open('" & URL & "','_blank','location=no,toolbar=no,left=50,top=50,height=500,width=700'))"
End Function

Open in new window

0
 

Author Comment

by:cswebdev
ID: 20427002
I believe to implement your process, I need to have the reports put on the report server. Is not there a way to open the drill through report which is within your application--not in a report server.

Thanks!
0
 
LVL 18

Expert Comment

by:PFrog
ID: 20427033
Not as far as I'm aware, although I only ever use server based reports so I can't be 100% sure. The javascript method is the only method I have ever found to work as there is no property in SSRS to set to open in a new window.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:cswebdev
ID: 20427153
I will see if your process works without report being put the report server. But I have couple of  questions on the link:
http://myServer/ReportServer?/Folder/ReportName&ParamName=ParamValue&rs:Command=Render"
What is the "ReportServer" in above link? I think its going to be the name of my Virtual directory, is that correct?
On the ReportName do I need to put .rdlc extension?

Thanks!
0
 
LVL 18

Accepted Solution

by:
PFrog earned 500 total points
ID: 20427214
The url is specific for a report server based report
    myServer - the name of the server hosting SSRS
    ReportServer - the IIS share containing the report server
    Folder - optional, if the reports are stored within a sub folder you can specify it here
    ReportName - this is the filename of the report, without the .rdl extension
    ParamName - the name of the parameter you want to set
    ParamValue - the value of the parameter you want to set

I'm really not sure how this would with with an rdlc embedded within an ASP.Net application. For it to work you have to know the URL of the report - do you know that? If not, you could try creating a new page just to host the drillthrough report, and then use the javascript call to open a new window to that page, not sure how you'd pass the parameters though - I'm not an ASP.Net guy!
0
 

Author Comment

by:cswebdev
ID: 20555282
It could not work for me I will close this question with partial credit
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
How to increase the row limit in Jasper Server.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question