Show only one row first and then open up the rest of the table 1

[manjulam]

I have a report where I need to show only the top row first and on click of some hyperlink, I want to open up rest of the rows. I was thinking of having two tables, one filtered to show only the first row and then the next with all the rows and then conditionally displaying them. Is there any other way?

 

[RiverGuy]

You can do this with one table if I understand your question correctly. Group on a field which makes sense to you. In the Group Header, you can use the FIRST function for your cell's values. For example:

=FIRST(Fields!SomeFieldName.Value)

In the details, select the entire row for the details, and change the visibility to hidden. Set the visibility to be toggled by a textbox in your Group Header.

 

[manjulam]

Thanks,that worked.

 

[manjulam]

ok, if i want to hide the said text box in the group header if there is only one row, what can be done? I tried giving conditional visibility to the textbox based on the row count but then if the row count is 1 and the text box is not displayed, the group header is also not displayed since it toggles based on the text box. any ideas?

 

[RiverGuy]

I'm not really sure on this one. One thing you could try, if nothing else works, would be to modify your source query to return the row count for each group as a column in the resultset. The downside to this is that it adds more overhead to your query. If you have this rowcount, you can set the visibility to an expression.

 

[manjulam]

is there anyway to check the visibility of a table row? Then I can set the visibility of the group header to false if the details row is visible.