Showing posts with label instead. Show all posts
Showing posts with label instead. Show all posts

Wednesday, March 28, 2012

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

Monday, March 26, 2012

Primary versus unique keys

Hi

What impact is there in using a unique index instead of a primary key?

How does this impact performance?

How does this impact data file size?

Does it impact anything else?

Thanks

Hi,

http://www.mssqlcity.com/FAQ/General/primary_vs_unique_constraints.htm

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hi

It that the only difference?

Is there any impact on Replication, Database Mirroing (SQL 2005), or any other features?

Thanks

|||

There is an impact on transactional replication (all options) since it requires a primary key (unique indexes do not work). No impact to either merge or snapshot replication.

Database Mirroring and other features don't care.