This discussion is archived
4 Replies Latest reply: Nov 26, 2012 1:16 AM by evrm RSS

Chart Link to report

Vedant Explorer
Currently Being Moderated
Hi,

I have created a funnel chart and a report. when i click on any value of funnel chart, Then corresponding Detail should display in report, Report will display based on the name column of the funnel chart Code. How i pass link to the funnel chart code so that i can jump to report,When click on any value of funnel chart ,value display in report .
select NVL(name,'N/A'), value, link from (
select (select NVL(status_code,'NA')
from CRM_SALES_DEAL_STATUS_CODES where id=DEAL_STATUS_CODE_ID)  
name,
        COUNT(ID) value,
       Null link from CRM_SALE_DEALS_V  group by DEAL_STATUS_CODE_ID)
.

I have created a item on page report, when click on funnel chart value, value moved to item , based on this item my report displays.



Thanks & Regards
Vedant

Edited by: Vedant on Nov 25, 2012 11:19 PM
  • 1. Re: Chart Link to report
    714270 Pro
    Currently Being Moderated
    Hi,

    You can use the "Action Link" region of your chart series to specify the link target.


    Thanks,
  • 2. Re: Chart Link to report
    Vedant Explorer
    Currently Being Moderated
    Hi,

    There is no action link in funnel chart.








    Thanks & Regards
    Vedant
  • 3. Re: Chart Link to report
    Mindmap Pro
    Currently Being Moderated
    Hello,
    In your query you used
    Null link
    Please check the example of the query of the chart to know how to do it.... Or if you wish to get quick response please reproduce the issue on apex.oracle.com..

    Best Regards,
    Fateh
  • 4. Re: Chart Link to report
    evrm Pro
    Currently Being Moderated
    Hi Vedant,

    in your query the link column contains null.
    Try putting the link to the f procedure like this:
    select NVL(name,'N/A'), value, nvl2(name, 'f?p=' || :app_id || ':<PAGE_ID>:' || :app_session || '::::<P_ITEM_NAME>:' || name, null)  link from (
    select (select NVL(status_code,'NA')
    from CRM_SALES_DEAL_STATUS_CODES where id=DEAL_STATUS_CODE_ID)  
    name,
            COUNT(ID) value,
           Null link from CRM_SALE_DEALS_V  group by DEAL_STATUS_CODE_ID)
    regards,
    Erik-jan

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points