Search results for query: *

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

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

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 (...

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

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

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

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

Ian, the SQL is from CR 8.5

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

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.

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

Naith, thank you for the information. That's what I suspected, but I wanted to be sure. Jon

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