How-to Create monthly CDR report on BTEL

This article describes how-to create a (new) monthly comprehensive report that will be send out to you via email every 1st of the month at 00:01.

Screenshots are provided at the end of this article for additional guidance.

if you want to create an ad-hoc reports, you can refer to the separate KB Article "How-to run an ad-hoc CDR report on BTEL" for the specific steps.

1. Access to the BTEL Portal:

2. Login to the Portal:

3. Create a (new) Report

  1. At the side menu goto Configuration -> Reports
  2. Click "New Report"

At INFORMATION

  1. Name: Key in a name of the report e.g. "Orencloud Monthly Report"
  2. Active: Select YES
  3. Holding days: 10
  4. Type: Select: Call Details Record
  5. Timeframe: Select: Last Month
  6. Fields: Select the following
    • Start
    • End
    • Answer
    • Extension
    • Number Calling
    • Number dialled
    • Duration
    • Direction
    • Bill Time
    • Disposition
    • Cost
    • Country
    • Network
  7. Group by: Select By Extension
  8. Direction: Select: Any call, including internal calls
  9. Extension: Leave empty
  10. Report call with cost: Select: Report any call
  11. Disposition: Select: Answered (preferred option) or Any

At PAGE

  1. Size: Select: A4
  2. Orientation: Select: Landscape
  3. Font size: Key in 6
  4. Row height: Key in 6
  5. Top date/time format: Leave as Default
  6. Details date/time format: Leave as Default
  7. Theme: ORENCloud

AT SCHEDULE

  1. Year: Select: Every Year
  2. Month: Select Every Month
  3. Weekday: Select Any Weekday
  4. Day: Select: 1
  5. Hour: Select 00
  6. Minute: Select 01
  7. Timezone: Leave as Use Server default - Asia/Kuala_Lumpur

At DELIVERY

  1. Email template: Reports
  2. Email: <your email address>
  3. Note: to send to more than one use the , (comma) as separator, e.g. <email1>,<email2>,etc

Done, Click SAVE



Article ID: 231
Last updated: 07 Nov, 2024
Revision: 6
BTEL General -> How-to Create monthly CDR report on BTEL
https://kb.astiostech.com//how-to-create-monthly-cdr-report-on-btel_231.html