Pivot Table in RTF - BI Report — Oracle Analytics

Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

Pivot Table in RTF - BI Report

Received Response
41
Views
3
Comments
Adnan.Salim
Adnan.Salim Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Hello

I have pivot table report and that works fine. I have to add a url (in another xml tag) to be hyperlink of the across field of the pivot. I tried following but it doesn't work. Perhaps the standard tags/code generated by pivot wizard uses different references. How can I achieve this?

Code: <fo:basic-link color="blue" external-destination="{URL}">

This code work fine if I create pivot with manual code (without wizard) but I am not able to get horizontal sub-total (for each group) and the big number also gets displayed in incorrect format i.e. 1.9412187780000005E7


Thank you.

Answers

  • SantoshKumarBhairi
    SantoshKumarBhairi Rank 6 - Analytics Lead

    try this and search in Forums, I have suggested it earlier.

    <?if@inlines: <column>!='N/A'?>

    <fo:basic-link external-destination="{.//<column>}" color="blue" text-decoration="underline">

    <column description>

    </fo:basic-link>

    <?end if?>

  • Adnan.Salim
    Adnan.Salim Rank 1 - Community Starter
    edited Sep 12, 2023 4:26PM

    Thanks @SantoshKumarBhairi !

    Getting error, can you please help me to fix this?

    <?if@inlines: ./M1>!='N/A'?>

    <fo:basic-link external-destination="{.//URL}" color="blue" text-decoration="underline">

    <?./M1?>

    </fo:basic-link>

    <?end if?>

  • Adnan.Salim
    Adnan.Salim Rank 1 - Community Starter

    Dear @SantoshKumarBhairi

    I am still unable to achieve. Could you please help?

    <?if@inlines: ./M1 >0?>

    <fo:basic-link external-destination="{.//URL}" color="blue" text-decoration="underline">

    <?./M1?>

    </fo:basic-link>

    <?end if?>


    I have a numeric field and want to substitute url in the sql as a link on that numeric field.

    Thank you.