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 derfloh 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
  • Order by date
  1. w1mnk

    Record Selection Question

    I apologize in advance for the size of this. Here is the record selector: If IsNull({?FunctionalArea}) Then ( ({APPROVAL.GROUP_ID} In...
  2. w1mnk

    Record Selection Question

    Very Interesting. NONE of the selection criteria, other than the group selections, is being passed through to the SQL. I guess that means that the selection criteria is being applied after the SQL retrieves the records? Can this be changed. I seem to remember that Database -> Show SQL query ->...
  3. w1mnk

    Record Selection Question

    synapsevampire, thank you for the speedy reply. It is greatly appreciated. I do have a question. I have record that is CHANGE.RECORD_STATUS = 'CLOSED' CHANGE.START_DATE = 2003/08/29 CHANGE.CLOSE_DATE = 2003/09/01 I'm not sure why it isn't selected by {CHANGE.RECORD_STATUS} = 'CLOSED' And (...
  4. 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...
  5. w1mnk

    ODBC DB2 Error

    Greg, Do you mean is the database on the OS/390 enabled for ODBC? Or is it defined in my client configuration as enabled for ODBC? The answer to both is yes. And note: someone else, on a different PC, can access the DB via ODBC using my id, which indicates something is wrong on my PC for...
  6. w1mnk

    ODBC DB2 Error

    Marc, this system administrator has said that I shouldn't need the authority to do binds for Crystal Reports. Where is the automatic rebind? Is that part of Crystal? Many thanks for the help. Jon
  7. 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...
  8. w1mnk

    Table Aliasing

    Ian, the SQL is from CR 8.5
  9. 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...
  10. 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.
  11. 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
  12. w1mnk

    Crystal SQL Designer Version

    Naith, thank you for the information. That's what I suspected, but I wanted to be sure. Jon
  13. 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