SSRS Constant group height

Question

In my report I have a group with an inner detail group.

Group
     details
more of the group

I need 3 groups on each page and I need each one to be lined up correctly. Each group member can have between 1 and 4 rows. When there are 4 rows for each one, they line up perfectly, however when there are less, everything shifts up.

Is there a way to define a static height for the group so that if there are less than 4 rows, it pads with whitespace so the bottom section of the group is in the same place?

Thanks

score 1 · Accepted Answer · answered Oct 10 '12 at 03:24

1

I think you need to create a blank row whenever your details are less than 4 rows. Try mo make an iif condition in your details row expression textbox.

answered Oct 10 '12 at 03:24

David Reyes

64
4

Thank you. This approach worked for me. I created a new dataset which got the count of rows associated with each id (group), then I used the Lookup function in the hidden property for the blank rows to determine how many should be hidden. Is there a way to use something like RowCount where not isNothing(Fields!text.value) so i do not need the additional dataset? – Aheinlein Oct 10 '12 at 14:44

score 0 · Answer 2 · answered Oct 10 '12 at 05:05

0

Try to insert the table within a rectangle. Keep the height of the rectangle to the height that you want(height of 4 rows). This way, if the table is having less rows, the height of the rectangle will still be maintained.

So, if u put each of the tables in a rectangle and define it as above, I think it should work. Always works for me when I already know the maximum row count.

answered Oct 10 '12 at 05:05

Joss01

101
6

Thank you for your response, but I have only one table which has an outside group and inside group. – Aheinlein Oct 10 '12 at 14:42

SSRS Constant group height

2 Answers2