asked on

what does this formula mean in crystal report

Hi, All:

Today when I was modifying a crystal report, i found a field is defined by the following code.

IsNull(GroupName ({cstSP_FCAdmissionsDailyReport_rpt_rk;1.StaffName}))
or (Sum ({cstSP_FCAdmissionsDailyReport_rpt_rk;1.NewLead}, cstSP_FCAdmissionsDailyReport_rpt_rk;1.StaffName}) = 0
and Sum ({cstSP_FCAdmissionsDailyReport_rpt_rk;1.FollowUp}, {cstSP_FCAdmissionsDailyReport_rpt_rk;1.StaffName}) = 0)

This field is used to get the sum of new leads based on each admission rep (staff name). I don't know if this formula is right or not, but the result is not correct. Could you guys help me with this? Thank you.
sum-of-new-lead-code.jpg

SOLUTION

James0628

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

LinInDenver

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jason Yu

ASKER

Hi, thank you guys for advising.

I will try to use LinInDenver's suggestion and try to calcluate the total. My confusion is why the sum function has two parameters instead of one.

like this one: Sum ({cstSP_FCAdmissionsDailyReport_rpt_rk;1.FollowUp}, {cstSP_FCAdmissionsDailyReport_rpt_rk;1.StaffName}) = 0

And it has = 0 behind it, I am quite confused.

thank you.

SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

LinInDenver

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

James0628

Lin,

If you look at the screenshot with the first post, the formula is actually used as the suppression formula for GH1. At least that's what's in the screenshot. Of course the formula could be used in other places too, but, based on the screenshot, it's not being used to calculate anything, so it's really unclear what they're really after. Which is why I asked in my first post what kind of result they were actually trying to get.

James

LinInDenver

Thanks James - I was actually trying to address the part where the author has stated "This field is used to get the sum of new leads based on each admission rep (staff name)."

I will wait for the author to make another comment and/or attach the report file.