cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

815
Views
5
Helpful
4
Replies
Beginner

CUIC customization-How to Create a custom report using custom SQL, Edit View, Edit Filters, and scheduling reports for customers.

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.

4 REPLIES 4
Contributor

Re: CUIC customization-How to Create a custom report using custom SQL, Edit View, Edit Filters, and scheduling reports for customers.

Advocate

Re: 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.

 

Regards,

Geoff

Engager

Re: CUIC customization-How to Create a custom report using custom SQL, Edit View, Edit Filters, and scheduling reports for customers.

Hi guys,

 

How can I create custom value lists and Collections to apply filter in the customized report?

 

Best regards

Daniel Sobrinho
Highlighted
Contributor

Re: CUIC customization-How to Create a custom report using custom SQL, Edit View, Edit Filters, and scheduling reports for customers.

CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards