Groups | Blog | Home
all groups > sql server reporting services > november 2004 >

sql server reporting services : Matrix filter - rendering error - BUG?



Kristian Vinther
11/26/2004 3:49:09 AM
I have a matrix-rowgroup with a filter. The filter is a simple
"DataSet.SomeValue = True" and it works just fine most of the time.

However, depending on my query-data there will be situations where filter
will filter out all data, thus leaving zero rows. This 'should' result in an
empty matrix.

But instead i get an error when viewing my report.
RenderingException: "Operation is not valid due to the current state of the
object."

Is this intentional?
Charles Kangai
11/26/2004 4:59:02 AM
You probably have an expression somewhere that tries to access an item from
the matrix. As the matrix item is not there, you are getting the error. You
should recode your expression with an IIF(Fields!MatrixElement is
nothing,...,....).

I also have a matrix which I am filtering. Sometimes I get no data. When I
have no rows returned, there is just a blank report, no errors like you are
getting. Of course I could use the NoRows property to display an alternative
text when no rows are returned.

HTH

Charles Kangai, MCT, MCDBA

[quoted text, click to view]
AddThis Social Bookmark Button