Hi,
I have a report with 2 columns(Month & Sales revenue).In database month column has only 4 values(jan,feb,mar,apr).So report is displaying sales revenue for those 4 months.But i need to display other months also in report with zero sales revenue value.As month column contains only 4 month values,how to display other months in report level?
Thanks in advance,
Murali.
muralikotta (BOB member since 2007-05-09)
The data has to come from somewhere. 
The standard trick outlined in the Reporter FAQ suggests using a personal data provider (like Excel) to set up the full twelve months. You import the Excel data and link it to your current data provider and use the merged result in your report block.
Dave Rathbun 
(BOB member since 2002-06-06)
Do you have any table with month names.?
The simple option is that (but not the good one) you create a table with 12 rows. Then manually put month names in your month column and for other columns put the formula with where clause as - Where Month=‘JAN’ (your ‘Month’ is actual dimension for month)
sarang_kunte 
(BOB member since 2008-08-26)