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..
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.