Can't see new database fields in report 8.5

[CESHRPR]

I have to create a report very similar to one already existing so I am using that old report as a starting place. However, the new report requires fields that are new to a table already used in the report. When I check in SQL Plus, the new fields are in the table. When I add the database table to the report however, they do not appear for selection.

It says I'm already using the table and do I want to make it an alias. I first said no, went in, and deleted it from the Visual Linking form. Then I added it from the database. It still says I am using it and asks if I want to make it an alias. I did, and even as an alias the fields don't appear.

Am I going to have to delete every field on the report that uses that table and then add it back? Please tell me there's another way. A previous programmer ran into this before and she said she thought it had to do with 'verify database' but she hasn't been able to figure it out either. Thanks for your help.

 

[synapsevampire]

Why did you add it in again if you alreayd had it?

I trust that you didn't save the report afterwards.

Just open the report and select Datbase->Verify database

All fields that are available for selection (some data types may not be) by Crystal should now be in the list of available fields.

Also post your database type and connectivity used when asking about data. I figured out that you're using Oracle based on SQL Plus, but the connectivity might be a concern, as might the database version.

Why people think that databases have nothing to do with data issues always amazes me.

-k