Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

Cross Reference for ReportServer.dbo.Catalog.Type

  • 10 September 2010
  • Author: ChrisAlbrektson
  • Number of views: 12608

The chart below will help you if you ever need to work in the ReportServer database and can’t figure out what Type is in the Catalog table. Believe it or not but there’s not much documentation on this just a few websites asking this same question. TomLannen and I did some research on this on the internet and found the answers for types 1-6. It looks like the values after six have been added with the 2008R2 release. After working on this we saw a need for this and figured this was BIDN worthy. It’s not complete so please feel free to add to it now or after the next release in 2011. Or just inform me and I will update the posting.

Type      Name

1              Folder

2              Report

3              Resource

4              Linked Report

5              Data Source

6              Report Model

7              ?

8              Datasets

9              ReportParts

Categories: Blogs
Rate this article:
No rating


Other posts by ChrisAlbrektson

Please login or register to post comments.