• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 590
  • Last Modified:

DrillDown

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
makris
Asked:
makris
  • 7
  • 5
  • 2
  • +3
1 Solution
 
DRRYAN3Commented:
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
 
makrisAuthor Commented:
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
 
DRRYAN3Commented:
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
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
psyberfryCommented:
Could you create a click-on-demand subreport and place it in your main report?
0
 
makrisAuthor Commented:
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
 
HowardHCommented:
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
 
DRRYAN3Commented:
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
 
psyberfryCommented:
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
 
makrisAuthor Commented:
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
 
HowardHCommented:
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
 
AConoverCommented:
If you simply create a group for the information you want details on, you'll automatically be in a drill down format.
0
 
makrisAuthor Commented:
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
 
AConoverCommented:
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
 
makrisAuthor Commented:
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
 
makrisAuthor Commented:
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
 
DRRYAN3Commented:
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
 
MoondancerCommented:
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
 
DRRYAN3Commented:
makris

Feedback?

DRRYAN3
0
 
makrisAuthor Commented:
since there is no answer to my question...
0
 
MoondancerCommented:
Points refunded, moved as 0 point Q to PAQ.
Moondancer
Community Support Moderator @ Experts Exchange
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 7
  • 5
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now