CODEWITHSUNDEEP
viewcrystal-reports
rjenkins
rjenkins

Reputation: 11

How to add a new view to the Field Explorer in Crystal Reports

I have created a new view and want to add it to an existing crystal report. In the Database Expert there are options to add a new table but not a new view. I want to select fields from the view, not the tables.

Upvotes: 1

Views: 9361

Answers (2)

Kangkan
Kangkan

Reputation: 15571

Views are also allowed to be added in the Database Expert. Look into the Crystal Reports Options in the Crystal Reports menu. (Are you using Crystal Reports or Visual Studio?). There will be options to select object types in the database options.

If you create a view after you connect to the database from the Crystal Reports, you may not see the new views. For the views to be visible, go to Database menu and click verify. This will make the new views visible to you.

Otherwise, see if the user you are using to connect to the SQL server has adequate grants to see, use the views or not.

Upvotes: 0

C Harmon
C Harmon

Reputation: 208

If the new view is not visible from within Crystal then try following this menu path:

Database->Verify Database - This will refresh the database. Then select Database->Add Database to Report...this will open the data explorer and the new view should be visible.

Upvotes: 0

Related Questions