UCCX 8.5 and crystal formulas

[jack_j_zheng]

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

[Ryan LaFountain · Accepted solution]

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!

[Aaron Harrison · Accepted solution]

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

[jack_j_zheng]

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