Position a table control always at the bottom of a SSRS report
Hi
I am working on a SSRS 2008 report.
I have 2 Table controls in the body of the report (table A and table B).
Table A is on top and Table B is under table A. Now Table A has flexible no of rows as is based on a database query. Table B is also based on a database query however will always have fixed 5 rows.
How do I make Table B always appear at the absolute bottom of the report (irrespective of how many rows table A has)?
I am working on a SSRS 2008 report.
I have 2 Table controls in the body of the report (table A and table B).
Table A is on top and Table B is under table A. Now Table A has flexible no of rows as is based on a database query. Table B is also based on a database query however will always have fixed 5 rows.
How do I make Table B always appear at the absolute bottom of the report (irrespective of how many rows table A has)?
WotanAU
I believe there is no inherent support for this, however you could either put the table in the footer of the report(but that could look a bit odd), or you could try putting a box (make it white so you can't see it) on the left side of the report, and and put the tables in their relative positions.
ASKER
1) I dont think u can put a table in report footer.
2) can u please elaborate ur 2nd box option?
Thx
2) can u please elaborate ur 2nd box option?
Thx
If you create a shape like a rectangle, placing the top of the rectable snapped to the top table, the top table will stay connected to the top of the rectangle. You can then snap the second table to the bottom of the rectangle and the table will be forced to draw at the bottom underneath it.
If you make the rectangle white, it won't be visible when the report is generated.
If you make the rectangle white, it won't be visible when the report is generated.
ASKER
Worth trying, will let u know if it works... Thx
ASKER
WotanAu - adding a rectangle dint work
Any other suggestions. Will writing some custom code work?
Any other suggestions. Will writing some custom code work?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i found the solution on another site and later was directed to the same website by an Expert here. hence the point split.