Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

DrillDown

Posted on 2001-06-13
20
Medium Priority
?
577 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
[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
  • 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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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 brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

721 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