Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: help with chart Post Reply Post New Topic
Author Message
rp123
Groupie
Groupie


Joined: 26 Feb 2009
Location: United States
Online Status: Offline
Posts: 47
Quote rp123 Replybullet Topic: help with chart
     Posted: 06 Mar 2009 at 2:05am
Hello All,

I need help in creating the charts in Crystal Report Xi.

I have following fields to be used in creating the charts:

{probsummarym1.number}
{probsummarym1.cause.code}
{probsummarym1.assignment}
{probsummarym1.orig.open.group}

Q1. I want to create a bar chart using top 10 {probsummarym1.assignment} groups?

y axis = no. of incidents ({probsummarym1.number})   
x axis = assignment group ({probsummarym1.assignment})

Q2. Out of top 10 {probsummarym1.assignment} groups, Create a 3 separate bar charts from above chart:

- 1st TOP {probsummarym1.assignment} group showing top 10 {probsummarym1.cause.code} in 1st chart

- 2nd TOP {probsummarym1.assignment} group showing top 10 {probsummarym1.cause.code} in 2nd chart

- 3rd TOP {probsummarym1.assignment} group showing top 10 {probsummarym1.cause.code} in 3rd chart.

y axis = no. of incidents ({probsummarym1.number})   
x axis = Cause Code ({probsummarym1.cause.code} )

Q3. Create a stacked clustered chart using the following fields :

{probsummarym1.assignment}
{probsummarym1.orig.open.group}

I have following data in {probsummarym1.orig.open.group} field that is
" Patrol " and "Customer ".

So create a stacked clustered chart showing TOP 10 assignment groups ({probsummarym1.assignment} and in the chart each group showing total patrol tickets and total customer tickets stacked and clustered together.

So take a example:

each bar will display total Patrol tickets and total other Customer tickets stacked and clustered together.

example: out of 100 incidents 60 are Patrol and rest left that is 40 are different customers but we count them as one customer.

y axis = no. of incidents ({probsummarym1.number})   
x axis = assignment group ({probsummarym1.assignment})

Here is the sample data:

Incident ID Primary Assignment Cause Code orig.open.group
IM1672598 EAI Services Application Team CP-User Request AML - Chantilly
IM1674631 AML - Chantilly Client Support Printing Issue Patrol
IM1688929 Physician Implementations - East Invalid Data Physician Imp East
IM1670898 INF System DSM User Request Patrol

rp
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 06 Mar 2009 at 2:40am
Hi
 
Please can you post a bit more sample records,to playaround with....
 
Cheers
Rahul


Edited by rahulwalawalkar - 06 Mar 2009 at 2:41am
IP IP Logged
rp123
Groupie
Groupie


Joined: 26 Feb 2009
Location: United States
Online Status: Offline
Posts: 47
Quote rp123 Replybullet Posted: 06 Mar 2009 at 3:13am
Incident ID Primary Assignment Cause Code orig.open.group
IM1672598 EAI Services Application Team CP-User Request AML - Chantilly
IM1674631 AML - Chantilly Client Support Printing Issue AML - Chantilly
IM1688929 Physician Implementations - East Invalid Data Physician Imp East
IM1670898 INF System DSM User Request LOS
IM1681021 AML - Chantilly PC Applications Application AML - Chantilly
IM1676188 LEN- L2 XMIT Application - General Problem Risk Assessment Help Desk
IM1670614 Physician Implementations - NY/NJ CPU - Results Not Crossing Regional IT Teterboro
IM1681456 Hospital Interface Support Chantilly Interface Patrol
IM1681876 West Hills Field IT Support 9- General Questions Regional IT West Hills
IM1685012 SJC Technical Support User Request Regional IT SJC
IM1689472 LEN- L2 Imaging Support Application Risk Assessment Help Desk
IM1681803 INF Data Network WAN Connectivity lost Patrol
IM1682598 Western Region Helpdesk 1st Tier CP-Hardware Failure RHD Autodial
IM1672789 LEN- L3 Call Center Other KDC
IM1681699 INF Data Network Internet Network Data Patrol
IM1668901 TIER 2 CPU SUPPORT CPU - Results not filing Regional IT Pittsburgh
IM1685005 EAI Services Application Support CP-Delete Physician Imp East
IM1678217 EAI Services Application Support Application Patrol
IM1678152 EAI Services Application Team Question Hospital Imp West
rp
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 06 Mar 2009 at 11:55am
You may need to do this using sub reports for Q2.
Create a group1 on {probsummarym1.assignment}
Do a summary as a Distinct Count on the Incident ID at group footer1.
create a second group on probsummarym1.cause.code.
Do a summary as a Distinct Count on the Incident ID at group footer2
Create a formual field called "Type"
as: if ({probsummarym1.orig.open.group})="Patrol" then "Patrol" else "Customer"
Create different Report headers for each chart you want.
Q1. Insert a chart.
In the chart expert select Bar Chart
Data as Group on with your group 1 show as distinct count of ID#.
Format as you want.
Click on the Group Sort Expert and select Top N and set N to 10.
 
Q2. basically the same but you need to include counts of the fields you want for an advanced bar chart using the G1 and G2 data.
Since you only want the top 3 you may have to do this as a subreport because I think it will show the top 10 based on group sort expert for chart1.
 
Q3. USe the formula field for your stacked bar chart. Wouldn't need a sub report since you want the same top ten as in Chart1
 


Edited by DBlank - 06 Mar 2009 at 11:56am
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.