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.
TIA
Comments
-
Mounica,
Hi! I don't know if you found a solution or not, but I think I may have the answer. I too had the same problem, and received the attached design from Clement Wong of OpenText. It will print out dates along the chart axis, even if the other axis value is '0'. Hope this helps.Have a great day!
Scott
0
Categories
- All Categories
- 108 Developer Announcements
- 53 Articles
- 106 General Questions
- 145 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 899 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 120 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management