Placing row in absolute position in report

Question

Placing row in absolute position in report

neilnewton001

Mr or Mrs. 500

Points: 503
More actions
March 25, 2009 at 8:16 pm

#207635

Hi,
Pretty new to ssrs. I am printing a check. Like most business checks it has a top half which shows invoice number and has several rows showing individual components of the payment; the number of rows varies between checks. The bottom half of the form is the actual check showing amount and recipient address.
I have a line of fields, not part of the table, but showing up just below the table on the top half of the check. (I tried putting the line in the bottom half of a group but this was worse formatting wise_.
I want to put the line absoultely on the bottom of the top half of the check stock regardless of the amount of detail lines. Since the table has a variable number of lines, this separate line of fields falls a little below the last detail line in the table. I want it to always fall at the bottom of the top half of the check stock, regardless of how many detail lines appear in the table.
Any advice would be appreciated.
Thanks,
Neil

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lempster SSCoach Points: 15651 More actions · Answer 1

I'm trying to visualize your requirements and I may have done so incorrectly, but it sounds to me as though you can solve your problem by adding a line (from the Toolbox) onto the body of the report just below the table. No matter how many rows your table gets populated with, the line will always appear underneath it.

Regards

Lempster

neilnewton001 Mr or Mrs. 500 Points: 503 More actions · Answer 2

Lempster,

Thanks for replying. I know now that I could have been clearer. Imagin a large rectangle that makes up the top half of the check. In that rectangle is a table with a variable number of rows. As you said, if I put my line of data below the table it would always show up after the last detail row in that table.

But what if I wanted that line of data to be physically at the very bottom left of the rectangle, regardless of how many detail lines there are in the table. the way I have it the location of this line is determined by how many lines are in the table and I don't want that.

Should I set the location properties? That is the only thing I've thought of so far.

Thanks,

Neil

Lempster SSCoach Points: 15651 More actions · Answer 3

Neil,

Ah, it's a line of data rather than a solid line (as in a drawing object). I should have read your original post more thoroughly! How about if you make the line of data part of a second table and position the second table in the bottom lefthand corner of your rectangle, possibly setting the location properties as you mention?

Regards

Lempster

neilnewton001 Mr or Mrs. 500 Points: 503 More actions · Answer 4

Lempster,

Thanks for answering twice :-). I could have been clearer. My experience with ssrs is that tables kind of "put themselves where they want". I did try putting the line of data physically where I wanted it on the canvas beneath the table but it sort of "split" itself; the first text box showed up in approximately the right place and the rest of the texboxes showed up on the next line.

Basically, since tables are virtual, these ssrs reports are not WYSIWYG. I'm sure there's a way to do this but it isn't obvious. My fear is even if I could get a line of data to work or put the line in question at the top of a second table (I don't have a second table now) still wouldn't guarantee that I could get the line of data at exactly the same coordinates each time( that's what I'm look for-remember this is going on check stock), especially if either of the tables have a variable number of lines.

Any suggestions would be appreciated.

Thanks,

Neil