Hi everybody,i have created a report for printing a quote from our crm system.This Report has 2 Parts:a main report with header data from the quote (customer adress, quotenumber, ...) all listed in a table.and a subreport for the quotedetail (products, productnumber, lineitemnumber, price per unit, ..)I inserted the subreport into a table cell from the parent report.When i print the report, i have a pagebreak before the subreport.This pagebreak should only be at the end of the page not at the beginning of the subreport.It looks like there is a hidden setting like "keep together".I use Visual Studio 2005 and SQL Reporting Services 2005 SP3Is it possible to avoid a general pagebreak before a subreport?Regards,Thomas

Hi,Yes, KeepTogether attribution is by default added to the subreport. So could you try to split the subreport to multi pages, so it can fit the report length?Thanks.Yao Jie Tang -Microsoft Online Community

Hi,Thanks for the quick answer. I inserted a pagebreak in the subreport after 1 line.So, the result of the first page must fit on the first page of the report.I use a table in the subreport to display the quotedetails in the subreport.I inserted a group in this table with the following expression to force a page preak:=CInt(Ceiling(RowNumber(Nothing)/1))The table does a a page break after every position.But there is still a pagebreak before the subreport starts.Regards,Thomas

Hi Thomas,I can't reproduce the problem you met, could you send the RDL and data structure to sqltnsp@microsoft.com and paste the threadlink in the mail.I will try to resolve it or find the root cause.Thanks.Yao Jie Tang -Microsoft Online Community

Hi Yao Jie Tang, i sended the Report Data in an email on 23.03.2010.Where you able to check the problem? Regards,Thomas

Hi, Looks like I missed this mail. Could you please send it again? Thanks.Yao Jie Tang -Microsoft Online Community

Hi, I just sent the mail again. Regards,Thomas

Hi Yao Jie Tang, was it possible to reproduce my problem? Do you have any suggestions? Regards, Thomas

The solution is to change the Subreport property in Code. 1. Go to the solution explorer, right click on your report and click on "View Code". 2. Search for your Subreport. 3. Inside subreport tag you'll find "<KeepTogather>", which would be set to "true", change it to "false" This property is not avaiable from designer and has to be changed from the actual report xml code.