Groups | Blog | Home
all groups > sql server reporting services > june 2006 >

sql server reporting services : Reports with fixed position elements


Tim Dot NoSpam
6/12/2006 12:00:00 AM
Try setting the bottom margin to force the page break.

[quoted text, click to view]

PacMan
6/12/2006 3:32:01 AM
Hi,

I am having a problem with my report. I would like to display this way

--------------------------------------------------------------------------------------------------

<Main Report>

Employee Name: XXX Employee Address: xxxx

---------------------------------------------------------------------------------------------

<Subreport consisting of 2 tables>

Code / Description / Amount ! Code / Description / Amount

XXX XXXXXXX xxxxxx ! XXX XXXXXXXX xxxxxx

XXX XXXXXXX xxxxxx ! XXX XXXXXXXX xxxxxx

-----------------------------------------------------------------------------------------------
Total xxxx
xxxx



However, since the data region for the subreport are tables, they almost
always do not have the same height. I would like to set a maximum height for
the table rows where the rows that will not fit will continue on the next
page. Is this possible?

In other words, I need to have the table totals exactly on the 6 inch mark
of the report. How can I do this?

Also, I need to be able to print to a pre-printed form, if I have to (hence
the exact positioning)

Thanks for your help.

Regards
PacMan
6/12/2006 8:23:01 PM
Hi Tim,

Thanks for your advice. However, that does not solve the problem of my 2
tables having different lengths. Their subtotals rows (repeated on every
page) should be on the same line.

like this:
---------------------------------------------
cost desc amount tax desc amount
xxx xxx xxxx xxx xxx xxx
xxx xxx xxxx xxx xxx xxx
xxx xxx xxxx
xxx xxx xxxx
---------------------------------------------
subtotal: xxxx subtotal: xxx

where the 2 tables are separate data regions.

NOT like this
---------------------------------------------
cost desc amount tax desc amount
xxx xxx xxxx xxx xxx xxx
xxx xxx xxxx xxx xxx xxx
xxx xxx xxxx ----------------------
xxx xxx xxxx subtotal: xxx
---------------------
subtotal: xxxx


Regards,
PM


[quoted text, click to view]
AddThis Social Bookmark Button