Search results for query: *

You Rock. I added the last little bit of code and I now have the results I was looking for. I never could have done this without your help. @DECODE(@NULLVALUE(REPORTS.V_PAYDATA_ALL.TEMPRATE,0), 0,(REPORTS.V_EMPLOYEE.RATE1AMT * REPORTS.V_PAYDATA_ALL.REGHOURS), REPORTS.V_PAYDATA_ALL.TEMPRATE...

This is giving me the temp rate where this is one, and the hourly rate where there is no temp rate. Working great.

I get a temp rate of 25.00 where there is a temp rate and 1.00 where this is not a temp rate.

Hi, This give me a value of 1.00

Hello.........Yes that part is working. It bring in the temp rate of 25 I formated it to 25.00.

Sorry I'm still getting the same error.

Hi I still get this same error. Not enough operands Thanks

With the code above I get the error Not enough operands Thanks

Hi Thanks the response. I am very new to this and I am using ADP for windows. I have come up with the code below but I don't have the parenthesis correct. @DECODE IF (REPORTS.V_PAYDATA_ALL.TEMPRATE, 0 ) Then (REPORTS.V_PAYDATA_ALL.REGHOURS * REPORTS.V_PAYDATA_ALL.TEMPRATE) if...

REPORTS.V_EMPLOYEE.RATE1AMT*REPORTS.V_PAYDATA_ALL.REGHOURS I have a derived field as above that works fine. I would like to add more to this so it will only run if REPORTS.V_PAYDATA_ALL.TEMPRATE = null or ifnot > 0 I can't get the syntax correct. Can anyone help me.

Thanks everyone for all your help. I striped down this report last night and removed all the links and redid them. The report is now running faster, only slightly slower then the "Case" option. Database was DB2, with ODBC connect to AS400 iseries, software version Crystal Reports 8.5.

Hi K, Thanks, I tried the whileprinting and it didn't speed it up. I'll go home and sleep on it. Maybe a light bulb will go on, or it may work in the morming.... :)

Hi LB, Ok I have deleted my formula and only used yours....and yes it works but also over 1 minute to run report same as using my orginal formula. Where as using the Case option it runs in seconds. (but not the option I want to use) And re: K The software version is listed in my heading...

Your formula also works, but it gives me the same results as my formula only instead of printing BMCC then DESC in the group header, it prints desc and desc. But it has not improved on the speed of running the report. My Version IE: GH1 (textfield) (BMCC) (DESC)this is the formula I need to...

Hi, I have a report that runs very slow. I have a formula in group header1. If I delete this formula the report is very quick. If GroupName ({BDMSTP.BMCC}) = {GROUPD.GROUP#} then {GROUPD.DESC} else 'MISSING' It is working fine but there are only 7 groups and it reads 1800 records very...