Solved

How to display drill through report in new window

Posted on 2007-12-06
6
1,117 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
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
How to increase the row limit in Jasper Server.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

708 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now