Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2011-09-20 : 06:48:53
|
| There is a matrix in the report which retrieves data from storedproc...The matrix has rows and columns.I have placed row headers for each row.Depending on the parameter passed to the report, one of the rows may not have any data in it. So that row shows the row heading and empty data.I have placed an expression for that row header so that it becomes visible/invisible depending on the parameter passed.If there is no data in the row, instead of just showing the blank row, I want to delete that row from the report so that the matrix does not have an empty row. Basically something like shifting the rows up.How is this done please? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-20 : 07:14:14
|
| why not put a filter on row based on data availability conditions?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-09-20 : 07:26:41
|
| Not sure what you mean.Please elaborate.The stored proc does take care of the filtering so if data is not present then that row does not get shows in the dataset.But my matrix has header rows which I have added to the matrix.Even if data is not present, the matrix row still shows as empty row.Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-20 : 07:37:10
|
| isnt header not part of your data row grouping?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-09-20 : 08:22:19
|
| Solved by using the row visibility.Thanks |
|
|
|
|
|
|
matrix - delete empty row