ODBC Error ORA-00904:invalid column name????

[kamv]

Hi,

I have been creating a report using Crystal 8.5. After creating a parameter for entering a location and a formula to change the text of the location when it displays on the report I got the following error when running:

Crystal Reports Database Error:
ODBC error: [Oracle][ORA]ORA-00904:invalid column name

When I click ok the following message appears:

Crystal Reports:
Error detected by database DLL.

This is my seventh report I have created using this ODBC connection. The parameters and formulas are the same as the other reports. This is the first time I ever got this message.
Any Suggestions????

Thanks,
Kamv

 

[kamv]

Never mind folks.
Problem solved (I had the wrong link between 2 of the tables)
Thanks anyways!
Kamv