IPOCC custom reporting

[jtarjanyi]

Hello,

We need to create custom reports for our customer, which will contain calculations, so the built-in reports is not suitable, but can provide base data.
I have 2 possibilities (I think):

• Use 3rd party reporting tool; like SSRS + Report Builder on "TR" database
• Using excel macro on top of the generated report

Unfortunately there is not so much information is available about these topics. If anybody have information how to use macros with IPOCC reports to make calculation, or using 3rd party reporting tool please share with me.

Thanks and regards

Janos

[mnorst]

I have spent some time trying to reverse engineer the TR database->Report fields without complete success. I've been looking for a doc with the field calculations (i.e. FieldX is calculated by adding columnA +columnB - columnD) but haven't been successful. It may be that the Excel macro may be the best approach?

[jtarjanyi]

Yep.. would be great to know how to use this macro posibility:



Has someone any knowledge about this ?

[covar]

Hi,

I've been trying to set up custom parameters to filter information displayed on a Tablix element.

I've managed to get it to work within Report Builder 3.0, where I would ask for agents' names, and queue names.

However, once I upload the report to the Avaya CCR and try to run the report, I won't have any of those custom parameters to select from or filter information contained in a report.

Does anyone know how to "ask" for those parameters within Avaya CCR Reporting?

[jtarjanyi]

Originally Posted by covar

Hi,

I've been trying to set up custom parameters to filter information displayed on a Tablix element.

I've managed to get it to work within Report Builder 3.0, where I would ask for agents' names, and queue names.

However, once I upload the report to the Avaya CCR and try to run the report, I won't have any of those custom parameters to select from or filter information contained in a report.

Does anyone know how to "ask" for those parameters within Avaya CCR Reporting?

Hello,

I think you have to post this question in a separate topic, because this is IPOCC related and not CCR.

Regards
Janos

[kruegerb]

regarding using excel Macro for historical reports: see attached document

[jtarjanyi]

Originally Posted by kruegerb

regarding using excel Macro for historical reports: see attached document

Many thanks!