Hi,I have not done report customization someone point to the document for CUIC customization-How to Create a custom report using custom SQL, Edit View, Edit Filters, and scheduling reports for customers.
Read the documents.
Create the SQL command in SSMS until it does what you want. All returned variables must be named (no SELECT * FROM).
Work out the WHERE clause. Learn how to replace DateTime with :start and :end then set up the parameters for relative dates. Understand your value lists.
Anonymous Queries are slightly easier than Database Queries as the WHERE clause is not quite so opaque, although once you get the hang of it the DB queries are fine.
Build a report with all the returned values in the view then create a new view to do what you want. Do a few "Save As" on the stock reports and see how Cisco did it. Start with something easy and play with it. ]
Think of it as a fun exercise and don't be disheartened. It's very rewarding. Once you get something working, read the documents again and again.
How can I create custom value lists and Collections to apply filter in the customized report?