Print Page | Close Window

Drill Down Report

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5777
Printed Date: 01 May 2024 at 5:30am


Topic: Drill Down Report
Posted By: mikegold7
Subject: Drill Down Report
Date Posted: 16 Mar 2009 at 2:32am

 

Hello,

I'm trying to design a drill down report, which should include the following:

The properties to be measured against each record category should be:

a.       % Scheduled

b.      % Overdue

c.       % Completed

in other words for each category, the graph should display the above values (a, b, c) in case the user click on one of the bars it should drill down and display detailed info on it.

I would be more than happy if someone got any clue.

Thanks,

Mike

 


Replies:
Posted By: DBlank
Date Posted: 16 Mar 2009 at 9:24am
Place to start is to create a formula field to determin what category each record falls into then group on that formula. from there you use counts to get numbers and charts.
SInce I don't know your data I am guessing at the formula so you will need to adjust based on the actual fields and conditions. My guess is you have 2 date fields per row to check, the scheduled_date and completed_date and that you want to count completed as completed regardless if it was completed late or not:
if isnull(table.completion_date)=false then "Completed" else if
table.scheduled_date<currentdate then "Over Due" else "Scheduled"


Print Page | Close Window