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"...
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.