Tablix data not shown in new page

Tablix data not shown in new page

Posted by: ashna.asif on 29 September 2019, 9:23 pm EST

• 

  ashna.asif

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 29 September 2019, 9:23 pm EST

  Hi,

  I have tablix inside a branded list. The branded list is grouped by 3 properties. If the data exceeds more than the page can contain then the excess data is shown in the next page.

  The is issue is that the next tablix data is appearing along with the previous data in same page where as it should come in new page.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 30 September 2019, 4:47 pm EST

  Hello Ashna,

  Could you please try after setting the “KeepTogether” property of Tablix Row/Column group to true. If the issue still reproducible, could you please share the report and DB so that we can replicate the issue at our end.

  This will be very helpful for us.

  Thanks,
  
  Mohit

• 

  ashna.asif

  • Post Options:
  • Link
    Copy

  Posted 30 September 2019, 7:42 pm EST

  I can achieve it by setting PageBreakAtStart for the list details, but there is a blank page generated after each new page

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 30 September 2019, 7:52 pm EST

  Hello Ashna,

  Could you please try after setting the “PageBreakAtSart” of the third group in the BandedList. Also, it is helpful for me to narrow down the issue if you provide the report layout to me.

  Thanks,
  
  Mohit

• 

  ashna.asif

  • Post Options:
  • Link
    Copy

  Posted 30 September 2019, 9:02 pm EST - Updated 30 September 2022, 6:39 am EST

  As per the company policy I cannot share the file or db.
  
  I will try every combination and let you know.

• 

  ashna.asif

  • Post Options:
  • Link
    Copy

  Posted 30 September 2019, 9:11 pm EST

  Hi Mohit,

  Its not working that way

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 2 October 2019, 5:31 pm EST

  Hello Ashna,

  I am assuming you have a BandedList with three group expressions (G1>G2>G3)in your report. In this way, you have three group header and three group footer. After that, you put the Tablix in BandedList detail which is bind with some datafields. While previewing, you get the data of the next value of G3 group on the same page. You want that every value in the G3 group will render on the new page.

  Could you please confirm if my understanding is correct or not. If not, could you please explain your report layout in detail.

  Thanks,
  
  Mohit

• 

  ashna.asif

  • Post Options:
  • Link
    Copy

  Posted 2 October 2019, 8:41 pm EST

  Hi Mohit,

  It is exactly what I wanted.

  Thanks

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 2 October 2019, 9:08 pm EST

  Hello,

  I have created a report with the exact layout. I have deleted the Banded Group Footer of all groups and set the “PageBreak At End” to true of the third group. Now, the new group data will render on new page always.

  Note: Please change the connection string of the report.

  Thanks,
  
  Mohit
  
  rpt_BandedList.zip