Need Help on Crystal Report 1

[Year2009]

Hi ,

I am designing a report which will extract info from ACCPAC Payroll.

I have a record selection which will limit the output to all employees that contains the EARNDED CODE "UDUES". But since I need to extract a rate from another EARNDED CODE namely REG, I am not sure how to do that.

Any help would be greatly appreciated.

 

[lbass]

This isn't really enough information. You could try just allowing the second code into the report by changing your record selection formula to include it.

-LB

 

[dgillz]

You need to pull in both codes, UDUES and REG. This will result in double records, however you can just suppress the ones you do not want to see. This may cause doubled totals as well, but you can use running totals to get around that.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[Year2009]

I appreciate your replies.

I tried dgillz instructions and is still having issues. I will explain in more details. The report I need should look like this

Emp No. Name UDUES REG UDUES CALCN

100 TEST 40 17 = (17*2)+4

The formulae below in my RSF

{CPEMPL.STATUS} = 1 and
{CPEMPD.EARNDED} = "REG" and
{CPEMPD.EARNDED} ="UDUESM"

do not seem to give me any output. I am not sure why its not working.


Thanks again for your help.

 

[Turkbear]

Hi,
This part:

{CPEMPD.EARNDED} = "REG" and 
{CPEMPD.EARNDED} ="UDUESM"

is the problem...{CPEMPD.EARNDED} cannot be BOTH 'REG" and "UDUESM" - change the RSF to:

{CPEMPL.STATUS} = 1 and
(
{CPEMPD.EARNDED} = "REG" OR
{CPEMPD.EARNDED} ="UDUESM"
)

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

Or:

{CPEMPL.STATUS} = 1 and
{CPEMPD.EARNDED} in ["REG","UDUESM"]

-LB

 

[Year2009]

Thanks a lot for your replies

I used LBASS formula. But still having a problem because the report now looks like this

Employee Rate

TEST 18.5 (REG)
TEST 40.0 (UDUES)

TESTA 19.5 (REG)
TESTA 40.0 (REG)

I want the report to look like this

EMP UDUES REG

TEST 40.0 18.5
TESTA 40.0 19.5

I am not sure how to solve that.

Again your help is very much appreciated

 

[lbass]

Insert a group on employee. Then create two formulas:

//{@Reg}:
if {table.earnded} = "REG" then {table.amount}

//{@Udues}:
if {table.earnded} = "UDUES" then {table.amount}

Place these in the detail section and then insert sums on them at the group level. Drag the groupname into the group footer and then suppress the group header and detail section.

-LB

 

[Year2009]

Thank you IBass,

It worked...