Configuration Manager 2007 gives you an option to create New folder (kind of Custom reports folder ) with New Category to create your Own reports what you required But in Configuration Manager 2012,i don't see way to create New folder to create all the custom reports for your reference.
Creation of Custom folder is not available in configuration Manager 2012 ,the only option left out is to go with Category .
How do you create New Category ? If you right click on reports node from Configuration Console,you don't get such option to create one.
You will have to go with web reports with enough rights to create it.
Open IE with SSRS report manager website : http://SCCMServername/reports
Click on the Report Folder (Configmgr_Sitecode)
Click on New Folder which is actually a Category to create reports underneath.
give A Name what you would like with some Description and click ok
the custom category what we created You see it below :
Now open the Console and go to monitoring node—>reporting-->reports
Now we can create our Custom reports in Custom Folder But how ? you don't get an option to create new report under Custom Category.
Right click on reports node and select Create Report
Enter the right name for the report and then select the path where you want to store the report under ?
Once you are finished with the report,you will be prompted with Report Builder to enter the SQL query and more customizations.
Hope it Helps!
3 Comments
Hi Eswar,
All your posts are very helpful just like this one.
Where are these custom reports stored? I can't find them under SMS_SRSRP/Reports folder.
Thanks
Sana
custom reports you upload via web browser are not stored in SMS_SRSRP folder until you create them via Console.To download /upload reports from SSRS ,you can use tools like reportsync as outlined here http://eskonr.com/2014/11/sccm-configmgr-how-to-import-export-migrate-upload-reports-to-cm12-easy-way-using-reportsync-tool/
Pingback: Anoop's » How to Create Custom Reports in ConfigMgr SCCM 2012