Display all values on X-axis between the mentioned range even if there is no Data from source
I have 2 params (start_date & End_date)
My Birt report is extracting data from DB to plot the BAR & crosstab.
I want to plot all the values in the range(start_date-end_date) on x-axis, even if data is not present in DB for a particular date I need to show empty(0).
Problem : If data is not present in DB for a particular date , X-axis is omitting that date and printing remaining with values.(data not extracted from DB?)
How to achieve the solution.