How to use values from an overridden Select Statement

[pabowen]

Hello,

Due to some complex SQL statements I have had to override the Crystal generated SQL statement.

The overridden SQL Statement uses fields that do not originate in the tables/view being used by the report. I need to use the values in the report.

Now that I have done that, how can I use those fields in my WHERE clause (generated from the Edit Selection Formula , Row) and how do I display those values in the report.

I have successfully overridden the select statement, but now it tells me those values are not valid fields when I try and use them?

Has anyone done this before??? Thanks for the help.

Patrick

 

[synapsevampire]

Please post your Crystal version and the database/connectivity type.

You cannot successfully (at least I don't know anyone who has, and Crystal states that it cannot work) overwrite the prepared SQL statement in CR 8.5 or below, and in CR 9 or above you use an Add Command, not overwriting the SQL.

So also state HOW you "override" the SQL, as you can also use other means than previously mentioned.

-k