New View not showing up!

[numina]

I have been trying to figure out this problem for days.
I have created a view in my database and tested it using plain sql. The view does come up in Brio Reports using the same user ID. The problem is I can't see it in my Crystal Report. I refreshed, logged out, even rebooted my machine, and still the table doesn't show up. Also, I have made sure that the Show View option is checked.

Am I missing anything. Is there something that needs to happen after adding a view or a table? I would greatly appreciate any pointers.

Thanks and Regards,
Numina

 

[dgillz]

Database, Verify database works when you have made physical changes to a database and you want crystal to read them. I assume it works the same with views. Software Support for Macola, Crystal Reports and Goldmine

 

[numina]

The database works. Maybe this has something to do with it, but I created the view using the Application Designer in PeopleSoft. But then it should work since I am able to query the view via sqlplus.

Numina

 

[dgillz]

In terms of not seeing database changes, this is a crystal reports trait. You must always verify database for CR to see the DB changes. I just assummed it was the same with views.

Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com

 

[numina]

I'm not sure I understand. How do I verify my DB for CR? Could you please elaborate.

Thanks.
Numina

 

[dgillz]

In Crystal Reports, click on "database" then "verify database".

If you make changes to a database structure (not the actual data itself, but the field names, lengths, data types, etc.), Crystal Reports will not automatically read those changes. You must verify the database as I mentioned above. I assume that this holds true for views as well, if you add a field to a view CR may not read it immediately.

Try this and post your findings. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com

 

[numina]

Did 'verify database'. I got three pop up windows with the same message: "Database is up to date". The view is still not coming up (Even after restarting CR).
Is it a good idea to log this issue with PeopleSoft since I am using Crystal Reports for PeopleSoft.

Numina

 

[dgillz]

The other thing you can try is 'Database' then 'set location' and make sure you are pointed at the proper view with the changes you have made.

If that doesn't work then yes I would call peoplesoft. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com

 

[balves]

The most obvious possibility is that you are connecting to the database in Crystal with a different username than Brio and do not have permissions to the view. Database / Set Location will tell you who you are connected as in the report.

Try giving everyone/every group permissions to the view and then create a new report and attempt to select the view as the data source.