Wednesday, February 15, 2012

Excel page setup / Email subscriptions

Hi,
I'm a newbie when it comes to Reporting Services, so please bear with me.
I am having 2 issues:
1) I am trying to get an exported Excel report to automatically select the
correct paper size. I have a report that is fairly wide, so I set the
report page up to 14" x 8.5" (Legal) and set the margins to .25" on each
side. Based on the limited info online, I was hoping this would translate
into Excel's Page Setup, but I was wrong. When I open the resulting Excel
workbook, the pages are set up as Landscape (which I hoped would happen),
but they are still Letter (11" x 8.5") sized. Is there any way to force
Excel to include Legal in the page setup?
2) I set up several Windows users with the role "Browsers" in Reporting
Services. I want them to be able to subscribe to a report via email. When
the user creates a new subscription, the "To" field is disabled, and is
populated only with their Windows username (ie, "jmarx"). The email
generated by the system fails (I think) due to not being able to resolve the
username into an email address. The server being used to send the emails is
Exchange 2000, and everything is integrated with Active Directory. If I go
to the Reporting Services site (I have all permissions on the site), I can
set up a new subscription with no problems, as the To, Cc, and Bcc fields
are all enabled and I can type in the full email address(es) as needed. The
email(s) get sent with no issues that way. Any ideas on how to map the
usernames to email addresses, thus allowing users with only "Browser" access
to subscribe to reports?
Thanks in advance for any help you can offer!
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]Jake,
I have the same problem. When a user (with "browser" privledges)
subscribes to a report, only their "username" show up in the TO: box
for email and it is greyed out so they can't change it. Hopefully,
someone from Microsoft is monitoring this board and will provide a
solution...
Pete|||Hi Pete,
hradecky wrote:
> I have the same problem. When a user (with "browser" privledges)
> subscribes to a report, only their "username" show up in the TO: box
> for email and it is greyed out so they can't change it. Hopefully,
> someone from Microsoft is monitoring this board and will provide a
> solution...
I finally figured that one out from searching google groups, but I'm not
entirely happy with the answer. You can enable this field by changing the
following in your RSReportServer.config file:
<SendEmailToUserAlias>True</SendEmailToUserAlias>
to
<SendEmailToUserAlias>False</SendEmailToUserAlias>
I believe you can set <DefaultHostName> to the hostname (ie, microsoft.com),
and that will be appended to all users' aliases. So if all your users are
in the same domain for email purposes, you could leave
<SendEmailToUserAlias> at True and enter your hostname in <DefaultHostName>.
Unfortunately for me, I have users in 2 domains, so this won't work. I
would really like to know how to map user aliases to email addresses, but I
haven't had the time to figure it out yet (or if it can even be done).
Changing <SendEmailToUserAlias> to False gives me an interim solution
anyway.
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||Did you ever find your answer to your printing question? We're having
the same sort of problem.
"Jake Marx" <msnews@.longhead.com> wrote in message news:<urY4CcemEHA.1908@.TK2MSFTNGP14.phx.gbl>...
> Hi Pete,
> hradecky wrote:
> > I have the same problem. When a user (with "browser" privledges)
> > subscribes to a report, only their "username" show up in the TO: box
> > for email and it is greyed out so they can't change it. Hopefully,
> > someone from Microsoft is monitoring this board and will provide a
> > solution...
> I finally figured that one out from searching google groups, but I'm not
> entirely happy with the answer. You can enable this field by changing the
> following in your RSReportServer.config file:
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> to
> <SendEmailToUserAlias>False</SendEmailToUserAlias>
> I believe you can set <DefaultHostName> to the hostname (ie, microsoft.com),
> and that will be appended to all users' aliases. So if all your users are
> in the same domain for email purposes, you could leave
> <SendEmailToUserAlias> at True and enter your hostname in <DefaultHostName>.
> Unfortunately for me, I have users in 2 domains, so this won't work. I
> would really like to know how to map user aliases to email addresses, but I
> haven't had the time to figure it out yet (or if it can even be done).
> Changing <SendEmailToUserAlias> to False gives me an interim solution
> anyway.|||Did you ever find your answer to your printing question? We're having
the same sort of problem.
"Jake Marx" <msnews@.longhead.com> wrote in message news:<urY4CcemEHA.1908@.TK2MSFTNGP14.phx.gbl>...
> Hi Pete,
> hradecky wrote:
> > I have the same problem. When a user (with "browser" privledges)
> > subscribes to a report, only their "username" show up in the TO: box
> > for email and it is greyed out so they can't change it. Hopefully,
> > someone from Microsoft is monitoring this board and will provide a
> > solution...
> I finally figured that one out from searching google groups, but I'm not
> entirely happy with the answer. You can enable this field by changing the
> following in your RSReportServer.config file:
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> to
> <SendEmailToUserAlias>False</SendEmailToUserAlias>
> I believe you can set <DefaultHostName> to the hostname (ie, microsoft.com),
> and that will be appended to all users' aliases. So if all your users are
> in the same domain for email purposes, you could leave
> <SendEmailToUserAlias> at True and enter your hostname in <DefaultHostName>.
> Unfortunately for me, I have users in 2 domains, so this won't work. I
> would really like to know how to map user aliases to email addresses, but I
> haven't had the time to figure it out yet (or if it can even be done).
> Changing <SendEmailToUserAlias> to False gives me an interim solution
> anyway.

No comments:

Post a Comment