1 Reply Latest reply: Jan 11, 2013 8:15 AM by Rod West RSS

    Cross Tab In Discoverer

    799706
      Hi Guys,

      I need to build a discoverer report that should display the data for every month. I had written one query where Transaction_Date in Mon-YYYY form is made a data point in discoverer which means my sheet will segregate the data in cross for each months like Jan-2012, Feb-2012.... etcetera .

      Now I run my report for Transaction Start Date '1-Jan-2012' to '31-Dec-2012' but my query returns the data only for three months Jan-2012, Mar-2012 and Apr-2012 therefore discoverer sheet shows me three tabs for Jan-2012, Mar-2012 and Apr-2012 [that is logically correct because data is available for these three months only]. But my requirement is, even if data is not there for the months which fall between date range, report should display those month as a tab in sheet with 0 values. like for this example disco sheet should look like..


      S.No......Sum(Amount)........Jan-2012.....Feb-2012.....Mar-2012.......Apr-2012....May-2012....Jun-2012....Jul-2012....Aug-2012....Sep-2012....Oct-2012....Nov-2012....Dec-2012
      1................800..................100.............0............500..................200...............0...............0..............0...........0...........0..............0..............0...............0

      I hope I make you understand what my requirement is. Does any of you have nay idea how to achieve this?

      Looking forward to your reply.

      -Sunil

      Edited by: Sunil on Jan 10, 2013 12:36 AM
        • 1. Re: Cross Tab In Discoverer
          Rod West
          Hi,

          You will need to set up your EUL so that there is a folder which returns all the months, that outer join your report folder to this calendar folder. This blog (http://learndiscoverer.blogspot.com/2008/10/row-generators.html) about row generators which you will need to create you calendar folder may be useful.

          Rod West