Solved

Crystal Drilldown reports

Posted on 2004-08-06
5
826 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
5 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Not that I am aware of.

mlmcc
0
 
LVL 42

Expert Comment

by:frodoman
Comment Utility
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
Comment Utility
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
Comment Utility
bdreed --

Great idea!

-- frodoman
0
 
LVL 19

Expert Comment

by:GJParker
Comment Utility
Neat trick Brian, give yourself a pat on the back.

Gary
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

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…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

771 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

16 Experts available now in Live!

Get 1:1 Help Now