Skip to Content

Crystal Reports 2011 & SQL Server - Unable To See Views

Good Day,

So I have a situation where SAP Crystal Reports 2011 is being used with SQL Server (2012 - this is speculated) however, the views can not be seen but the tables are.

Can you tell me what is happening here and a solution to this please?

Thanks in advance everyone!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 21, 2015 at 10:15 PM

    Hi Kandia,

    In Crystal if you go into the Options, there is a database tab.  Make sure Views are selected.  You'll have to exit Crystal and restart before you can see the views. 

    Good luck,

    Brian

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 27, 2015 at 02:07 PM

    Yes, I am using the SQL Native 11 Client.

    Any other ideas??!

    I need to be able to use the Set Datasource Location in order to change to a view, but cannot because I cannot see the views!

    Thanks!

    Add comment
    10|10000 characters needed characters exceeded