none
display data in 5 row and then 5 row in colum

    Question

  • Hi there,currently my data is displayed like this 

    H1

    H2

    H3

    1

    2

    3

    4

    5

    6

    7

    8

    9

    10

    how can i split this into this belwo of 5 rows each 

    H1

    H2

    H3

    1

    2

    3

    4

    5

    6

    7

    8

    9

    10


    11

    12

    13

    14

    15



    Saturday, November 02, 2013 10:35 AM

Answers

  • Try below steps,

    1. Select the tabix row in design view, right click and select "Insert Row Below".

    2. Set the background color property of the new row as Darkgray

    3. Finally set the Visibility property of the new row as expression

    =IIF(RowNumber("DataSetName") Mod 5 = 0, False, True)


    Regards, RSingh

    • Marked as answer by CRM20133 Saturday, November 02, 2013 1:56 PM
    Saturday, November 02, 2013 11:10 AM

All replies

  • Try below steps,

    1. Select the tabix row in design view, right click and select "Insert Row Below".

    2. Set the background color property of the new row as Darkgray

    3. Finally set the Visibility property of the new row as expression

    =IIF(RowNumber("DataSetName") Mod 5 = 0, False, True)


    Regards, RSingh

    • Marked as answer by CRM20133 Saturday, November 02, 2013 1:56 PM
    Saturday, November 02, 2013 11:10 AM
  • Try below steps,

    1. Select the tabix row in design view, right click and select "Insert Row Below".

    2. Set the background color property of the new row as Darkgray

    3. Finally set the Visibility property of the new row as expression

    =IIF(RowNumber("DataSetName") Mod 5 = 0, False, True)


    Regards, RSingh

    Thanks for ur answer .if we do same with the column as we did with the row then how can we do this to achive

         

      

    Saturday, November 02, 2013 3:23 PM
  • I don't think we can do for column exactly. We need to insert  a column explicitly between columns.

    Regards, RSingh


    Sunday, November 03, 2013 6:29 AM
  • I don't think we can do for column exactly. We need to insert  a column explicitly between columns.

    Regards, RSingh


    Thanks for this .one final question how can I repeat Header row as on top of every 5 row  block .after applying expression  the header is only for first 5 row block

    thanks .

    Tuesday, November 05, 2013 12:08 AM
  • One trick can be, we add blank rows and set the visibility property expression. Now instead of a blank row, if that row is filled with header names in each text boxes then i think the header names will be visible each time the row is displayed.

    Regards, RSingh

    Tuesday, November 05, 2013 3:42 AM