Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to use values from an overridden Select Statement

Status
Not open for further replies.

pabowen

Programmer
Nov 6, 2002
95
US
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
 
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top