Absolute position or location of report table.

Hello,

I have a report that prints cards for customers. The body of the report contains an address box, letter body, followed by a table that contains all the people to be printed on the cards. If the number exceeds 6 people, another page is to be printed, with no address or letter body, but the table with the remainder of the people on it.

I have been able to get everything to work except for the location of the table on the subsequent pages. They do not appear at the bottom as they do on the first page, but at the top of the page. I've tried using a rectangle as a container for the table, with no luck.

I seem to remember doing this in the past, but as projects get shelved for an extended period of time, the technical knowledge tends to fade.

Any suggestions would be greatly appreciated. Thanks

Have you tried setting both PrintOnFirstPage and PrintOnLastPage to true? This is described here:

http://msdn2.microsoft.com/en-us/library/aa178940(SQL.80).aspx

If you don't want header labels to show on the second and subsequent pages, then put them all inside of one container element and set its Hidden property to true if the PageNumber is > 1. This way the header area will still be rendered but everything in it is invisible.

sluggy

absolute position on page

when i put a table beside 2 graphs on my report, as the table expands it pushs the bottom table down ONLY when when it's displayed on the final webpage. the preview features shows it as being correct.

how do i prevent the expanding table from pushing the tables BESIDE it down? i could understand if it was a table below it, but it's not.

Hi,
Try putting all the components inside the Rectangle.But i dont think it will stop the expansion of Tables.But try implementing that way and see
In your case put Graphs,2 Tables inside the Rectangle and verify.|||ok what i tried, was putting the table inside a rectangle. by my understaning the table will expand inside the rectangle ? it seems like my rectangle is what's pushing down my bottom graph?|||

Hi

I'm having this problem also.

If I have many tables, differently positioned on one report.

Than tables that are higher positioned in design mode push all tables when in view mode (rendered), that are lower positioned, regardless wether they are directly beneath or beside !

I've tried to use rectangles but that doesn't matter,

Any advices ?

absolute object position

I have a table that expands and pushes down objects under it, i don't want this to happen i want my objects to use an absolute position so i can jiggle things how i want them - this doesn't seem to be an option in SSRS 2005?

Did not get your point yet, do you mean, you need data in a static place ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

yes. when i place objects on my report. it moves stuff all over the place in crazy ways at times. often different depending on the export format!

I just want to set a static/absolute position and have tables etc stay there.

About ordering of columns

i add new column using alter command but i always found it in the end of table but
i want to add it in particular position between the columns.........
how to do so ..........:)The only way to do that is dropping the table and recreating it with the columns in the position you want.

But why do you want to do this? Column order has no significant meaning in the database and can be arbitrarily changed in the the statements you use.|||I think if you use EM or SSMS to add a column you can add a column to the middle as well, but this likely does just what lexiflex suggests under the covers.

I agree with lexiflex: why do you care? The only reason I can think of is you are using "select *" in your app code, which is a no-no.|||You CAN move columns around in EM when in table design view. Just drag
the column to the position you want, and save the design.

ummmm... I would NEVER do this, I just saw somebody else do it (heh heh)|||You CAN move columns around in EM when in table design view. Just drag the column to the position you want, and save the design.but under the covers, EM creates a new table, copies the data from your original table, and then drops it|||EM creates a new table, copies the data from your original table, and then drops it
Which brings me to another reason for not using EM and making scripts yourself...

Try adding a NOT NULL-column without a default somewhere in between the other columns. Running the EM-script will cause an error about NULL-values in NOT NULL-columns just before it drops your original table and renames the temp-table. Thus making all the data from that table magically disappear... :S|||You CAN move columns around in EM when in table design view. Just drag
the column to the position you want, and save the design.

ummmm... I would NEVER do this, I just saw somebody else do it (heh heh)
I freely admit to doing this all the time.
Why? Because I like my data columns in logical groups, thats why.
But why do you want to do this? Column order has no significant meaning in the database and can be arbitrarily changed in the the statements you use.Absolutely correct. The database does not care about column order. But PEOPLE do...