What is the way to keep multiple detail rows together on one page. There seems to be no future to keep multiple detail rows together. I'm not talking about table keep together, group page break or anything like that. I have 3 rows that need to be in one page at all times. Is there anyway that this is possible? Enkh

Whats so special about these 3 rows that they get broken up onto separate pages?

Well this is just a serious layout and requirement concern nothing more. It is nice to have every detail item (3 rows each) on one page instead of spreading into two pages. In this case it is hard to read and keep track of what item you are looking at the page, and so that you have to flip to the previous page to read first part of the information (detail item). This is just a layout concern and is definitely not a very minor concern though. It's a layout issue and in other report designers there are "keep together" property in the detail level of the reports so that detail item is kept together along with table keep together and group keep together. Table keep together is not what I'm talking about. I think there should be detail level keep together for each item to be on one page if it's cutting the item into two on the bottom of the page and top of the next page on a detail item level basis.

Enkht: I am currently running into the exact same problems. The reason this is such a big problem is because on the second page, you will see details and not know what item they correspond to. This seems to be a serious flaw in RS. My solution for this issue has been to put all three detail rows that I group together into textboxes. Place these text boxes into a rectangle, since rectangles are not divided at the end of a page. This seems to be working for me. Now, instead of breaking the rows up, the entire rectangle is pushed to the next page. Hope this helps.

I don't really follow you on that. How do you put a "detail" rows into textboxes? Do you mean actually copy the detail fields into textboxes each? I'm not really sure what you mean by putting the detail rows into textboxes? Copy the values? Thanks for making it clearer. Enkh

OK let me see if I can clarify.. maybe I misunderstood your problem. Let's suppose you have a result set that you are grouping by name, and under each record's name you want a detail row for address, SSN, phone number. Each of these details are in separate rows underneath the group. So, sometimes you will see a person's Name and address on the bottom of page 1, and then page 2 will have a SSN and phone number without a name. With my suggestion, you would create a larger row. Insert a rectangle within the new, large row. Within that rectangle, you would have 4 textboxes, stacked on top of each other (so that when the report is rendered, they appear as if they were in rows). The value of each textbox would be the value of your prior row (=Fields!Name.Value, etc.). Since a rectangle is treated as a single entity, it will not be separated when the report is rendered. All textboxes within the rectangle will remain together. If this is still unclear, I can take some screen shots and email you to show you what I am talking about. I hope this helps.

I'm having this exact problem, before changing the reports around (which will take me about a week, considering the complexity of the design), is there another solution for this issue? Has MS done anything about it? Thanks for your help.

This is a bit of a stab in the dark as I haven't looked at this in a while.This issue appears to occur when looking at the report through IE. Try setting the InteractiveHeight property of the report to 0.Adam Tappis. (MCSD VB6 & .NET, MCDBA SQL 2000)

This is a very late response which I hope some will find helpful. I'm working with SSRS 2008 and viewing the output using Visual Studio 2008's preview. This may vary with other rendering engines. I found that the multiple "(Static)" rows within my details group "(Details1)" would be split without regard to settings of the KeepTogether and KeepWithGroup properties. I noticed that my group headers were always together, even if they had multiple rows. So why not put the details into group headers? I changed my layout from this: Group 1 - Header Row 1 Detail Row 1 Detail Row 2 To this: Group 1 - Header Row 1 Group 2 - Header Row 1 (content from Detail Row 1) Group 2 - Header Row 2 (content from Detail Row 2) Detail Row 1 - hidden Detail Row 2 - hidden Detail Row 3 - blank - not hidden - minimum height And it worked! My "details" are always together, but sadly the pairs of details are separated by the blank Detail Row 3. Be sure to enable Advanced Mode (dropdown by "Column Groups" below Design surface) and set KeepTogether on Group 2 its and children, and KeepWithGroup on the children as well. It's not clear if this is by design or by accident, but really seems to hurts the usability of the product. Please vote for this bug on Connect: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=428595

You add a parent group for the Details group where the details rows are initially in. You might want to delete the column added automatically, when you do this, without deleting the group. Then edit the rdlc file and add the line i marked. My tablix row hierarchy section: <TablixRowHierarchy> <TablixMembers> <TablixMember /> <TablixMember> <Group Name="Group1"> <!--parent group--> <GroupExpressions> <GroupExpression>=Fields!ppm_ident.Value</GroupExpression> </GroupExpressions> </Group> <TablixMembers> <TablixMember> <Group Name="Details" /> <TablixMembers> <TablixMember /> <TablixMember /> </TablixMembers> <KeepTogether>true</KeepTogether> <!-- i added this line and it worked, it keeps the details group together --> </TablixMember> </TablixMembers> </TablixMember> </TablixMembers> </TablixRowHierarchy>

Pawel could you try to explain your solution on another example or give us a step by step description, as i am not able to get it to work. This is my last and only hope to get my reporting project done, othewise i have to find a new solution or go back to CR.