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!

Register Log in
  • 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: DawnJ
  • Order by date
  1. DawnJ

    <Default Format> when Export to Excel 2002

    No such luck. Luckily no users have complained about this yet, probably because most don't have Excel 2002. I'm ignoring the issue for now, because I am looking at replacing Crystal Reports anyway. The new pricing structure for user licenses may put it out of our price range, unless I can get...
  2. DawnJ

    Can't drop index - PRIMARY KEY constraint

    I guess I just needed to take a lunch break - it finally came to me that the primary key was not just an index, but also a constraint that had to be removed. The following syntax did the trick. alter table WS10702 drop constraint PKWS10702
  3. DawnJ

    Can't drop index - PRIMARY KEY constraint

    I'm getting the following message when I try to drop a clustered index: An explicit DROP INDEX is not allowed on index 'WS10702.PKWS10702'. It is being used for PRIMARY KEY constraint enforcement. This table is a 'work' table and really doesn't need a clustered index. It has several...
  4. DawnJ

    <Default Format> when Export to Excel 2002

    I have Crystal Reports 8.0, Excel 2002 on Windows XP. When I export to Excel 8.0 files from Crystal and open the spreadsheet in Excel 2002, all 0(zero) values are displayed as <Default Format>. If I have someone else open the file that I exported, regardless of their Excel version, they also...
  5. DawnJ

    Out of Memory Problem - Urgent !!!!

    I'm having a similar problem, but mine appears to be related to assigning values to the parameters from the VB program when it displays the second report. You may be able to fix your problem by resetting the application and report objects. After the ViewReport line, add: Set crRep = Nothing...

Part and Inventory Search

Back
Top