Tablix on one page

Question

Hi all.,

I have 3 tables of same dataset , i want to keep all the 3 tables in one page ,as i have 20 tables each one breaks and shown in next page . how to keep that 3reports  in same page .,  pl let me know

Thanks:)

Answer 1

I think you need to wrap those tablixes into a list control and specify a breaking point.

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
MS SQL Consultants: Improves MS SQL Database Performance

Answer 2

am using it in subreports , subreport is in alreday list , Does it will work after exporting to word ?

Answer 3

I have no idea, rendering makes things to be complicated :-(

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
MS SQL Consultants: Improves MS SQL Database Performance

Answer 4

Anyother suggestions pl

Answer 5

Hi,

Please follow below steps to achieve this.

 

Please feel free to revert back if any issues still, thank you

 

Cheers,

Arun Gangumalla

Please mark as helpful or answered if it resolves your issue to help others in finding solutions easily.

Answer 6

My report is not like horizontally , mine is vertically placed

like   Table1 ,

        Table2 ,

        Table3.

Answer 7

Hi,

In that case you can include a single table with 3 header rows, and try placing these 3 tables in case header row and then add a page break for the main table. like wise design rest of the report.  please follow the below steps in achieving this..

 

Please feel free to revert back if any issues still, thank you

Cheers,

Arun Gangumalla

Please mark as helpful or answered if it resolves your issue to help others in finding solutions easily.

Answer 8

this also doesnt work , pltell other suggestion

Answer 9

Hi,

Can i know the issue please? like not working in the sense it is not fitting in one page.. or the design of these 3 tables under table moving to next page.. how is it so ?

please post your existing table designs which you want to be in a single control under one page ....thank you

cheers,

Arun Gangumalla