Showing posts with label body. Show all posts
Showing posts with label body. Show all posts

Thursday, March 8, 2012

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. Smile

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

Saturday, February 25, 2012

About Support Policy of Database Mirror

Hi, does any body knew about whether the database mirror was supported after
the SP1 released? Thanks!Hi,
Yes I believe that database mirroring is now supported in production
environments. The below links may be of interest:
http://www.microsoft.com/presspass/press/2006/apr06/04-19SQLExpands06PR.mspx
http://blogs.msdn.com/euanga/archive/2006/04/19/578792.aspx
Hope that helps a bit

About Support Policy of Database Mirror

Hi, does any body knew about whether the database mirror was supported after
the SP1 released? Thanks!Hi,
Yes I believe that database mirroring is now supported in production
environments. The below links may be of interest:
http://www.microsoft.com/presspass/...xpands06PR.mspx
http://blogs.msdn.com/euanga/archiv.../19/578792.aspx
Hope that helps a bit

About Store Produre

Hi Every Body.
Its Biswajit I want to know about use of Store Procedure in
SQL.What is benifit of store procedure and we r using it."Biswajit Barik" <biswajitbarik@.rediffmail.com> wrote in message
news:311aa9ac.0404030003.4ac2d5ad@.posting.google.c om...
> Hi Every Body.
> Its Biswajit I want to know about use of Store Procedure in
> SQL.What is benifit of store procedure and we r using it.

http://www.sommarskog.se/dynamic_sql.html#Why_SP

Also see "Stored Procedures" in Books Online.

Simon