Hello. Some one know if there are a way to prepare or make custom reports in SCCM 2007, I mean the built in reports are good but the customer are expecting another kind of reports, for example Pye graphsor bar graphssome like that, how can I make them? Thank you in advance

Hi,Configuration Manager 2007 allows you to create custom reports if you have a little knowledge of SQL. You can also quite easily incorporate graphs and charts into these reports. Best place to start is the topic 'Reporting in Configuration Manager' (http://technet.microsoft.com/en-us/library/bb632630.aspx) in the Configuration Manager documentation library; all of the basics you'll need are in there. A Web search will also bring up many examples of custome reports and queries that you can modify for your own uses.Hope this helps.Rob StackTechnical Writer - Configuration Manager

Or the short answer.... write your query in SQL Analyzer and paste it into a new report.John Marcum, Systems Management Architect - www.TrueSec.com

If you are using SQL Reporting Services functionality with the SCCM 2007 R2 release you can refer to the following tutorial that illustrates how to use Report Builder to create reports with charts.http://blogs.technet.com/configmgrteam/archive/2009/03/17/sql-reporting-services-tools-and-features-part-1-creating-configuration-manager-2007-reports-using-report-builder-2-0.aspxThanks,bhaskar

One thing to add: Make sure you build your reports from views not tables.