Hi there,
I have a report where i need to show date records even if they are not coming from the database. Lets say i have record like below;
Date Balance
1/1/2013 123.45
1/2/2013 456.78
1/3/2013 789.01
1/5/2013 234.56
Since there is no record coming for 1/4/2013 the report is showing nothing. But i need to show 1/4/2013 with Balance = 0 between 1/3/2013 and 1/5/2013. And this is monthly record so the date will always start from the begining of the month and end at the end of the month.
Any help will be greatly appriciated.
I have a report where i need to show date records even if they are not coming from the database. Lets say i have record like below;
Date Balance
1/1/2013 123.45
1/2/2013 456.78
1/3/2013 789.01
1/5/2013 234.56
Since there is no record coming for 1/4/2013 the report is showing nothing. But i need to show 1/4/2013 with Balance = 0 between 1/3/2013 and 1/5/2013. And this is monthly record so the date will always start from the begining of the month and end at the end of the month.
Any help will be greatly appriciated.