AnsweredAssumed Answered

How to edit OOTB Crystal Report SQL query with parameters?

Question asked by ataka on Jul 15, 2014
Latest reply on Jul 23, 2014 by ataka

I'm trying to add a field to an OOTB crystal report but when i update the query in the edit command section it prompts me to enter the parameter values.  When i try entering parameter values it gives me the following error:  "Failed to retrieve data from the database.  Details: ORA-00904:: invalid identifier".  Does anyone know how to save the query without having to enter parameter values?  Or possibly figure out a way to find correct parameter values so that i'm able to save the report.  I tried running the report and exporting the crystal report and entering the parameters that show up in the "Show Current Parameter Values" section but that didn't work either. 

Thanks,
Aaron

Outcomes