Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: running totals in chart Post Reply Post New Topic
Author Message
sanchezgmc06
Senior Member
Senior Member
Avatar

Joined: 21 Jan 2011
Online Status: Offline
Posts: 107
Quote sanchezgmc06 Replybullet Topic: running totals in chart
     Posted: 05 Sep 2013 at 12:35pm
Hello,
 
I am trying to create a chart to compare two running totals.
 
1st running total is below
 
field to sumarize {patid}
type of summary=distinct count
Evaluate on formula-{summary_current.program_value}startswith "Access "
Reset- Never
 
2nd running total is below
field to sumarize {patid}
type of summary= distinct count
Evaluate on formula- {view_episode_summary_current.program_value}startswith "CS  "
 
What I would like to do is create a graph to show the two running totals however I am unable to choose these fields when in the chart expert.
 
 
please help
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 06 Sep 2013 at 6:21am

do all of your records fall into one of the two categories are there other values also in the report?

IP IP Logged
sanchezgmc06
Senior Member
Senior Member
Avatar

Joined: 21 Jan 2011
Online Status: Offline
Posts: 107
Quote sanchezgmc06 Replybullet Posted: 06 Sep 2013 at 7:22am

Yes in my select expert i have selected specific programs. However they all start with CS or Access

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 06 Sep 2013 at 7:26am
create a formula to group your rows
//category
If {summary_current.program_value} startswith "Access " then "Access"
else if {view_episode_summary_current.program_value} startswith "CS  " then "CS" else "Not Categorized"
insert a bar chart
on change of=@ category
show value = distinctcount of patid
 
just curious...Is this Harmony software?
 
IP IP Logged
sanchezgmc06
Senior Member
Senior Member
Avatar

Joined: 21 Jan 2011
Online Status: Offline
Posts: 107
Quote sanchezgmc06 Replybullet Posted: 06 Sep 2013 at 8:13am
Thank you DBlank you are a lifesaver
 
Not Harmony Software its Netsmart software
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 06 Sep 2013 at 8:20am

Glad you got it Thumbs%20Up

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