Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Community Member

UCCX 8.5 and crystal formulas

HI All

Does anyone happen to know how the crystal reports in the uccx 8.5 historial reports work?  For example, I opened the agent summary report and it seems to be calling a stored procedure called sp_agent_summary however I don't see any select statements in the function.  So how does it pull the data from the database?

Thanks

2 ACCEPTED SOLUTIONS

Accepted Solutions
Cisco Employee

UCCX 8.5 and crystal formulas

Hi,

sp_agent_summary is a stored procedure. All select statements will be contained in the stored procedure itself. Crystal Reports will just invoke the SPL with the appropriate arguments and it will do the queries in the DB and then just return the results in table form.

If you want to see the actual queries in the SPL you can connect to the DB Informix instance with something like Squirrel or AGS with uccxhruser, you can read the SPLs and see the actual commands. More info on this is in the HR Admin and Dveloper guide.

-Ryan

This post was made from the TSC at CiscoLive 2012!

Super Bronze

UCCX 8.5 and crystal formulas

Hi

You'll need to look a bit closer at the function - it sounds like you have opened the function and seen the SQL?

Somewhere in the code are references to 'getAgentSummary' which is another function/procedure that is called from within this function. There's a lot of this done in the standard reports, one function might call another that may call several other utility functions so it's a fun learning experience.

Regards

Aaron Harrison

Principal Engineer at Logicalis UK

Please rate helpful posts...

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
3 REPLIES
Cisco Employee

UCCX 8.5 and crystal formulas

Hi,

sp_agent_summary is a stored procedure. All select statements will be contained in the stored procedure itself. Crystal Reports will just invoke the SPL with the appropriate arguments and it will do the queries in the DB and then just return the results in table form.

If you want to see the actual queries in the SPL you can connect to the DB Informix instance with something like Squirrel or AGS with uccxhruser, you can read the SPLs and see the actual commands. More info on this is in the HR Admin and Dveloper guide.

-Ryan

This post was made from the TSC at CiscoLive 2012!

Super Bronze

UCCX 8.5 and crystal formulas

Hi

You'll need to look a bit closer at the function - it sounds like you have opened the function and seen the SQL?

Somewhere in the code are references to 'getAgentSummary' which is another function/procedure that is called from within this function. There's a lot of this done in the standard reports, one function might call another that may call several other utility functions so it's a fun learning experience.

Regards

Aaron Harrison

Principal Engineer at Logicalis UK

Please rate helpful posts...

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
Community Member

UCCX 8.5 and crystal formulas

The procedure I needed was called getTotalCalls that gave me the info for calls presented and handled.

717
Views
0
Helpful
3
Replies
CreatePlease to create content