4 Replies Latest reply on Nov 26, 2012 9:16 AM by evrm

    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