Hi folks!!! Hope all of you doing great :) I have one query on SSRS Report and will feel happy if you guys help me out. Scenario : I have to create a reports that contains one subreport as well. Problem : I have Created one main report and included one Sub report on it, my main report display thousand of records which can splills into many number of pages, my issue is when i scroll my main report and as it will scroll to another page, my subreport is not visible, but i want my subreport to be visible all the time. Is there is ant way by virtue of which i am able to make my subreport visible all the time while scrolling my main report into other page.Amit Please mark as answer if helpful http://fascinatingsql.wordpress.com/

Hi there Just would like to know where did you put your sub report? is it in details section of the report. and would your sub report be executing for every record of the main report. Please update than i might be able to help you out Many thanks Syed Qazafi Anjum

HI Syed, Yes it is detail section of reports, snapshot as below, here SubReport1 is what i want in every page, while SubReport2 will spills into multiple pages. 2. No, Subreport1 is a pe chart, which shows some cummalative record Amit Please mark as answer if helpful http://fascinatingsql.wordpress.com/

Hi Amit , From your description, I am a little confused about where you view the main report. In Reporting Services, subreport control has an implicit KeepTogether property which tries to keep content of a subreport on one page. If you view the main report in Business Intelligence Development Studio (BIDS) or on the Report Manager, how could you break subreport2 into multiple pages? If you export the report to hard page break format such as PDF, I am afraid we cannot repeat the subreport1 on each new page because the related properties such as "FixedData" and "RepeatOnNewPage" are not applied to PDF format. If you view the report in BIDS, there is a work around for your reference: Drag a table control to the main report and design the table the same as subreport2.Right-click on the handle of the first column and add a column (Outside-Group) in the left, and then place the Pie Chart subreport in the details row of the newly added column. The main report design structure may be like: If I have something misunderstood, please feel free to correct me and elaborate the issue for further analysis. Regards, Mike Yin