CODEWITHSUNDEEP
reporting-servicespositionssrs-tablixsubreports
goryef
goryef

Reputation: 1489

Pin tablix row to the bottom of the page on SSRS reports

I am trying to print multiple SSRS reports in bulk using subreports. Since there is no way to display subreport header and footer on the main report i need to be able to display header and footer information i.e. company logo, address (header), invoice total in the subreport body. I would like last row of the tablix that contains invoice information to be pinned to the bottom of the page. Counting rows and adding "spacer" row will not work b/c there are comments field that can grow and shrink significantly. is there a way to determine an absolute position of the report element at the time it's printed i.e. text box "order comments" location x,y height H. ? Thanks in advance.

Upvotes: 0

Views: 927

Answers (1)

Geo
Geo

Reputation: 336

One way you could achieve this is to actually add a space break (not in the tablix) in the report itself. This would be a true, static break in the report, for every page. It would look something like:

                                          Header

Tablix -- - - - - - -  -- - - - -- - - - - - - -- - --  - - -

                            [white space- insert items here]

Tablix  - - -- - - -- - - -- - - - - - - - - -- - -  --- - - -

                                          Footer

Upvotes: 0

Related Questions