Help with a Formula

[Holidayze]

Hi, Im new to Crystal reports 10. I'm trying to create a formula that recognizes the USER ID and changes it to a text. This is what i have so far, and it works, the only problem is that I have about 80 numbers I have to do this for and I can only get one to work.

IF {ISS_MASTER.USERID} = "MF1234" then "HOLLY VINCENT"

this works but if I try to add another formula below it like
IF {ISS_MASTER.USERID} = "MF1234" then "HOLLY";
IF {ISS_MASTER.USERID} = "MF5678" then "ANNA"

the second formula will only show up in the report.
ahhhhhhhh

As I said, I'm very new to this so if you could provide me with any feedback it would be most appreciated

thanks

Holly

 

[lbass]

Please do not post the same thread in multiple forums.

-LB

 

[MrBillSC]

Try:

IF {ISS_MASTER.USERID} = "MF1234" then "HOLLY" ELSE
IF {ISS_MASTER.USERID} = "MF5678" then "ANNA" ELSE
ETC.

MrBill

 

[vonmac2008]

Hi,

I have inherited a CR10 report. I am a veteran BO developer/user.

I have created an object within the report that should be calculating across the detail and display a summay total. The formula is simple.

if {retail.PERIOD} = {@Col2_CY_DT} then ROUND({sales.DEPLETION}* {ITEM.ItemSale} * {CORP_ITEM.BottPak}/ 9 , 3) else 0

I have placed this formula in the Group Header 2, to go to the "item" level of detail. And to "Details" section. The issue is the formula works for mostvalues accurately but when it finds a BottPack like .19 it gives off a completely random number.
I am attaching the logic. Can anyone give input?

 

[lbass]

This is unrelated to the current thread. Please start a new thread in the Crystal Report formula forum. When you do, please show the content of your nested formula and also identify your group structure. Some sample data would help, also--at the detail level.

-LB