I have a report in which i placed a tablix and it contains several rows. Among these rows I display only one row based on a data field value using the hidden property of the TextBox in the row. The problem is that the other rows still occupy space on the report even though they are hidden. How can I overcome this?

Try adding an expression to set the Height property

If I set the height property of the rows i want to hide to 0, I can't determine the height of the visible row because it is populated with dynamic data. Is there a simpler solution?

Per my knowledge this is not possible i.e., to avoiding blank space when the row is to be hidden dynamically. The reason being, the row height cannot be set during run time. Regards,Phani Note: Please mark the post as answered if it answers your question.

The rows I want to display dynamically contain different text with different formats in the same text box. Is there an alternative solution that allow me to populate the formatted text dynamically in the on row text box instead of several rows based on some data field value? Please note that the text is variably formatted; some words are bold and it contains different fonts with different sizes, also it is populated with placeholders that evaluate expressions of data fields.

I partially solved the problem by setting all the rows height property to 0 at design time (the designer automatically converts it to 0.03125in). The report at run time automatically expands the visible row height property just enough to display all the text in it. The problem remains in keeping a maintainable report at design time. Which means if I needed to modify the row content I have to expand it in the designer, modify it, then set its height to 0 again. I'm using SSRS 2008. I don't know if this also applies to SSRS 2005. Please let me know if you have a better solution.

Can anyone help?

Hi, In Reporting Services, we can set visibility of detail Row Group instead of set visibility directly to Row. And in this way, the hidden rows by expression will not occupy space. To achieve this in Reporting Services 2005, please follow the steps below: 1. Right click the handle of detail row which you need to hide it conditionally. Then select Edit Group… 2. Select Visibility tab in the Details Grouping window. 3. Select Expression and specify an expression based on a data field value. Click OK. In Reporting Services 2008, please follow the steps below: 1. Right click the details row group name in the Row Groups pane and select Group Properties… 2. Select Visibility in the left list in Group Properties window. 3. Select Show or hide based on an expression and specify the expression. Then click OK. Thanks, Tony ChainTony Chain

Thank you Tony, Your solution worked just as I wanted.