Multiple RS data tables, different numbers of rows per page?

• Larry Stein

  Default port

  Points: 1447

  More actions

  August 3, 2005 at 8:10 am

  #168101

  I have a report that looks kind of like a cross tab.  It is built with 3 different Reporting Services (RS) tables, each tied to their own query.  Each query returns the same (correct) number of rows, but one of the RS tables always seems to have a different number of rows rendered per page when run.  See the example below.  To make sure I didn't accidentally set something different in some obscure table/field property, I created (and dropped and recreated just in case) the offending RS table as a copy of the first, just changing the RS table data source, column values, and column widths.  Thoughts?

  Simplified example. Notice that Tbl2 has the correct values, just a row offset.

  Thanks - Larry

  First page:

  Tbl1Col1     Tbl2Col1   Tbl3Col1

  Val1           Val1        Val1

  Val2                         Val2

   

  2nd page:

  Tbl1Col1     Tbl2Col1   Tbl3Col1

  Val3           Val2        Val3

  Val4           Val3        Val4

   

  3rd page:

  Tbl1Col1     Tbl2Col1   Tbl3Col1

  Val5           Val4        Val5

                   Val5

  Larry

• moe_mayne

  SSCommitted

  Points: 1933

  More actions

  August 3, 2005 at 9:51 am

  #579209

  Do you have these tables inside a list control????

  
  Moe C

• Larry Stein

  Default port

  Points: 1447

  More actions

  August 3, 2005 at 10:20 am

  #579220

  Not that I know of.  Just three tables created from the RS toolbox.  Did not use the List object in the toolbox.

  Larry

  Larry

• moe_mayne

  SSCommitted

  Points: 1933

  More actions

  August 3, 2005 at 10:33 am

  #579231

  And you said for each different table you have set the dataset to different datasource...

  
  Moe C

• moe_mayne

  SSCommitted

  Points: 1933

  More actions

  August 3, 2005 at 10:34 am

  #579232

  have you tried using a matrix instead of a table???

  
  Moe C