I've been battling this issue on and off for a couple days and it seems that I'm not getting anywhere, so I'm asking for help.
I have a main report with only one group level based on column 1, sum(column2)
I have added a row inside the group - below and in this row I added a subreport that has a parameter linked to the column 1.
The problem that I'm facing is that I want to keep the group row and the row which the subreport is contained together in one page. However, when I display the report on a pdf file some of the group rows (column 1, sum(column2) ) display at the bottom of the page and then the row containing the report on the next page. I want the group row to fall to the next page if the report row data does not fit on the same page.
Any ideas, I've read that grouping in SSRS 2008 R2 has problems. I could add a page break after the row of the report but that would add too many pages since some of my group reports have only a few rows.
Also, the query for the intial column 1, sum(column2) is a very complicated query and the sum(column2) would not work as intended if I were to add the subreport query in the main report's query.