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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.