embed office document

is it at all feasible to embed an office doument (specifically word) into an ssrs report so that the document will print out when renderered to pdf?
No, this is really not possible. You would need to translate the text into RDL to do this. We are looking at the ability to provide rich text formatting (including embedded HTML) in a future release.|||Please add this feature.

embed office document

is it at all feasible to embed an office doument (specifically word) into an ssrs report so that the document will print out when renderered to pdf?No, this is really not possible. You would need to translate the text into RDL to do this. We are looking at the ability to provide rich text formatting (including embedded HTML) in a future release.|||Please add this feature.

email subscription to hotmail?

Hello...

I have a Virtual PC running SSRS 2005. I keep getting the following error when I try to specify my hotmail account as the To line in the email subscription:

"The e-mail address of one or more recipients is not valid."

I am trying to set it up such that I can send email subscriptions to my hotmail account, or at least let the SMTP Service accept these emails. I don't necesarily need to have these emails delivered, but I would like them to at least be accepted by the SMTP Service. I have added the following to my rsreportserver.config file:

<PermittedHosts>
<HostName>hotmail.com</HostName>
</PermittedHosts>

I am sure I need to configure the IIS SMTP Server settings somehow, does anyone know how to configure my local SMTP Service to allow @.hotmail.com email addresses to be placed into the "Drop" folder?

TIA

All,

After reading through some more posts online (searching through Google groups, yes Google groups MS folks!!!) I found what I needed to do. In fact, what I found does a lot more than I needed to do, it actually sends the email to the external account.

This is NOT a Reporting Services configuration issue. This is an SMTP Service configuration issue (as I suspected). Here is what I did. This may or may not be the "correct" way to do things, but it certainly works for my test environment (Note that this configuration probably shouldn't be used in a production enviornment!!!):

1. Open IIS Manager and right-click the "Default SMTP Virtual Server" and select "Properties".

2. On the Properties dialog, select the Access tab.

3. From the Access tab, click the "Relay..." button (near the bottom of the tab).

4. From the Relay Restrictions dialog, select the "All except the list below" option. Ensure that the "Allow all computers which successfully authenticate to relay, regardless of the list above" checkbox is checked.

5. Click OK on the Relay Restrictions dialog.

6. Click OK on the "Default SMTP Virtual Server Properties" dialog.

7. Stop, then Start the SMTP Service.

8. Setup your email subscription with your external email account and let it run.

Again, this worked for my development\test environment, but you should probably investigate further if you want to use this in a production environment as I am sure that setting up your SMTP Service for relay in this way probably opens it up to all sorts of attacks (like SPAM).

Hope that this helps others experiencing the same/similar issue!!

|||

Also:

9. I got rid of the items I added to the PermittedHosts element, this way I am not restricted to which domains I sent to. Obviously in a production enviornment you would not want to do this.

Email subscription Issue

We have deployed SSRS 2005 on internet using Forms authentication. every thing works just fine except the email subscription;

when a user who is part of browser role (manage individual subscription) clicks on new subscription his To field is grayed out (unable to modify) and account showing in it is the service account we use to run reporting service.

we need to give users permission to specity To, CC, BCC fields without letting them see other subscriptions.

can you help us configuring this?

Hi Aneel-

You need to go into the rsreportserver.config file located in the ReportServer folder and look for the "<SendEmailToUserAlias>" node. If it is "False", change it to "True" and you'll be able to enter e-mail addresses to send to. You will only get the "To" field, not "Cc" or "Bcc" fields.

Note you may have to restart IIS.

Regards,
Scott

e-mail in SSRS reports with attachment

Hi All,

In my SSRS report there is a column with email field, when the user clicks on it -- it should open the outlook and in the attachment field there should be a screenshot of that report

i think anything i could do is only in the jump to url in the navigation tab......Please suggest me the solution or any other alternatives.

Thanks in advance for help

Warm Regards,

Chanduu.

I am using an alternate approach, but that is also not working

The approach I was using is writing a code in c# to export that report in PDF programmatically using c#, without opening SSRS so that I could attach it outlook/write a mail program, for this I got some help from this site http://www.programurl.com/pdf-reporting-services.htm, but this file is saving a PDG file without any data.

If you have any solution, please send me so that I could move further

Warm Regards,

Chanduu

e-mail in SSRS reports with attachment

Hi All,

In my SSRS report there is a column with email field, when the user clicks on it -- it should open the outlook and in the attachment field there should be a screenshot of that report

i think anything i could do is only in the jump to url in the navigation tab......Please suggest me the solution or any other alternatives.

Thanks in advance for help

Warm Regards,

Chanduu.

I am using an alternate approach, but that is also not working

The approach I was using is writing a code in c# to export that report in PDF programmatically using c#, without opening SSRS so that I could attach it outlook/write a mail program, for this I got some help from this site http://www.programurl.com/pdf-reporting-services.htm, but this file is saving a PDG file without any data.

If you have any solution, please send me so that I could move further

Warm Regards,

Chanduu

email delivery in ssrs developer edition

is subscription using E-mail delivery possible in SSRS developer edition? act in the option for "Delivered By" in "New Subscription", only "Windows file share" is coming....

Hi.

Developer Edition gives you the same feature set as Enterprise, just with a license that does not allow use in a production environment.

If the email delivery option is not showing within SSRS, then it normally indicates the email settings have not been configured i.e. you must setup an SMTP server.

To check/configure this you use the Reporting Services Configuration Manager; check the Email Settings config (second from the bottom on the left) - once those have been completed correctly and the Email Settings shows a green tick, you should find email delivery is available for subscriptions.

Hope this helps,

Gary.

|||I am using SSRS developer edition and can only send email within my work domain - nothing external.

Also, if you CC or Bcc an external address the process fails.

I assume this is a restriction on the developer edition.

Editing the Subject textbox on SSRS Email Standard Subscription

Hi

Does anyone know if it is possible to edit the subject text box of a Standard Email Subscription so that it contains report variables other than the default Globals and if so, how?

Basically I want to add a value field from the report I'm emailing into the subject line. I've already discovered that you cannot use the rest of the Global variables in the subject line other than the default @.ReportName and @.ExecutionTime.

The variable I want to add is in the report dataset.

Any help would be greatly appreciated.

Thanks

RW

Sorry, I don't have the link to the site I saw this on, but I did read that @.ReportName and @.ExecutionTime are the only 2 parameters available.