Sunday, November 18, 2012 2:11 AM
Can any one tell me where can I find my SSRS templates on my new fresh installed SQL Server 2012 Enterprise Full installation pc. In Data Tools I cannot find any in SQL Server branch. Can anyone tell me what I am missing?
Nilkanth S. Desai
- Moved by Maggie LuoMicrosoft Contingent Staff Monday, November 19, 2012 7:36 AM (From:SQL Server Setup & Upgrade)
Sunday, November 18, 2012 3:36 AMhttp://www.databasejournal.com/features/mssql/creating-a-custom-report-template-in-ssrs.html
Thanks, Rama Udaya.K "“You only live once, but if you do it right, once is enough. ― Mae West". ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.
Monday, November 19, 2012 9:24 AMModerator
The Business Intelligence (BI) Templates are only shipped with SQL Server Data Tools (SSDT) with specific SQL Server 2012 editions. Besides, Visual Studio 2012 also introduces a SSDT which doesn't has BI Templates. So, I guess the SSDT you ran is the SSDT shipped with Visual Studio 2012 not SQL Server 2012. Please note that the SSDT shipped with SQL Server 2012 cannot be integrated with Visual Studio 2012. In this way, to run the SSDT shipped with SQL Server 2012, please be sure to click Start -> All Programs -> SQL Server 2012 -> SQL Server Data Tools.
If the issue persist, please check the SQL Server Reporting Services Edition from Reporting Services Configuration Manager and capture a screenshot of the SSDT templates list.