Re: crystal report produces ORA-01007 error

From: Stuart MacKinnon <applicationz_at_paradise.net.nz>
Date: 20 Nov 2002 12:09:38 -0800
Message-ID: <56db38fe.0211201209.1972eef7@posting.google.com>

xenofon.grigoriadis_at_planet-interkom.de (Xenofon Grigoriadis) wrote in message news:<1672675a.0211200658.65eb25b8_at_posting.google.com>...
>
> 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?

If I understand you correctly, it might be worth trying to "Verify Database" while your report is open in the Crystal Report Designer (Accessed from the menu "Database" > "Verify Database"). This refreshes Crystal's 'knowledge' of the underlying tables and views. Then you should be able to insert any new fields into your report using the "Insert Fields" button.

Hope that helps. If not, others here may have more useful ideas.

Regards
Stuart Received on Wed Nov 20 2002 - 14:09:38 CST