4 Replies Latest reply: Nov 26, 2012 3:16 AM by evrm RSS

    Chart Link to report

    Vedant
      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
          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
            Hi,

            There is no action link in funnel chart.








            Thanks & Regards
            Vedant
            • 3. Re: Chart Link to report
              Mindmap
              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
                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