Created View not available to Crystal

[dianne2n]

I'm running Crystal Reports V 8.5

I created a "view" using SQL+ and now I want to use
that view for my Crystal Report.
Are there some permissions, grants, or other things
that I also need to do at the SQL level in order to
see my newly created view in my list of available ones to Crystal?
(This is way out of my expertise and we don't have
an Oracle (version 9) Database Administrator)

Dianne2n

 

[synapsevampire]

Yes, you must grant privileges to any objects created in Oracle (you might mention your database, the tool used to create it in the database doesn't matter).

Also you might need to select Options within the data explorer and check Views to include them in the available data sources. Make sure you then refresh the list too (select the source and hit F5).

-k