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 Mike Lewis 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
  • Order by date
  1. PJOL

    Report automatically refreshes

    The issue here was that 'Verify on Every Print' was selected. You can see this at the Preview or Design view of the report. Just select Design, Database and the option is there to toggle Verify on Every Print. This is an option I never switch on by default. I inherited the report from someone...
  2. 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...
  3. PJOL

    Name not recognized in the GAL

    The problem has been resolved. The Recipient Update Service was pointing to an Exchange server that was de-commissioned. As soon as I added in the correct Exchange server for this service, bingo...the GAL reflected all names from the Outlook client and I could check name no problem. That aside...
  4. PJOL

    Information Store won't start with error code 1053

    Guys: Because my back was against the wall, I had no option but to install a second Exchange server. I had to delete the mailboxes at each user level and re-create them individually on the second server. Exchange tasks let me do this quite easily.But...I knew I had a clean information store on...
  5. 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...
  6. PJOL

    MTA on Exchange 2K3 will not start

    I now have two Exchange servers in the organisation but that's purely driven by the fact that I had to get mail working quickly and so I installed another Exchange server and just moved the mailboxes over so that users could work again. Second Exchange server(also 2K3) working fine. If I stop...
  7. 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...
  8. PJOL

    The Update service failed to update the .dat file

    This has probably corrected itself, i.e. it's not unusual for the update to fail and then pass on the next update cycle. There are three dat files that Groupshield uses: 'clean.dat', 'names.dat' and 'scan.dat'. If your clients are updating ok at the pc level then you have the latest versions of...
  9. 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.
  10. 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.
  11. PJOL

    Faulty Ultra 320 SCSI 10K in RAID 5 Config

    I replaced the drive in bay 0 with the replacement from HP. I now have four healthy ultra scsi 320 drives in the RAID 5 logical configuration. Happy days.
  12. PJOL

    Faulty Ultra 320 SCSI 10K in RAID 5 Config

    Thanks. I thought I was on a home run with the replacement drive in bay 2 on-line after the re-build on the server . Now the drive in bay 0 has a flashing red x, flashing green AND access light. I sent the diagnostic log to HP and they have shipped me another replacement drive for the now...
  13. 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...
  14. 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...
  15. PJOL

    Round up and Truncate

    The output I want to truncate is a Sum field object as follows: Sum of @UOM GI (number) The @UOM GI (number) is a conversion formula as follows: {PLANNING_JOB_STAGE_LINES.INPUT_QTY_STD_BATCH}/{PART_UOM_CONVERSIONS.UOM_CONVERSION_FACTOR}
  16. 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...
  17. PJOL

    Formula editor and sub reports

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

    SPNEGO negotiator

    Thanks: I checked out the link and read through the appropriate information carefully. I downloaded the 'lockout status' tool and ran the tool against the user in the domain. There was one dc in the domain for this user with positive Bad Password Counts. I had to reboot this dc anyway because of...
  19. 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...
  20. PJOL

    Formula editor and sub reports

    Thank you. No, that option was not selected, but the 'Keep group together' did the trick. Thanks for pointing me in th right direction.

Part and Inventory Search

Back
Top