I am creating a mutlicolumn report with the grouping. It has 2 columns in it. I am trying to put each group in new page using page break. But the report put the new group in the next column rather than the next page. page break is acting like a column break. I also tried to put two page breaks but the number of rows in each group is unknown so if number of rows in the group is ending in 1st column then it works fine and put the next group in next page but if the data in the group is ending in 2nd column then the next group data starts from second column of next page. Ideally it should start from the 1st column. Anyone has solution for this problem? Thanks in advance

Hi, Could you elaborate your steps on " I am trying to put each group in new page using page break. But the report put the new group in the next column rather than the next page"? So that we can repro the issue you encountered. If possible, send your report and example data to us through email sqltnsp AT microsoft DOT com for further research. See http://msdn.microsoft.com/en-us/library/ms156434(SQL.100).aspx for more details about reporting services page break. thanks, Jerry

Hi Jerry, Thanks for the response. In the multicolumn report data flows from one column to the next column on the same page. I have done grouping on the data. What i want is when one group data ends, the next group data shall start from the next page. But what's happening that next group data is starting from the next coulmn on the same page rather than the next page. So page break is acting like a column break in multicolumn report. Any solution to implement this.

Hi Jerry, Thanks for the response. In the multicolumn report data flows from one column to the next column on the same page. I have done grouping on the data. What i want is when one group data ends, the next group data shall start from the next page. But what's happening that next group data is starting from the next coulmn on the same page rather than the next page. So page break is acting like a column break in multicolumn report. Any solution to implement this.