Hi I have to group the data in my report on the basis of months in a particular year. Foreg. My groups should be like JANUARY 1999 , FEB 99, Mar 99 ------- DEC 99,--------- JAN 2009-----------DEC 2009. My Geroup is based on some Entry_dt column in the database. I'm grouping the report on the basis of entry_dt and in the group expert I have set it on a monthly basis so the group looks good in the report. But there is one problem now, according to the client he wants the groups on those months also for which the data is not present and so he wants it as a group but under that group no data should be displayed
For instance if the database contains data such as 03/15/2009, 04/16/09 and so on etc. and there is no data present for the month of January and February there should be a group like
January 2009
Entry_dt Name AMOUNT
February 2009
Entry_dt Name AMOUNT
March 2009
Entry_dt Name AMOUNT
03/15/2009 Thomaes Scott $ 500
And so on
Now my report displays only the groups for which the dates are present in the ENTRY_DT column.
For Example
March 2009
Entry_dt Name AMOUNT
03/15/2009 Thomaes Scott $ 500
And January and February do not show up.
Please help me on this and Also the client wants the first group to start from the January corresponding to the Year(date) which is the earliest in the database. till the date which is the latest.
Edited by vipulbhatia29 - 15 Jun 2009 at 1:52am