Solved

DrillDown

Posted on 2001-06-13
20
572 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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

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. …
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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

627 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