Solved

Crystal Drilldown reports

Posted on 2004-08-06
5
834 Views
Last Modified: 2010-08-05
I'm using Crystal drilldown reports, is there a way to expand all drilldowns to view all detail instead of clicking one at a time
0
Comment
Question by:GimmePoints
[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
5 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 11735914
Not that I am aware of.

mlmcc
0
 
LVL 42

Expert Comment

by:frodoman
ID: 11736081
In theory you could write code to recursively navigate through the report tree and raise the viewer.drill event although from a practical standpoint I think this would be extremely challenging because it's going to be difficult to determine the event arguments that need to be passed to the drill event.

If you want to work that angle I would start by setting up something to capture the viewer.onDrill event when it's raised and output the System.EventArgs.

HTH

frodoman
0
 
LVL 28

Accepted Solution

by:
bdreed35 earned 500 total points
ID: 11736108
There really isn't a native way to do this.  I have found one trick though.

Make a copy of your existing report.  In the copy, remove all the drilldown functionality, then save it.
Next, add a subreport to your origginal report.  The subreport is should be the copy of the report that you just made.
Do not link it to the main report, and make it "On Demand".
Place it in the Report Header so it is on the first page.

The On Demand option will make the subreport appear as a hyperlink on the original report.  It will not run unless someone clicks on the hperlink.  If they want to print or see everything, they simply click the hyperlink, which opens the subreport and shows everything.

It is not a hard process, so I would suggest giving it a try and see if it is a suitable solution for you.
0
 
LVL 42

Expert Comment

by:frodoman
ID: 11736161
bdreed --

Great idea!

-- frodoman
0
 
LVL 19

Expert Comment

by:GJParker
ID: 11736508
Neat trick Brian, give yourself a pat on the back.

Gary
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
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…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

622 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