vsuripeddi
asked on
Find number of unsupressed records
Hi
I am using crystal reports 10
I am using a formula field which is total_work
It is the sum of 2 database fields ( employee is table)
{@tot_wrk} := employee.regular_wrk + employee.overtime_wrk;
This tot_wrk has to be suppressed whenever its value is greater than 24;
I need to calculate the count of all the unsupressed tot_wrk
formula fields ; ie the total records which are displayed
The formula field is in a group header (G2) and is again contained within another main group (G1). I could not do
Sum ({@tot_wrk} and this is giving me an error
So the count of all the {@tot_wrk} present in group G2 should be displayed in its super group G1
Can some one please help
Thanks
I am using crystal reports 10
I am using a formula field which is total_work
It is the sum of 2 database fields ( employee is table)
{@tot_wrk} := employee.regular_wrk + employee.overtime_wrk;
This tot_wrk has to be suppressed whenever its value is greater than 24;
I need to calculate the count of all the unsupressed tot_wrk
formula fields ; ie the total records which are displayed
The formula field is in a group header (G2) and is again contained within another main group (G1). I could not do
Sum ({@tot_wrk} and this is giving me an error
So the count of all the {@tot_wrk} present in group G2 should be displayed in its super group G1
Can some one please help
Thanks
ASKER
Formula field is {@total_wrk} It is sum of two summation fields ( sum(regular_wrk) + sum(overtime_wrk))
The formula field {total_wrk} is in a group header .
Hence I could not find count({@total_wrk} or sum({@total_wrk} .
If it were to be in the detail section I could easily find its summation or count
This formula field is in group header section
This has to be suprressed whenever its value is greater than 24
The count of all these unsuprressed {@total_wrk} whsould be displayed in a group above this group
Group2 is contained in Group1
Group2 contains {@total_wrk}
Count of {@total_wrk}.... not suprressed should be displayed in Group1
Could you please help with this
Thanks
The formula field {total_wrk} is in a group header .
Hence I could not find count({@total_wrk} or sum({@total_wrk} .
If it were to be in the detail section I could easily find its summation or count
This formula field is in group header section
This has to be suprressed whenever its value is greater than 24
The count of all these unsuprressed {@total_wrk} whsould be displayed in a group above this group
Group2 is contained in Group1
Group2 contains {@total_wrk}
Count of {@total_wrk}.... not suprressed should be displayed in Group1
Could you please help with this
Thanks
>>> This tot_wrk has to be suppressed whenever its value is greater than 24; I need to calculate the count of all the unsupressed tot_wrk
So in other words you need to count all of these where the value is <= 24 (because these are the unsuppressed) right?
Can't you simply create another formula:
// @CountUnsuppressed
if {@total_wrk} <= 24 then 1 else 0;
And then add a SUM({@CountUnsuppressed})
frodoman
So in other words you need to count all of these where the value is <= 24 (because these are the unsuppressed) right?
Can't you simply create another formula:
// @CountUnsuppressed
if {@total_wrk} <= 24 then 1 else 0;
And then add a SUM({@CountUnsuppressed})
frodoman
ASKER
thanks for the post....
Yes.. precisely that is what I wanted to say...
I could not add up the formula SUM({@CountUnsuppressed})
and this is giving me error
IT is giving me a message that {@CountUnsuppressed } cannot be summarized
Could you kindly help
thamks
Yes.. precisely that is what I wanted to say...
I could not add up the formula SUM({@CountUnsuppressed})
and this is giving me error
IT is giving me a message that {@CountUnsuppressed } cannot be summarized
Could you kindly help
thamks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Agree - create a running total on this new formula.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SHould have solved it.
mlmcc
mlmcc
You can create a running total to summarize it but you will NOT be able to display it in G1 header, it would have to be in the footer.
If you are just adding 2 database fields together, you should be able to just add them together in a formula like this:
{employee.regular_wrk} + {employee.overtime_wrk}
and then right click the field and insert, summary.