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 bkrike 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: jrperry
  • Content: Threads
  • Order by date
  1. 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...
  2. 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?
  3. 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...
  4. 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...
  5. 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...
  6. 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