Re: crystal report produces ORA-01007 error

you can add a field by selecting it from the available fields list - it will be used in addition to the ones you specify in your custom sql ..use the reset function when viewing the sql to insure it gets added.. * BTW, this is a Crystal design problem not, strictly, an Oracle one, so you may want to post follow-ups in a more appropriate group

You need to identify which field is being used in a formula or criterion and is not in your select list in the SqlQuery..

xenofon.grigoriadis_at_planet-interkom.de (Xenofon Grigoriadis) wrote:

>Hi there!
>
>I have a report with a non-standard format.
>
>Now, I want to extend the report to use some other table-fields, but
>the Oracle-DB says :"variable not in select list".
>
>How can I extend the report by a field? Viewing the SQL-Statement I
>can modify the FROM, WHERE, ORDER BY and GROUP BY sections but not the
>select section.
>
>I can not use also this stupid report-assistent, which drives me
>crazy, because there is no "OK" or something like that and because he
>always my format.
>
>Can anybody help out? If the information is not enough, does hesitate
>to ask and I give more information to the problem.
>
>Thanks a lot in advance...
Received on Wed Nov 20 2002 - 11:36:27 CST