BusinessObjects Board

Needs Help in SAP BO Report

Friends,

i would like to build a report in SAP BO, please see the attached screenshop.

Table 1: Represents current report/ Data which i have it now

Table 2: I would like to build the report/ convert the data format into that format.

I will appreciate if anyone can help/advise.

thank you for the consideration.[/img]
IMAGE.jpg


jithutakemail (BOB member since 2016-07-10)

To create a report like table 2, You can follow the below mentioned steps.

  1. Insert a cross tab

  2. You can then Assign the Values
    In Rows you need to add the below mentioned Objects
    a. CLINICIAN_ID
    b. SPECIALITY
    c. PATIENT_AMOUNT
    d. INSURANCE_AMOUNT
    e. NET_AMOUNT

  3. In Coulmns you need to add INTERNAL_TYPE Object

  4. In Body you need to add the NET_AMOUNT Object

You would be abe to build a report as mentioned in Table 2 by following the above steps


Mohit_kurseja (BOB member since 2016-08-28)