none
Control PageBreak in SSRS RRS feed

  • Question

  • Hi All :

    Can anyone to advise how to create page break on single record which have hundred of columns ?

    The example as below :

    Report Table structure as below
    Column1
    Column2
    Column3
    .
    Column99

    I want the report layout is 
    Record : 1
    Column1 : Column1.Value
    Column2 : Column2.Value
    Column3 : Column3.Value
    Column4 : Column4.Value
    ----- page break -----
    Record : 1
    Column4 : Column4.Value
    Column5 : Column5.Value
    Column6 : Column6.Value
    Column7 : Column7.Value
    ----- page break -----
    Record : 1
    Column85 : Column85.Value
    Column89 : Column89.Value

    ----- page break -----
    Record : 2
    Column1 : Column1.Value
    Column2 : Column2.Value
    Column3 : Column3.Value
    Column4 : Column4.Value

    ----- page break -----
    Record : 2
    Column4 : Column4.Value
    Column5 : Column5.Value
    Column6 : Column6.Value
    Column7 : Column7.Value

    ----- page break -----
    Record : 2
    Column85 : Column85.Value
    Column89 : Column89.Value

    Thank you

    Wednesday, August 21, 2019 11:36 AM

Answers

  • Hi Michael TC

    According to your description , seems you have two solution to achieve your requirement .

    One is the use the pivot to covert the column as the row in the dataset query .(do in the dataset query level , for details you could post the correspond issue at tsql forum)

    The other is try to change the table structure like below:

    How to get the table structure :

    (for the page break, if you group on the rownumber , and then just click the page break in the group properties , then you could get what you want.)

    Hope it can help you.

    Best Regards,

    Eric Liu


    Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread.


    • Edited by Mitarai Queen Thursday, August 22, 2019 2:12 AM
    • Marked as answer by Michael TC Thursday, August 22, 2019 5:01 AM
    Thursday, August 22, 2019 2:09 AM

All replies

  • Hi Michael TC

    According to your description , seems you have two solution to achieve your requirement .

    One is the use the pivot to covert the column as the row in the dataset query .(do in the dataset query level , for details you could post the correspond issue at tsql forum)

    The other is try to change the table structure like below:

    How to get the table structure :

    (for the page break, if you group on the rownumber , and then just click the page break in the group properties , then you could get what you want.)

    Hope it can help you.

    Best Regards,

    Eric Liu


    Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread.


    • Edited by Mitarai Queen Thursday, August 22, 2019 2:12 AM
    • Marked as answer by Michael TC Thursday, August 22, 2019 5:01 AM
    Thursday, August 22, 2019 2:09 AM
  • Hi Eric :

    Thanks for your solutions, and I have also find the another good way, is that

    1. Create Tablix with single column (cannot be multi column)

    2. Add one of row and insert the rectangle 

    3. Set the rectangle page break in the properties

    4. Then all data on after rectangle will go to next Page 

    Many thanks for your help

    Thursday, August 22, 2019 5:03 AM