Hello All, I have a table in my report.Some times it extend to next page according to data ,and some times it comes on single page when data is less. I have second table working as footer of first table. I have to show second table's header in second page when first table doesn't extend to next page. Is there any way that,we can set visisbility of second table's header when first table extent to next page. Is there any way to know wheather first table is getting extent to next page?

Hello all, please give me some idea,or logic for this...

Hi Nitin, In your case, I think that we can try to add a page break at the end of the table1. So, it will generate a new page for table2. For more information about add a page break, please see: http://technet.microsoft.com/en-us/library/ms156434(v=SQL.100).aspx If you have any more questions, please feel free to let me know. Regards, Bin LongBin Long TechNet Community Support

Hi Nitin, In your case, I think that we can try to add a page break at the end of the table1. So, it will generate a new page for table2. For more information about add a page break, please see: http://technet.microsoft.com/en-us/library/ms156434(v=SQL.100).aspx If you have any more questions, please feel free to let me know. Regards, Bin LongBin Long TechNet Community Support