none
Page Break based on condition working but getting blank page in report

    Question

  • Hi All,

    i am using below expression to disable page break based on the Condition, it's working fine wht i need Acually.

    but If data is more or lot of rows is coming in report on page , getting blank page after every table in report.

    i have 7 table in report.

    break location :-- Start

    Disabled :- (ReportItems!Textbox471.Value="No Records Found." and ReportItems!Textbox473.Value="No Records Found.",True,False)

    please let me know how to aviod blank page in report.

    Regards,

    Akhil

    Thursday, July 18, 2013 12:36 PM

All replies

  • Hi Akhil,

    If the tables use the same dataset, you can embed them in a single table; otherwise, you can place the tables that use the same dataset in a single table, and use subreports to display the tables that use different datasets. The subreports are also placed in the table that hosts the other tables. 

    Regards,


    Mike Yin
    TechNet Community Support

    Thursday, July 25, 2013 3:08 AM
  • Hi
    Try these

    1. On report properties Set ConsumeContainerWhitespace = True

    2. On all tables/Tablix Set Keep together on one page if possible


    Prav


    • Edited by Prav_SQL Thursday, July 25, 2013 3:36 AM added additional info
    Thursday, July 25, 2013 3:35 AM
  • Hi Mike,

    All 7 table have same dataset , filter only different on tablix property to show the data.

    Regards,

    Akhil

    Thursday, July 25, 2013 6:25 AM
  • Hi Prav,

    This two points i already Did. if anything plz let me know.

    Regards,

    Akhil

    Thursday, July 25, 2013 6:34 AM