August 3, 2005 at 8:10 am
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
August 3, 2005 at 9:51 am
Do you have these tables inside a list control????
Moe C
August 3, 2005 at 10:20 am
Not that I know of. Just three tables created from the RS toolbox. Did not use the List object in the toolbox.
Larry
Larry
August 3, 2005 at 10:33 am
And you said for each different table you have set the dataset to different datasource...
Moe C
August 3, 2005 at 10:34 am
have you tried using a matrix instead of a table???
Moe C
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply