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 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: w1mnk
  • Content: Threads
  • Order by date
  1. w1mnk

    Record Selection Question

    I'm having a problem (I think) with a record selection forumula: If IsNull({?FunctionalArea}) Then ( ({APPROVAL.GROUP_ID} In 'XXX-XXXXXXX','yyy-yyyyyyy'] Or {CHANGE.ASSIGNEE_GROUP} In 'XXX-XXXXXXX','yyy-yyyyyyy'] Or {CHANGE.REQUESTER_GROUP} In 'XXX-XXXXXXX','yyy-yyyyyyy') And...
  2. w1mnk

    ODBC DB2 Error

    I'm getting an error within Crystal Report when trying to access a remote DB2 OS/390 database. I'm using IBM UDB 7.2 on Win2K. Crystal Reports is v 8.5 The error is: ODBC Error [IBM][CLI Driver][DB2] SQL0551N "MYID" does not have the priviledge to perform operation "BIND&quot...
  3. w1mnk

    Table Aliasing

    Here is a sample of Crystal SQL: FROM "IGSVIEW"."FINANCIAL_CUSTOM" FINANCIAL_CUSTOM RIGHT JOIN "IGSVIEW"."IS_INVENTORY" ON FINANCIAL_CUSTOM."IS_INVENTORY_ID" = IS_INVENTORY."IS_INVENTORY_ID" INNER JOIN...
  4. w1mnk

    Fatal Error in Report Distribution Expert

    When I try to use the Report Distrubution Expert (dexpert.exe) I get a fatal error ( instruction xxxx tried to write to 0x00000002) when selecting "next" from the first screen. I'm running CR 8.5 on Win2K SP2. Has anyone seen this? Any fixes? Thank you for any help.
  5. w1mnk

    Date Formats

    I have a database wherein the date and time is stored as yyyy-mm-dd hh:mm:ss.00 (note the "dash"es) Is there a formula that I can use to convert the date to the Crystal format mm/dd/yyyy? I need to use a date range as a parameter. Any help is greatly appreciated. Thank you. Jon
  6. w1mnk

    Crystal SQL Designer Version

    I installed CR 8.5 Developer as an upgrade of a CR 8.0 Developer installation. I noticed that when I start Crystal SQL Designer, it is still at version 8.0.0.0, while Crystal Reports is at version 8.5.0.217. Did SQL designer not get updated, or is my version the latest? Thanks for any help. Jon

Part and Inventory Search

Back
Top