Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. wmannod

    Reportsmith Version 4.2 derived field

    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...
  2. wmannod

    Reportsmith Version 4.2 derived field

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

    Reportsmith Version 4.2 derived field

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

    Reportsmith Version 4.2 derived field

    Hi, This give me a value of 1.00
  5. wmannod

    Reportsmith Version 4.2 derived field

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

    Reportsmith Version 4.2 derived field

    Sorry I'm still getting the same error.
  7. wmannod

    Reportsmith Version 4.2 derived field

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

    Reportsmith Version 4.2 derived field

    With the code above I get the error Not enough operands Thanks
  9. wmannod

    Reportsmith Version 4.2 derived field

    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...
  10. wmannod

    Reportsmith Version 4.2 derived field

    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.
  11. wmannod

    Slow report crystal reports 8.5

    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.
  12. wmannod

    Slow report 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.... :)
  13. wmannod

    Slow report crystal reports 8.5

    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...
  14. wmannod

    Slow report crystal reports 8.5

    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...
  15. wmannod

    Slow report crystal reports 8.5

    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...

Part and Inventory Search

Back
Top