ReportBuilder 2 Views not displayed

Question

Hi,

What possible reasons are there for not seeing the Views node in the Query Designer?

When I connect using the same credentials via SSMS I can see the views.

Answer 1

Which version of SQL Server are you connecting to?

If it is SQL Server 2005 or greater, try running the following query in Report Builder's text mode query designer:

select sys.views.name as [name], sys.schemas.name as [schema] from sys.views left outer join sys.schemas on sys.views.schema_id = sys.schemas.schema_id

Does the view you are looking for show up?

Also, note that the treeview in Report Builder is organized differently than SSMS -- Tables/Views are organized by user schema, so make sure you check under all information schemas (the schema name is also returned by the query above).

Thanks,
Denesh.

---

This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 2

It is version 8.00.2039 (SQL 2000)

Answer 3

For SQL 2000, try the following query:

select sysobjects.name as [name], sysusers.name as [schema], sysobjects.[status]
from sysobjects
 left outer join sysusers on sysobjects.[uid] = sysusers.[uid]
where sysobjects.xtype = 'V'

Does your view show up?  If so, what is the 'status' value of it?

---

This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 4

yes the view does appear in the results. The status is 0

Answer 5

You've found a bug.  The query designer is incorrectly identifying your view as a system view.  Could you please go to Microsoft Connect and log this bug?  Please cite this forum thread in the bug also.

If I can figure out a workaround I'll update this thread to let you know.

Thanks,
Denesh.

---

This posting is provided "AS IS" with no warranties, and confers no rights.