Print Layout Settings

How can I set default print properties for a report in a ReportViewer control?

Do I have to set it by the report or by the ReportViewer?

I mean properties like A4 page, and Landscape layout?

?|||

The print properties can be defined in the RDL. The page size, width, etc.. are properties in the RDL. The layout for landscape can be pre-set by setting the width and hight to 11x8.5.

This link might help: http://msdn2.microsoft.com/en-us/library/ms159237.aspx

Print hardcopy of table structure

I've just started working with SQL Server Express, and would like to print out a report listing the properties (Ie. field names, data ttypes, length, field description, etc.) of each of the tables in my database.
How do I do this?

The best way would be to use the INFORMATION_SCHEMA views and in this case the one that presents the columns definitions:

SELECT * FROM
INFORMATION_SCHEMA.COLUMNS

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||Thanks very much for your help!

print as landscape

Is there a way to get reports to print as landscape instead of potrait
automatically? I changed the Layout from properties to the correct width
and page height, the display looks fine but when I print, it tries to print
it on potrait setting. I've tried printing from both the report previewer
and deployed as an html document.
Thanks
-JoeHi,
I am also facing a similar problem. Is there a method where you make a
report in potrait style and print it in landscape.
thanks
"Joe Scalise" wrote:
> Is there a way to get reports to print as landscape instead of potrait
> automatically? I changed the Layout from properties to the correct width
> and page height, the display looks fine but when I print, it tries to print
> it on potrait setting. I've tried printing from both the report previewer
> and deployed as an html document.
> Thanks
> -Joe
>
>|||I have the same problem - it seems like export to {format} results in
portrait no matter what the report page size. I hope the answer to
this is a simple implementation - not "wait for SP2" or something like
that.sql

Preventing Extended Properties

Is there a way to tell SQL Server not to bother storing extended
properties?
I see no use for these, except bothering me when i am creating SQL
scripts for recreation on another database...
Any way to do that?
TascienHow do you mean "bothering" you?
How are you generating the scripts? Extended properties are excluded by
default from scripts generated by sql server (both EM and QA).
tascienu@.ecoaches.com wrote:

>Is there a way to tell SQL Server not to bother storing extended
>properties?
>I see no use for these, except bothering me when i am creating SQL
>scripts for recreation on another database...
>Any way to do that?
>Tascien
>
>|||I am using Adept SQL diff to compare my databases and extended
properties are bothering me... beside that, i really don't need them.
Anyway, sorry for bothering the group at this time, i've found a
solution for anyone else who doesn't like extended properties like
me...
1. Right click the SQL Server > Properties > Server Settings > and
Enable the checkbox "Allow modifications to be made directly to the
system catalog".
2. run the script below in the Query Analyser:
use [YourDatabaseName]
DELETE FROM sysproperties
3. Right click the SQL Server > Properties > Server Settings > and
"Disable" the checkbox "Allow modifications to be made directly to the
system catalog".
That should do!!!
Thank you for anyone who tried to help.
Tascien|||> DELETE FROM sysproperties
YIKES! I'm not sure this is such a good recommendation.|||Not good, but it works for me... USE AT YOUR OWN RISK!!!!