Parameters

[ssim78]

I have a report that works fine if I hardcode the value for country. But I want to parametrize this field (it's a string) and want that the user should be able to select more than one value for the 'country' field. I have entered my data retreival logic in the form of an SQL in the command section of the database expert. When I create a paramater field in the command section, and select value type as 'string', there are 2 issues:
1. In the default values section, I have to type some value. I want all the values of the country field to show in the drop down, so that a user can view this report for several countries.
2. When I do type in a country name in the default section (say i type in "UK"),and then click "ok", I get the following error message:
"Failed to retreive rowset" . Details:ADO error code: 0x80040e14
Source OraOLEDB
Decscription: ora-00904 : "UK invalid identifier"
Native error: 904
My SQL is of the form:
select .... from...... where ....and
COUNTRIES.COUNTRY_NAME IN ({?country})

Please help....

 

[synapsevampire]

Please post your software version...

-k

 

[ssim78]

CR 10, Oracle 9i

 

[Turkbear]

Hi,That error usually means that whit is being sent to the database is not what you expect:
----------------------------------
ORA-00904 string: invalid identifier

Cause: The column name entered is either missing or invalid.

Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word.


-----------------------------------------------------



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Two ideas, the first being that you're using an unsupported connectivity type for Oracle, it appears that you're using the slow and problematic OLEDB, use the Oracle native connectivity included with CR 10, or the proprietary Oracle ODBC driver supplied by Crystal, don't use the Oracle supplied ODBC driver.

Also keep in mind that a parameter created within a Add Command does not support multiple entries.

If all of this fails to help, post your exact rather than the "of the form" sql.

-k