view not showing in data explorer 1

[maryellc]

I'm attempting to add a SQL Server view to an existing CR (using CR 8.5). In options I've designated in the 'database' tab 'tables', 'views' and 'stored procedures', but I only see 'tables' and 'stored procedures' when I select the database.

Any help would be greatly appreciated.

 

[kchaudhry]

Have you tried:

Database > Verify Database ?

Kchaudhry

 

[maryellc]

I have tried doing that. I can see and access the views in SQL Server Enterprise manager (as well as the tables and sprocs), but can't in Crystal. I thought that perhaps a database logon issue was the cause but if I can access via enterprise manager I tend to think that isn't the problem.

 

[kchaudhry]

Not sure why this is happening. You can try adding the database again:

Database > Set Location



Kchaudhry

 

[maryellc]

Even when I try 'set location' I still can't see views. The two existing tables I'm reporting on are displayed (and I'm not replacing either of those), and clicking on set location opens up the data explorer (and no views).

 

[kchaudhry]

Ok try creating a new report. Do you see the views in there?

Kchaudhry

 

[maryellc]

I tried that too. Not even on a new report do I see anything other than tables and sprocs in data explorer, even though I have all set (tables, views, sprocs) in 'options'.

 

[vidru]

Check in the Data Explorer's Tables for your view. That's where my views show up.

-dave

 

[maryellc]

Son of a gun! That's where they are!

Thanks for everyone's help!

 

[kchaudhry]

I thought thats where you were looking. Dave thanks for the help. This proves two heads are better than one

Kchaudhry

 

[maryellc]

I meant that in the data explorer tree, only tables and sprocs were displayed for the selected database. I didn't even attempt to look within 'tables' for my views because...well...I was expecting to see it as its own branch.

Apologies and thanks for my maybe not-so-clear explanation of the problem.