posted 9/10/2010 by ChrisAlbrektson - Views: [2620]
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
Thanks for posting this! Can't find any other documentation on it. I have a process that is extracting from the SSRS content store and I got a foreign key violation when doing some initial R2 testing. I was missing a new type of 8 for a shared data set that had been created. I also noticed the 9 associated with some shared report part parameters I saved out on the server. I wasn't sure if 9 was only for parameters or for all report parts, and I also wasn't sure of what else could be lurking out there that just hasn't shown up yet that will break my process in future runs.