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!

Same problem; I guess it never got fixed

I didn't say she was mentally unstable, your honor...

I would suggest you use a stored procedure when your querry becomes more complex. Cause it's much faster.

You can use temp tables to split your data and give data to an empty field like "Empty" using a CASE in your select.
Then you can count those fields or use them in a graph.

Your second problem can be resolved with an IIF-statement
=Count(IIF(stuff = 10, 1, 0)