Hi,

I'm working with Visual Studio 2003 and Reporting Services 2000.

I'm having a problem with some "missing fields" in the chart I have created. To be specific, my Y-axis is a time span of several weeks, and sometimes random weeks go missing. I have several parameters as well, and I suspect that the problem is that the data is being filtered before the data field can be COUNTed.

The result: where the COUNT is zero for some certain week, that week will disappear, leaving a gap in my span of time on the Y-axis.


I have two possible solutions, but I do not know how to go about them:

1) I need to be able to manually change the "And/Or" column in the filters tab of my Grouping and Sorting Properties.

2) I need a way to set the values seen on the graph. For example, in my data fields, I have the expression: COUNT(Fields!status.Value). Is there any way so that I can specify that I only want to see the data when status is 10 (e.g. COUNT(Fields!status.Value=10), but I don't know the correct syntax)?


Does anyone know how to do either of these, or perhaps suggest another solution? In any case, I need to know how to do #2 anyway, for another problem I have.


Any help would be greatly appreciated! Thanks!