How do I custom summary reports for Security Manager (or RDL file for SRS) (NETIQKB72062)

  • 7772062
  • 28-Jan-2010
  • 01-Feb-2010

Environment

Security Manager 6.x

SQL server business intelligence development studio
SQL reporting server (SRS)

 

 

Situation

What information is needed to create a custom report for Security Manager?

How can I make an RDL to import into Security Manager reporting?

Resolution

Below are steps to create an rdl file to import into SQL Reporting Server.  These instructions only explain how to use the Microsoft tools to build a custom query.  The actual query design requires your specific requirements and use of SQL SRS.

 

  1. go to start\all programs\Microsoft sql server 2005\ SQL server business intelligence development studio
  2. file\new\project\report server project wizard   Note: make note of the location box in this window, this where you will find the .rdl file upon completion of the project.  Click next.
  3. The ?welcome to the report wizard? window opens, click next.
  4. The ?select data source? source window opens.
  5. name: can be whatever you decide
  6. type: Microsoft sql server analysis services
  7. connection string: Data Source=reporting_server_name;Initial Catalog=smreporting
  8. click next
  9. The ?design the query? window opens. Click design query.
  10. The ?query builder? window opens.
  11. All of the metadata should be available on the left side of the window.  The customer can begin to build the query.
  12. Once the query has been complete, click OK
  13. The ?design the query? window opens. Click next
  14. The ?report type? window opens. Choose a report and click next
  15. The ?design the table? window opens. Configure as desired and click next.
  16. The ?choose the table layout? window opens. Configure as desired and click next.
  17. The ?choose the table style? window opens. Configure as desired and click next.
  18. The ?choose the deployment location? window opens. Configure as desired and click next.
  19. The report name and summary overview appear.  Click finish.
  20. The next window will allow you to preview the report.
  21. If you are happy with the preview, the .rdl file is now ready to be imported into the reporting server summary reports.  Refer back to step 2 to find the location of the rdl file.

For more information or details about SQL SRS, please refer your to Microsoft on-line help or www.microsoft.com.

Additional Information

Formerly known as NETIQKB72062