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
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