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

    CE9 Database errors

    System is now stable with no issues since changing ODBC
  2. jrperry

    CE9 Database errors

    FERDIO, If you still are experiencing this issue, can you check how your ODBC connection to the APS is setup, in particular, have you checked the 'use regional settings' option. Also, check to see if your regional settings for the APS or Crsytal Enterprise server is set to US or local setting...
  3. jrperry

    CE9 Database errors

    You could be right Ferdio, Do you use a generic user id for users or do they have unique authentication.
  4. jrperry

    CE9 Database errors

    Hi Ferdio, We have this problem from time to time and when it does happen there is not much to go on. I have set up trace levels on all components and the information has been passed on to our local support company but no real solution has been found. I will keep you updated, but if you find...
  5. jrperry

    CE9 Database errors

    Has anyone come across the following message: Database access error. Reason [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'APS_InfoObjects2' with unique index 'APS_InfoObjects2_I1'.. We use SQL Server as the CE9 database. This error appears to be...
  6. jrperry

    Report Refreshes When Viewed

    I have a number of scheduled Crystal Reports that are sent to certain user via email. When the recipient, who has Crystal Reports installed on their PC, opens the report, it tries to refresh the report. Why is this happening?
  7. jrperry

    No Records

    The solutions provided worked, thanks for your assistance.
  8. jrperry

    Date Format in Seagate Info changes

    Thanks for this information, I found that as I was running the service under a different context than the one actually logged on, that Seagate Info would only use the default date format, no matter what. I changed the context to a user that had the correct date format setup for the system and...
  9. jrperry

    No Records

    Unsure if this is easy or not. I know I can supress printing if their are no records, but can I add something that will either: 1. Say something on the report "No records for this period" 2. Set an event in Seagate Info only if no records were found so I can use this event to kick...
  10. jrperry

    Date Format in Seagate Info changes

    When reports are opened in Report Designer and previewed the date format is correctly displayed as dd\mm\yy When a scheduled instance of the same report is run the date format is displayed as mm\dd\yy. I have checked the regional settings on the Seagate Info server and have confirmed that the...
  11. jrperry

    254 Character string Limit

    Excellent feedback, did the trick. Cheers from kiwiland
  12. jrperry

    254 Character string Limit

    Is there any way to circumvent the 254 character string limit? I have 5 string fields which are all description fields in the database. i.e Description1, Description2... I want to treat these fields as one text field in the report so the report when exported, exports each record containing all...
  13. jrperry

    Time Period Formula

    Thanks, this worked fine.
  14. jrperry

    Time Period Formula

    I need to generate a report based on a particular time period. The time period is from 3:00pm yesterday to 7:59am today. This report has a datetime field which is used in the selection criteria. The report has to be automated so setting a specific date value is not possible. The report engine...

Part and Inventory Search

Back
Top