Chart

Target Report

Example

order-chart.ozr

  1. Create a new ReportTemplate and save it as order-chart.ozr.

  2. Insert ODI(D) -> order.odi

  3. Add a Data band

  4. Add Chart to the Data band

Horizontal bar

  1. Chart Type > Horizontal bar

  2. Data

    1. X-Axis > Country

    2. Y-Axis Left > TotalDue (sum)

    3. Apply

  3. Title

    1. Chart Title "Total Due By Country (Bar Chart)"

  4. X-Axis

    1. Show Major Gridline > uncheck

    2. Show Label > Format > Paragraph > Alignment > Horizontal > Right justified

    3. Apply

  5. Y-Axis

    1. Show Major Gridline > Line Style > Use dashed line > Length 1, Gap 2

    2. Show label(Left) > Format > UNIT > Type 12.3K

    3. Apply

  6. Data Label

    1. Data Label > Show > Format > Currency

    2. Apply

  7. Misc

    1. Bar Thick > 0.5

    2. Apply

  8. Display

    1. BackGround > Fill > select color

    2. Apply

  9. OK

Pie chart

  1. Chart Type > Pie

  2. Data

    1. X-Axis > Country

    2. Y-Axis Left > TotalDue (sum)

    3. Apply

  3. Title

    1. Chart Title "Total Due By Country (Pie Chart)"

  4. Data Label

    1. Data Label > Show > Format > Currency

    2. Data to Show > Item name, Value

    3. Apply

  5. Pie

    1. Axis Thickness > 60

    2. Data label Position > Side Pos

  6. Legend

    1. Uncheck Show

    2. Apply

  7. OK

Last updated

Was this helpful?