Avaya Support Forums

Avaya Support Forums (http://support.avaya.com/forums/index.php)
-   IP Office Contact Center (http://support.avaya.com/forums/forumdisplay.php?f=67)
-   -   IPOCC custom reporting (http://support.avaya.com/forums/showthread.php?t=12209)

jtarjanyi 11-28-2016 03:31 AM

IPOCC custom reporting
 
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 11-28-2016 12:18 PM

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 11-30-2016 04:32 AM

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

http://i.imgur.com/BXshrs5.png

Has someone any knowledge about this ?

covar 04-24-2017 03:31 PM

Custom parameter Report Builder 3.0
 
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 04-26-2017 04:21 AM

Quote:

Originally Posted by covar (Post 30489)
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 04-27-2017 12:50 AM

1 Attachment(s)
regarding using excel Macro for historical reports: see attached document

jtarjanyi 04-27-2017 02:05 AM

Quote:

Originally Posted by kruegerb (Post 30589)
regarding using excel Macro for historical reports: see attached document

Many thanks!


All times are GMT -7. The time now is 09:14 AM.