ChiaYossarian
asked on
Crystal Reports: Summarize Data Question
I am at Beginners level, so please excuse the trivial question ...
I use Crystal Reports 2011 with an Access Database connected by ODBC.
We have one table that contains information that I need to display in a report, and use some of the displayed results to calculate values.
The Table consists of one Date Field and nine Number Fields.
One Number Field "Status" contains a value between 0 and 5, these numbers correlate to different statuses.
I can easily display these statuses in the Details section, and wrote a Formula to display a string matching the Status, in the form of:
IF {table.status} = 0 THEN 'STATUS_0' ELSE
IF {table.status} = 1 THEN 'STATUS_1' ELSE ... and so on.
My problem is now: I need to show the number of occurrences for each of these statuses in the Report Footer.
This should look like:
Period: 2016/4/01 - 2016/04/10
Status_0: 3
Status_1: 1
Status_2: 0
Status_3: 1
Status_4: 5
These counts I will then need to use in a formula to determine a result, like:
(COUNT (Status_1)*1000)+(COUNT (Status_2)*-2000+ ...
How to proceed here?
I use Crystal Reports 2011 with an Access Database connected by ODBC.
We have one table that contains information that I need to display in a report, and use some of the displayed results to calculate values.
The Table consists of one Date Field and nine Number Fields.
One Number Field "Status" contains a value between 0 and 5, these numbers correlate to different statuses.
I can easily display these statuses in the Details section, and wrote a Formula to display a string matching the Status, in the form of:
IF {table.status} = 0 THEN 'STATUS_0' ELSE
IF {table.status} = 1 THEN 'STATUS_1' ELSE ... and so on.
My problem is now: I need to show the number of occurrences for each of these statuses in the Report Footer.
This should look like:
Period: 2016/4/01 - 2016/04/10
Status_0: 3
Status_1: 1
Status_2: 0
Status_3: 1
Status_4: 5
These counts I will then need to use in a formula to determine a result, like:
(COUNT (Status_1)*1000)+(COUNT (Status_2)*-2000+ ...
How to proceed here?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER