Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Dynamic headers in OAC classics report

Received Response
421
Views
13
Comments
2»

Answers

  • Rank 4 - Community Specialist

    Hi Indra,

    For some reason if you are unable to use repository variables. You can consider below solution as well.

    • Create a union report in OAC Classic
    • First union report you can setup the dynamic values what you are expecting for Headers.
    • Second union block can be actual data to be shown in the report
    • Disable Table heading, setup a sort column to get the header as first row of the table

    Examples as below






  • Rank 5 - Community Champion

    Gianni Ceresa ,

    Thanks for correcting me, I have changed now.

  • Rank 5 - Community Champion

    Thanks Bharath, but as explained due to mismatch of data type number and varchar for header we can't use union of reports and we used session/repository variable.

    Regards

    Indra Sardana

Welcome!

It looks like you're new here. Sign in or register to get started.