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 dencom 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: *

  • Users: PJOL
  • Content: Threads
  • Order by date
  1. PJOL

    Report automatically refreshes

    Using CR 8.5 and for some reason there's a report that keeps refreshing itself ,i.e, when it is open or try to work on the report or make a change: even edit a text box. Other reports are ok..wait for me to select the refresh icon. Does anyone know how to switch this off ? Had a look in...
  2. PJOL

    Information Store won't start with error code 1053

    AD: Mixed mode OS: W2K SP4 on the Exchange server Exchange version: 2K3 SP2 This server was working ok up until today. Looks like it re-booted itself and the information store won't start ever since. Looked at the event viewer. Saw a warning about exceeding the information store limit, so...
  3. PJOL

    MTA on Exchange 2K3 will not start

    The following sequence of events is in the application log on the MSE2K3 server (SP2). This is from when I try to start the MTA Descriptions are abbreviated Event:2068 DSAccess initialized successfully Event:2219 MTA running recovery on internal message d/b because MTA was not shutdown cleanly...
  4. PJOL

    Summing running totals fields

    I am using CR's version 8.5. We have a report that uses a formula called '@Setup-Time' which contains: if {@prodgroup}='OTHERS' then {#SetupTimeOthers} else {#SetupTime}. SetupTimeOthers are SetupTime are running totals. I want to 'sum' these running totals. Any ideas ? Thanks in advance.
  5. PJOL

    Absolute value of a number

    I need to work with the absolute vale of a number in our formula. numbervar sub7:=({UD_SP_BOX_COUNT.Customer} - {@sub6}) Whether {@sub6} has a negative or positive value, I want the absolute value to be used in the formula. Any help appreciated.
  6. PJOL

    Faulty Ultra 320 SCSI 10K in RAID 5 Config

    I have a red light on a drive in bay 2 of a HP Proliant ML370. The HP diagnostic utility says to replace the drive and I'm waiting on shipment of same from HP. The OS is W2K3 Server. Is it just a case of powering down the server and replacing the faulty drive with the identical replacement from...
  7. PJOL

    When value returned by formula is zero

    A report I have for conversions uses a formula in the details section, i.e. whileprintingrecords; If{PRODUCT_MASTER.IC_UNIT_REQUIRE}={PART_UOM_CONVERSIONS.UNIT_FROM} and {PLANNING_JOB_STAGE_LINES.INPUT_UNIT}={PART_UOM_CONVERSIONS.UNIT_TO} and {PART_UOM_CONVERSIONS.UOM_CONVERSION_FACTOR}>0 and...
  8. PJOL

    Round up and Truncate

    We have a report with a total that's not an actual field, i.e. it's a sum calculated from sub-totals from other fields. I need to round it up or truncate it in our favour, i.e. 5.1 rounded up to 6 and so on. There is a formula for this in Crystal for fields, but I'm having difficulty applying it...
  9. PJOL

    SPNEGO negotiator

    I have a user (XP Pro SP2)whose account keeps getting locked out with Event ID 40960. The source is LSASRV and category is SPNEGO negotiator. The AD environment is mixed, i.e. W2K3 and W2K. The event ID mentions that too many invalid attempts to login or change a password were made against our...
  10. PJOL

    Formula editor and sub reports

    The formula I want to insert on a main report needs to include a field from the sub report, i.e. the Quantity on the main report multiplied by the Sales Price from the sub report. Formula editor in Crystal 8.5 won't let me do it.

Part and Inventory Search

Back
Top