Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Analyze data in group data Post Reply Post New Topic
Author Message
joeg1962
Newbie
Newbie


Joined: 01 Mar 2013
Location: United States
Online Status: Offline
Posts: 35
Quote joeg1962 Replybullet Topic: Analyze data in group data
    Posted: 20 Dec 2016 at 8:55am
Perhaps simplest to understand with some sample info.

Doctor begins office visit with a time-stamp 8am on a record. Store to Var1
Read many more also storing to Var1
Doctor makes last entry at 8:15 also storing to Var1

At the group level, I can determine the min as 8:00 and max as 8:15
Therefore at group I can know time elapsed was 0:15

Do this for all the office visits, creating printout like
Doc1 Pt1  8:00 8:15 0:15
Doc1 Pt2  8:20 8:25 0:05
Doc1 Pt3  8:25 8:55 0:30

Because I have already done some 'math' on the data, that seems to prevent me from doing math on the group level math
So, do I try one of these or something else?
(a) Create some running-total variables to know Doc1 saw 3 pts for 50 minutes (and 16.7 minute average).
(b) Save this file to Excel and then write a 2nd CR to ODBC connect and read all the lines in this 2nd report create the summary/table.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 20 Dec 2016 at 10:45am
You be able to do some manual running totals if nothing else.  In a formula that would be reset at the group header for the doctor, you might have this formula in a group footer (?)

shared numbervar timetotal;
timetotal := timetotal + max({time}) - min({time})

then have a running total that just counts the visits and is reset at a group.  Also you could have a formula for the average (Group Footer?).

Shared numbervar timetotal;
timetotal/{#countofvisits)*100

These are just examples to hopefully get you pointed in the right direction.
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.032 seconds.