Solved

DrillDown

Posted on 2001-06-13
20
562 Views
Last Modified: 2012-06-22
I want to add drilldown capability to my Reports, i.e.
calling another report from an existing report by double clicking a field or a text object (transfering a parameter).
how do I do that?

10x...
0
Comment
Question by:makris
  • 7
  • 5
  • 2
  • +3
20 Comments
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6187957
The term "drilldown" as used in Crystal Reports does not mean calling another report, but rather it means to expose the details for a group which are initially suppressed.

If you want to call another report I suppose you could either embed a hyperlink in your report which links to the second report, or trap one of the drillon____ events available in 8.0 or better.
0
 

Author Comment

by:makris
ID: 6191525
when are the drillon events fired?
A hiperlink won't help cuz I want to show a report based on the value which was selected...
0
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6191581
Not being familiar with your report layout or how your data lends itself to a secondary report, I will refer you to the Developer Help for Crystal.  By default, it is not added to the desktop or the start menu, but is available at "\Program Files\Seagate Software\Crystal Reports\Developer Files\Help\Developr.hlp" on the drive where you installed CR.  Type "events" in the index for a listing of all events you can trap.

I don't think you can capture the value on the screen at the point of the click unless you have setup a group and the user clicks on the group drilldown pane item.  There is a drillondetail event mentioned, but it is not active in CR8.0

0
 
LVL 1

Expert Comment

by:psyberfry
ID: 6191679
Could you create a click-on-demand subreport and place it in your main report?
0
 

Author Comment

by:makris
ID: 6192040
I realy don't know...can I? and how?
creating a subreport is easy...but how can I show that report on double click while refering to the field value I clicked on?
0
 

Expert Comment

by:HowardH
ID: 6192720
I believe you simply need an 'on-demand' sub-report.
(Assuming you are using Crystal 8 or 8.5)
Click on Insert (menu item) then 'subreport' then
either pick 'choose report' and find it using the browse
button or pick 'create a subreport' and go through the
report expert.  Make sure you check the 'on-demand subreport' box.  After you complete that screen you will have an object attached to your cursor.  Position it anywhere in your report that makes sense (and is allowed) and click with the left mouse button.  When you preview the report you will see an object with the name of your subreport.  Double-click on the object and you will see the results from your subreport in a special preview window.

0
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6192780
I don't believe you can associate an on-demand sub report with a given data value as makris has asked.

By the way, HowardH, it is the convention in the Crystal area to post comments, not answers.  See the information below for more details.
0
 
LVL 1

Expert Comment

by:psyberfry
ID: 6192861
Perhaps the solution lies in a combination of the two. Maybe using a drillon event or the dblclicked event to pass a parameter to the on-demand subreport?
0
 

Author Comment

by:makris
ID: 6195069
I don't want to see the whole subreport results, but only the relevant records,depends on the value I clicked.

I want to pass a pramater to the subreport and then get my results
0
 

Expert Comment

by:HowardH
ID: 6203602
You can link a main report to a sub-report based on a parameter field or on a formula field based on a parameter field.  You can add to the record selection formula in the sub-report as well and you can suppress unnecessary sections in the sub-report so that only the types of records (detail or subtotals, etc.) show.  
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 1

Expert Comment

by:AConover
ID: 6203784
If you simply create a group for the information you want details on, you'll automatically be in a drill down format.
0
 

Author Comment

by:makris
ID: 6205783
howardh...how do I add a parameter field to a sub report, and how do I use it? how do I send this parameter to the sub-report?
0
 
LVL 1

Expert Comment

by:AConover
ID: 6206086
Makris,
To add a parameter or formula field to a sub report:
-open the sub report
-create the parameter field
-then go into your select expert
-select your field and tie it to your parameter field
When you run the main report, you'll be prompted to fill the parameter of the sub report and any others you have in your main report.  Hope this helps, good luck.
0
 

Author Comment

by:makris
ID: 6213659
I found the solution for the problem...
I knew how to create a sub report, but I needed the subreport to know which records are relevant...
on the "Insert Subreport form" after creating the sub report,using the "link" tab you can define the relationships,thus filtering the subreport records by the field value on the original report.
how to send this parameter to a function in VB? that's another story...anyone?
0
 

Author Comment

by:makris
ID: 6213868
I found the solution for the problem...
I knew how to create a sub report, but I needed the subreport to know which records are relevant...
on the "Insert Subreport form" after creating the sub report,using the "link" tab you can define the relationships,thus filtering the subreport records by the field value on the original report.
how to send this parameter to a function in VB? that's another story...anyone?
0
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6325215
makris

If you have found your own solution, please don't leave this question open.  Leave a zero point message in Community Support asking that a moderator either PAQ or delete this question, and include a link to this question in your message.  That way you'll also get your points back.

Let me know if you need additional information

DRRYAN3
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 6351975
makris, on 06/21, you stated that "I found the solution for the problem...
I knew how to create a sub report, but I needed the subreport to know which records are relevant...
on the "Insert Subreport form" after creating the sub report,using the "link" tab you can define the
relationships,thus filtering the subreport records by the field value on the original report.
how to send this parameter to a function in VB? that's another story...anyone? "

This now addressed VB, another topic area.

What do you intend to do with this question in terms of the contributions made here?  It remains open today and I await your input to finalize this.

Thank you,
Moondancer
Community Support Moderator @ Experts Exchange
0
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6412069
makris

Feedback?

DRRYAN3
0
 

Author Comment

by:makris
ID: 6412441
since there is no answer to my question...
0
 
LVL 1

Accepted Solution

by:
Moondancer earned 0 total points
ID: 6446751
Points refunded, moved as 0 point Q to PAQ.
Moondancer
Community Support Moderator @ Experts Exchange
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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 …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

744 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

13 Experts available now in Live!

Get 1:1 Help Now