Solved

How to display drill through report in new window

Posted on 2007-12-06
6
1,131 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
  • 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
ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

770 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