Hi, I am creating a line chart using ReportBuilder, in which the X axis is a date and the Y axis is the count of all the records I have for which a particular field falls on that date: You will notice that 4-Mar-12 is missing in the X axis because I have no records in my data set whose date is 4-Mar-12. So I have modified the X axis interval because I want it to show every day, and it now looks like this: Now, the requirement is that the line should *not* be extrapolated from 3-Mar to 5-Mar, it should actually go to zero on 4-Mar. I have changed the Y function to be defined as follows: IIF(IsNothing(Count(Fields!ava_datetypename.Value)), 0, Count(Fields!ava_datetypename.Value)) However, it does not seem to have any effect! Any ideas how can I make that happen? It looks pretty simple to me, but not easy!! Thanks Gonzalo | gonzaloruizcrm.blogspot.com

This is what the chart is supposed to look like: Thanks Gonzalo | gonzaloruizcrm.blogspot.com

Hi There Please try to play with emptypoint property of your chart series and put emptypointvalue=zero by default it is average. But I Think you need to bring those dates which are null as a apart of your dataset results then you will be able to plot these value in the chart I am putting screenshot for your help If you have any question please let me know. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful for more help please seehttp://technet.microsoft.com/en-us/library/dd207051.aspx http://technet.microsoft.com/en-us/library/dd239390.aspx

Hi there If you please read my response above I think you need to bring those dates which are null as a apart of your dataset results then you will be able to plot these value in the chart. I am assuming that you are just making those values logically inside the SSRS by using interval type day and interval =1. Am I right? As far as I think this will not work in this scenario as reporting services engine does not know these dates as they are not the part of your dataset. The perfect example of this scenario is if you have two series one has data for odd dates and other has data for even dates So for Series-1 data is present for months 21,23,25,27,29 and for Series-2 data is present for months 22,24,26,28.but you are bringing data for both dates from your dataset. In scenario if you use this property then it will plot zero values where the values are missing in both series. What I can suggest you please bring those missing dates as a part of your dataset then you will be able to work around it easily. If you have any question please let me know. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Hi Syed, Thanks for your answer. I played with the EmptyPoint properties and I also tried setting the EmptuyPointValue to zero but it didn't have any effect on the chart. I still see it extrapolating the line over March 4th :( Any other ideas? Thank youGonzalo | gonzaloruizcrm.blogspot.com

Hi there If you please read my response above I think you need to bring those dates which are null as a apart of your dataset results then you will be able to plot these value in the chart. I am assuming that you are just making those values logically inside the SSRS by using interval type day and interval =1. Am I right? As far as I think this will not work in this scenario as reporting services engine does not know these dates as they are not the part of your dataset. The perfect example of this scenario is if you have two series one has data for odd dates and other has data for even dates So for Series-1 data is present for months 21,23,25,27,29 and for Series-2 data is present for months 22,24,26,28.but you are bringing data for both dates from your dataset. In scenario if you use this property then it will plot zero values where the values are missing in both series. What I can suggest you please bring those missing dates as a part of your dataset then you will be able to work around it easily. If you have any question please let me know. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Thanks let me try thatGonzalo | gonzaloruizcrm.blogspot.com

Thanks Syed, that actually helped a lot. For those interested in the solution I have posted a blog article with all the steps: http://gonzaloruizcrm.blogspot.ca/2012/05/how-to-force-zero-data-points-in-date.htmlGonzalo | gonzaloruizcrm.blogspot.com

Hi There I am really glad that your problem has been resolved. Every day we learn a lot from each other that what we called sharing thoughts. Good luck for your project Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful