Avaya Support Forums  

Go Back   Avaya Support Forums > IP Office Contact Center

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 11-28-2016, 04:31 AM
jtarjanyi jtarjanyi is offline
Brainiac
 
Join Date: May 2012
Posts: 95
jtarjanyi has 10 reputation points
Question 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
Reply With Quote
  #2  
Old 11-28-2016, 01:18 PM
mnorst mnorst is offline
Whiz
 
Join Date: Mar 2015
Posts: 42
mnorst has 11 reputation points
Default

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?
Reply With Quote
  #3  
Old 11-30-2016, 05:32 AM
jtarjanyi jtarjanyi is offline
Brainiac
 
Join Date: May 2012
Posts: 95
jtarjanyi has 10 reputation points
Default

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



Has someone any knowledge about this ?
Reply With Quote
  #4  
Old 04-24-2017, 04:31 PM
covar covar is offline
Hot Shot
 
Join Date: Sep 2015
Location: Mexico City
Posts: 21
covar has 10 reputation points
Default 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?
Reply With Quote
  #5  
Old 04-26-2017, 05:21 AM
jtarjanyi jtarjanyi is offline
Brainiac
 
Join Date: May 2012
Posts: 95
jtarjanyi has 10 reputation points
Default

Quote:
Originally Posted by covar View Post
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
Reply With Quote
  #6  
Old 04-27-2017, 01:50 AM
kruegerb kruegerb is offline
Genius
.
 
Join Date: Oct 2013
Location: Stuttgart-Germany
Posts: 276
kruegerb has 12 reputation points
Default

regarding using excel Macro for historical reports: see attached document
Attached Files
File Type: docx reporting_macros.docx (107.2 KB, 65 views)
Reply With Quote
  #7  
Old 04-27-2017, 03:05 AM
jtarjanyi jtarjanyi is offline
Brainiac
 
Join Date: May 2012
Posts: 95
jtarjanyi has 10 reputation points
Default

Quote:
Originally Posted by kruegerb View Post
regarding using excel Macro for historical reports: see attached document
Many thanks!
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 05:13 PM.

This Forum is provided solely for the use and convenience of Avaya customers and partners. Use of the Forum is subject to the Terms and Use and Privacy Statement found at www.avaya.com. No other use is permitted. The Forum including all content posted is “AS IS” and Avaya expressly disclaims all warranties and/or guarantees as to its accuracy, reliability, usefulness, quality or non-infringement of intellectual property. Avaya reserves the right to remove any content posted on the Forum at any time and for whatever reason.

Avaya will not be liable for any content posted on this Forum, including, without limitation, any errors or omissions or for any losses or damages of any kind incurred as a result of use or reliance on any content, regardless of its origin.

You expressly understand and agree that you assume all risks associated with use or reliance on this content.