Hi all,
I have a matrix on a report that is a subreport on another report. The matrix has one column and one static row. I am using a stored procedure to return a result set based on ID numbers. I am trying to return the top 3 counts of ID number. I run into an error when the top 3 counts are:
ID 1 6 32 11
# 15 8 3 3
This will return 4 columns instead of the just 3 which screws up my final report because the supreport is too large. Does anyone know of a way to limit the number of columns that a matrix returns?
I am using the same sp to return data for a another table so I would like to make the change in Reporting Services instead of creating a seperate top 3 sp.
Thanks in advance.
Jeremy
I have a matrix on a report that is a subreport on another report. The matrix has one column and one static row. I am using a stored procedure to return a result set based on ID numbers. I am trying to return the top 3 counts of ID number. I run into an error when the top 3 counts are:
ID 1 6 32 11
# 15 8 3 3
This will return 4 columns instead of the just 3 which screws up my final report because the supreport is too large. Does anyone know of a way to limit the number of columns that a matrix returns?
I am using the same sp to return data for a another table so I would like to make the change in Reporting Services instead of creating a seperate top 3 sp.
Thanks in advance.
Jeremy