Changing PDF Output Orientation

I have created report subscriptions for my end users which are emailed
PDF format reports. However, the default report orientation is PORTRAIT
but this format causes the reports to be generated in a very unreadable
way.
Is there a solution to changing the orientation to LANDSCAPE?
Thanks.You can't change the orientation directly - you need to change the
height and width values for the report page (from 11 x 8 1/2 to 8 1/2 x
11).
You also need to ensure the size of the body and the margins are
consistent with these settings.
The Acrobat reader will automatically rotate the page if you have these
settings correct - check the Acrobat settings, too, as it is possible
to have the auto rotate feature turned off.

Changing field length for Merge

Hello -
I am using Merge replication, pushing subscriptions to clients, and SQL
Server 2000.
I need to change the field size in one of the tables that is in a
publication. Basically, from nvarchar[4] to nvarchar[8].
Can I do this without having to drop/add all subscribers?
I'm hoping that the schema changes can be propagated to clients with a
reinit-subscription.
Thanks.
Regards,
bruce
Please have a look at this article:
http://www.replicationanswers.com/AddColumn.asp. BTW, such changes are much
simpler (just Alter Table...) in SQL Server 2005.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi, I have the same problem than Bruce, I'm using a merge replication but
with a sligtly difference, the field I must change is part of the table's
primary key... I read the Paul Ibison's article but it look fine for fields
doesn't belongs to the primary key, because if I drop the field in order to
made the change on the field, it will throw an duplicate key error. So, what
else can I do?
Thanks in advance
"Paul Ibison" wrote:

> Please have a look at this article:
> http://www.replicationanswers.com/AddColumn.asp. BTW, such changes are much
> simpler (just Alter Table...) in SQL Server 2005.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>

Changing domain password hoses subscriptions

Recently, I was prompted to change my domain password. Changed service
account for SQL and RS (2000 both) and reports and datasource credentials.
Reports run fine. However, getting the infamous "An internal error occurred
on the report server. See the error log for more details." error on all
subscriptions when nothing else changed. Went in and ran rsconfig to update
with the latest pwd but no joy. I know I'm missing something obvious but am
still futzing with this.
Any thoughts as to what I should be checking/correcting?Just a guess, but if your subscriptions store the report as a pdf in a
directory, could there be permissions problems there?
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"kvanhulle" wrote:
> Recently, I was prompted to change my domain password. Changed service
> account for SQL and RS (2000 both) and reports and datasource credentials.
> Reports run fine. However, getting the infamous "An internal error occurred
> on the report server. See the error log for more details." error on all
> subscriptions when nothing else changed. Went in and ran rsconfig to update
> with the latest pwd but no joy. I know I'm missing something obvious but am
> still futzing with this.
> Any thoughts as to what I should be checking/correcting?
>
>

Changing Credentials for Subscriptions ?

Trying to get e-mail subscriptions working. Suspect problem due to User
being "Network Service" and not having sufficient rights. Not sure how to
change. Both the ReportServer -service-, and the Application Pool I have
setup in IIS (6.0) are running under "Network Service". If I change
credentials on the service to an AD account, nothing bad apparently happens,
but subscriptions still not working. Changing the Identity on the App Pool
causes the site to crash with error "The report server cannot decrypt the
symmetric key used to access sensitive or encrypted data in a report server
database." ... etc. Restoring the original Network Service credentials
restores functionality.
So how do I make changes such that subscriptions will run under a new
account? And is there -any- way to -display- whatever current credentials RS
has in use in various areas? (UserID would suffice - not looking for
password or a security hole here).
Going bananas in Kansas,
JNWhen you change the windows service user you are most likely getting the
same error you see when you change the iis users, only the error only shows
in the service log file. To get around this issue, first use rskeymgmt to
export the symmetric key. Change the user of the windows service and then
user rskeymgmt to import the symmetric key. This will get you running as
the new user. Monitor the ReportServerService<timestamp>.log file to see if
there are any errors reported by the service.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"J Noble" <JNoble@.discussions.microsoft.com> wrote in message
news:D46A1BED-9E9A-4F61-80C6-828C6623E27F@.microsoft.com...
> Trying to get e-mail subscriptions working. Suspect problem due to User
> being "Network Service" and not having sufficient rights. Not sure how to
> change. Both the ReportServer -service-, and the Application Pool I have
> setup in IIS (6.0) are running under "Network Service". If I change
> credentials on the service to an AD account, nothing bad apparently
> happens,
> but subscriptions still not working. Changing the Identity on the App
> Pool
> causes the site to crash with error "The report server cannot decrypt the
> symmetric key used to access sensitive or encrypted data in a report
> server
> database." ... etc. Restoring the original Network Service credentials
> restores functionality.
> So how do I make changes such that subscriptions will run under a new
> account? And is there -any- way to -display- whatever current credentials
> RS
> has in use in various areas? (UserID would suffice - not looking for
> password or a security hole here).
> Going bananas in Kansas,
> JN
>|||Thanks very much, Daniel. That did the trick.
"Daniel Reib [MSFT]" wrote:
> When you change the windows service user you are most likely getting the
> same error you see when you change the iis users, only the error only shows
> in the service log file. To get around this issue, first use rskeymgmt to
> export the symmetric key. Change the user of the windows service and then
> user rskeymgmt to import the symmetric key. This will get you running as
> the new user. Monitor the ReportServerService<timestamp>.log file to see if
> there are any errors reported by the service.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "J Noble" <JNoble@.discussions.microsoft.com> wrote in message
> news:D46A1BED-9E9A-4F61-80C6-828C6623E27F@.microsoft.com...
> > Trying to get e-mail subscriptions working. Suspect problem due to User
> > being "Network Service" and not having sufficient rights. Not sure how to
> > change. Both the ReportServer -service-, and the Application Pool I have
> > setup in IIS (6.0) are running under "Network Service". If I change
> > credentials on the service to an AD account, nothing bad apparently
> > happens,
> > but subscriptions still not working. Changing the Identity on the App
> > Pool
> > causes the site to crash with error "The report server cannot decrypt the
> > symmetric key used to access sensitive or encrypted data in a report
> > server
> > database." ... etc. Restoring the original Network Service credentials
> > restores functionality.
> >
> > So how do I make changes such that subscriptions will run under a new
> > account? And is there -any- way to -display- whatever current credentials
> > RS
> > has in use in various areas? (UserID would suffice - not looking for
> > password or a security hole here).
> >
> > Going bananas in Kansas,
> > JN
> >
>
>