emailed subscription not including port number in servername URL link for report

I hope someone can help as I have searched for a solution but been unable to find one as yet.

My problem is that after installing SharePoint V3.0 and amending the Report Server to <ServerName>:8080, as I don't yet wish to use integrated mode, everything works fine except email delivered subscriptions. The URL in the email body referencing the report only puts in <ServerName> etc. omitting the port number :8080. I have tried to find where this URL link is built-up from but have had no luck in the report manager, report services configuration and the config files, does anyone know where I need to look and if possible what I need to amend to have the link include :8080 after the servername portion of the URL. I can copy the URL and manually insert the port address and it works but this defeats the object of automated subscriptions.

Sorry if this is a dumb question but it is giving me a headache at the moment.

All answers gratefully received,

Andy

You should update the URLRoot element in the rsreportserver.config file to include :8080 in it. This should get the URL to work.

-Lukasz

|||

Thanks Lukasz,

I thought I had looked at all the appropriate config files but obviously I missed this one. I found the entry and added the :8080 to the path and it all works fine now.

Much appreciated,

Andy

emailed subscription not including port number in servername URL link for report

I hope someone can help as I have searched for a solution but been unable to find one as yet.

My problem is that after installing SharePoint V3.0 and amending the Report Server to <ServerName>:8080, as I don't yet wish to use integrated mode, everything works fine except email delivered subscriptions. The URL in the email body referencing the report only puts in <ServerName> etc. omitting the port number :8080. I have tried to find where this URL link is built-up from but have had no luck in the report manager, report services configuration and the config files, does anyone know where I need to look and if possible what I need to amend to have the link include :8080 after the servername portion of the URL. I can copy the URL and manually insert the port address and it works but this defeats the object of automated subscriptions.

Sorry if this is a dumb question but it is giving me a headache at the moment.

All answers gratefully received,

Andy

You should update the URLRoot element in the rsreportserver.config file to include :8080 in it. This should get the URL to work.

-Lukasz

|||

Thanks Lukasz,

I thought I had looked at all the appropriate config files but obviously I missed this one. I found the entry and added the :8080 to the path and it all works fine now.

Much appreciated,

Andy

emailed subscription not including port number in servername URL link for report

I hope someone can help as I have searched for a solution but been unable to find one as yet.

My problem is that after installing SharePoint V3.0 and amending the Report Server to <ServerName>:8080, as I don't yet wish to use integrated mode, everything works fine except email delivered subscriptions. The URL in the email body referencing the report only puts in <ServerName> etc. omitting the port number :8080. I have tried to find where this URL link is built-up from but have had no luck in the report manager, report services configuration and the config files, does anyone know where I need to look and if possible what I need to amend to have the link include :8080 after the servername portion of the URL. I can copy the URL and manually insert the port address and it works but this defeats the object of automated subscriptions.

Sorry if this is a dumb question but it is giving me a headache at the moment.

All answers gratefully received,

Andy

You should update the URLRoot element in the rsreportserver.config file to include :8080 in it. This should get the URL to work.

-Lukasz

|||

Thanks Lukasz,

I thought I had looked at all the appropriate config files but obviously I missed this one. I found the entry and added the :8080 to the path and it all works fine now.

Much appreciated,

Andy

Emailed Reports in Blackberry

Does anyone have a way to get reports that are emailed out via the
Subscriptions service as a WebArchive to appear normally in a
Blackberry? Each element in a row in a table gets put into a new line.
It looks fine in any normal email interface, but not in a Blackberry.
e.g.
Row1Col1 Row1Col2
Row2Col1 Row2Col2
will display in the Blackberry as
Row1Col1
Row1Col2
Row2Col1
Row2Col2
There seems to be a <p> tag in the raw html in each table item.
Any help is much appreciated.On Oct 3, 4:29 pm, TGav <cara...@.gmail.com> wrote:
> Does anyone have a way to get reports that are emailed out via the
> Subscriptions service as a WebArchive to appear normally in a
> Blackberry? Each element in a row in a table gets put into a new line.
> It looks fine in any normal email interface, but not in a Blackberry.
> e.g.
> Row1Col1 Row1Col2
> Row2Col1 Row2Col2
> will display in the Blackberry as
> Row1Col1
> Row1Col2
> Row2Col1
> Row2Col2
> There seems to be a <p> tag in the raw html in each table item.
> Any help is much appreciated.
You might try changing the report format to accommodate the
Blackberry. Also, you might want to look into a different export
option and/or a different type solution that possibly is geared toward
Visual Studio on Mobile Devices. Sorry that I could not be of greater
assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Email Report in Outlook 2007 not the same as Outlook 2003

I have a Reporting Services 2005 report that is emailed to users. I created/formatted the report based on how it looked in Outlook 2003 which all of our users had at that time. The report is wide, but just fit in the email window when it was full size. Now I have a user who has been converted to Outlook 2007 and he emailed me a copy of the report he received in Outlook 2007 and it looks like it reduced the column sizes; it does not fill the entire email window and wraps the wording on most lines because the column sizes have been reduced.

The report is:

Delivered by: Report Server E-mail

Include Report is checked

Render Format is Web archive

Any ideas on how I can fix this?

Thanks in advance.

I still haven't found a fix for this, however, the user has found that opening the email message in a browser window displays it as expected. I wouldn't consider this a fix, unless all Outlook 2007 users are supposed to open all email messages in a browser window. If not, then it still would be nice to send an email report that is formatted correctly when the message is opened as a regular email message as it used to do in earlier Outlook versions.

|||

I am having the same issue.

Has anyone found a solution to this?

I have an embedded image in my header that is not showing either.

Any help would be greatly appreciated.

Thanks, Adrian

|||I am still waiting for a solution. My report does not have an embedded image so I can't help you there. If I ever find a fix, I will post it here.|||We are having the same issue. Just getting my name on this so when anyone updates it i'll get emailed. :-)|||Ditto for me!|||Also having this issue, and have been trying to hack around it for a while. This really should be fixed as a lot of reports in outlook 2007 become almost unreadable when the columns get squished to be so narrow.|||Yet another with the same problem.|||

What are the target platforms?

Xp with Outlook 2003 & IE6 is okay?

How about Xp with Outlook 2003 & IE7?

I don't think there is an easy fix for this problem as I reacall reading somewhere that Outlook 2007 uses Word2007, and not IE to render html emails.

|||

If you mean which platform correctly displays the reports, then that would be all users who are on XP or newer, with Outlook 2003 and at least IE6. So are you saying that SSRS 2005 reports cannot be displayed inside the email message without opening a browser OR that these reports need to be completely reformatted to display correctly in Outlook 2007? I guess I'm asking if readable reports can even be included in the text of an Outlook 2007 email message? As more users upgrade, this is becoming more of a problem.

|||

Outlook 2003 used IE to render html. Outlook 2007 chose to use Word to render html which does not honor the column widths we specify. Search the web for "outlook 2007 html" and you'll find this problem is definately not specific to Reporting Services.

The good news is there is a fix (http://support.microsoft.com/kb/935399) which is part of the latest SQL Server 2005 SP2 Cumulative Updates available from http://support.microsoft.com/kb/936305.

Thanks.

Email Export?

Hello,

In the Crystal Report Viewer control, there is a way to export a report to the file format of choice (i.e. pdf or xls) and have it emailed.

This is probably a stupid question, but I have to ask it...

Is there a way to have an exported report in SSRS 2005 emailed without saving the report and then attaching it to an email?

I know about the scheduling services, but that will not work for me as my reports are created dynamically and displayed throught the ASP.NET 2.0 Report Viewer Control.

Thanks!!!

-Brian

Hi,

Have you tried Report Subscription using "Report Server E-mail" option? In BOL this is discussed under "E-Mail Delivery in Reporting Services". While configuring reports to be sent as an email you can include the report as a link or/and as an attachment.

HTH

Uday

|||

There is no supported email export. If you use the Viewer controls then your app could export the report and then send the email. Your app would have to take care of all smtp settings however.

-Daniel

|||

Thanks for the response Uday, but as noted in my original post, the report is created dynamically and not a published report. I cannot use the Scheduling/Subscription functionality...

-Brian

|||

Not built-into the ReportViewer control. Since you are sitting in code already, it is possible to wire this up really quickly using the classes in the System.Web.Mail namespace.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I am guessing I would need to use the ReportViewer's RenderStream method, but I cannot find good documentation on the parameters that are needed to call this method (i.e. streamId, mimeType, etc...). Which ones are required? I know what each does from the MSDN documentation, but I am looking for an example of this in use.

I am calling the RenderStream method and passing in empty strings (String.Empty) for each of the parameters and I am getting the following error:

"The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady)"

Any Ideas?

Thanks!

-Brian

Email Export?

Hello,

In the Crystal Report Viewer control, there is a way to export a report to the file format of choice (i.e. pdf or xls) and have it emailed.

This is probably a stupid question, but I have to ask it...

Is there a way to have an exported report in SSRS 2005 emailed without saving the report and then attaching it to an email?

I know about the scheduling services, but that will not work for me as my reports are created dynamically and displayed throught the ASP.NET 2.0 Report Viewer Control.

Thanks!!!

-Brian

Hi,

Have you tried Report Subscription using "Report Server E-mail" option? In BOL this is discussed under "E-Mail Delivery in Reporting Services". While configuring reports to be sent as an email you can include the report as a link or/and as an attachment.

HTH

Uday

|||

There is no supported email export. If you use the Viewer controls then your app could export the report and then send the email. Your app would have to take care of all smtp settings however.

-Daniel

|||

Thanks for the response Uday, but as noted in my original post, the report is created dynamically and not a published report. I cannot use the Scheduling/Subscription functionality...

-Brian

|||

Not built-into the ReportViewer control. Since you are sitting in code already, it is possible to wire this up really quickly using the classes in the System.Web.Mail namespace.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I am guessing I would need to use the ReportViewer's RenderStream method, but I cannot find good documentation on the parameters that are needed to call this method (i.e. streamId, mimeType, etc...). Which ones are required? I know what each does from the MSDN documentation, but I am looking for an example of this in use.

I am calling the RenderStream method and passing in empty strings (String.Empty) for each of the parameters and I am getting the following error:

"The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady)"

Any Ideas?

Thanks!

-Brian

email erroe

Hello,
I get this error message and nothing gets emailed to me. Help??
Emailing report to operator
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 18025: [Microsoft][ODBC SQL Server Driver][SQL Server]xp_sendmail: failed with mail error 0x80004005
Thanks:)I get the same errror from every couple of days. Do you run GENTRAN software on the computer you are having the problem with?

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 18025: [Microsoft][ODBC SQL Server Driver][SQL Server]xp_sendmail: failed with mail error 0x80004005|||Do you receive the error every time ?|||No we did not get the error every time, but almost exactly every 3 days or third time the XP_SENDMAIL function was invoked during auto-notification of backups completeing.

I found the solution earlier today the technet article is at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;320407

There is a hotfix for it to replace the Sqlmap70.dll with this version:
Version File name
----------
8.00.603 Sqlmap70.dll

I called Microsoft support and they emailed me a link to a hotfix file. I used the 1-800-936-4900 number from:
http://support.microsoft.com/default.aspx?scid=fh;en-us;Prodoffer41a

This hotfix has not been fully regression tested so they are only handing it out to customers with this exact problem.

All the is needed is to stop SQL Server backup the old dll, copy the new dll to the same location, and restart SQL Server.

I will know if it is fixed if I do not have any email problems/errors this week.|||jcreed - thanks for posting the solution to your problem with xp_sendmail (which is the same problem that I had a few months ago and fixed with the same methods that you did) - however, there is an intermittent problem and a steady problem with xp_sendmail.

Anu - If your problem is every x days then I would pursue the listing by jcreed; otherwise, let me know.|||xp_sendmail: failed with mail error 0x80004005
I had the same problem a while ago after System Administartor added NT login restriction on the SQL 2000 server. This has been resolved by stop and restart the services of SQLSERVERAGENT and MSSQLSERVER. I do not know if this is the case for you but it worked with me. So try it if this happens again.

email

I would like to automate a report to be emailed to an email address.
When viewing the report, clicked on new subscription.
In the subscription window what options should there be for Delievered By: ?
I currently have: Report Server File Share in the drop down. Should there be other entries in the list too?
ThanksChange to Report Server Email and make sure that the report server is configured for Email Delivery.

Email

Hi all me again I gotta question, the Sr executive asst has a number of reports that gets emailed to different department, only problem is those departments are on a totally different server. I am guessing that we need to start SQL AGENT Emailing MAPI to do this for us, of course I could be wrong. This is one of the stored procedures that creates one of the reports

CREATE PROCEDURE createSecurityListtobeEmailed
AS
SELECT SecurityListX."Last Name", SecurityListX."First Name", SecurityListX.MI, SecurityListX.Sex, SecurityListX.DOB, SecurityListX.IR#, SecurityListX."Issue Date", SecurityListX."Date served", SecurityListX.Duration, SecurityListX."Exp Date", SecurityListX."Reason for Exclusion", SecurityListX."Added Comment", SecurityListX.type INTO SecurityList
FROM SecurityListX
GROUP BY SecurityListX."Last Name", SecurityListX."First Name", SecurityListX.MI, SecurityListX.Sex, SecurityListX.DOB, SecurityListX.IR#, SecurityListX."Issue Date", SecurityListX."Date served", SecurityListX.Duration, SecurityListX."Exp Date", SecurityListX."Reason for Exclusion", SecurityListX."Added Comment", SecurityListX.type
HAVING (((SecurityListX."Last Name") Is Not Null))
GOIt appears that this just does a simple aggregation from SecurityListX into SecurityList. I can't see that it has any return set, or that it emails anything anywhere.

Are you sure that you aren't missing a few pieces to this puzzle ?

-PatP|||yes pat there are a few pieces of the puzzle missing, this will create a list which will be made into a report that a webpage on the casinos server, that the security department can view. Now I guess I have inherited this db and I need to include in the stored procedures using Xp_sendmail but I am unsure how to do it, and what I am doing is returning nothing but errors. So if you please sir....HELP???

Goodmorning Pat :)|||This is actually way too complex for me to even hazard a guess about what you really need to do, based on what I know so far. A lot depends on your mail configuration, security requirements, etc., so there isn'ta "one size fits most" kind of answer.

If all you want to do is run that statement, then send someone an email to tell them it ran (or failed), you can do that with just SQL Agent. If you want to extract the rows from the table and incorporate them into a mail message, then I'd suggest xp_sendmail.

At the moment I'm hampered by my rather limited understanding of what you want!

-PatP|||At the moment I'm hampered by my rather limited understanding of what you want!

And just when did that start to be a problem?

Sorry...I have Notus Lotes...(piece of garbage)|||And just when did that start to be a problem?

Sorry...I have Notus Lotes...(piece of garbage)I'm hampered by Bloats too. It does provide a great deal of casual entertainment as I'm trying to get some work done!

-PatP|||Nevermind Pat sorry to have bothered you|||Huh ?!?! Does that mean that you've solved the problem, or that you are going to look for another solution? Now you've given us enough to work on (via the snippets of VBA code) and you're going to take your ball and go home ?!?! Piddle! :rolleyes:

-PatP|||Misunderstood thought you were still unclear as was getting frustrated. I'm sure you have better things to do then to Mind read all day, since I couldnt get my point across. Had to retrieve more information was turning into a futile attempt...everyone was giving me bits and pieces.
XP_sendmail is new to me not sure how to do it|||That is actually one of the biggest hurdles to taking responsibility for a new (to you) system. You have to gather all of the stray bits of knowledge tucked into nooks and crannies throughout the systems affected, and if you have any pity on the next poor soul to come along you'll document the living bejesus out of what confused you.

If the next person has at least a few breadcrumbs to start from, they'll be a million miles further along than where you had to start from, and will hopefully utter prayers for you for the rest of their lives! Keep in mind that almost all systems are living things, they either grow or die, so the next person will have the chaos that you inherited plus everything that gets added during your tenure too. I've got a few systems that are exceptions that make great stories, but those are exceptions, not the rule by any means!

-PatP

email

I would like to automate a report to be emailed to an email address.
When viewing the report, clicked on new subscription.
In the subscription window what options should there be for Delievered By: ?
I currently have: Report Server File Share in the drop down. Should there be
other entries in the list too?
Thanksyes , you should have 'report serve email ' option too- if you dont, its
because you didnt choose the option at installation time to install SMTP
service.
"farshad" <farshad@.discussions.microsoft.com> wrote in message
news:91C6988E-808B-4049-AFA1-3B7A793F0220@.microsoft.com...
>I would like to automate a report to be emailed to an email address.
> When viewing the report, clicked on new subscription.
> In the subscription window what options should there be for Delievered By:
> ?
> I currently have: Report Server File Share in the drop down. Should there
> be
> other entries in the list too?
> Thanks|||How can I add this option whithout affecting the present instal/settings
please?
"Immy" wrote:
> yes , you should have 'report serve email ' option too- if you dont, its
> because you didnt choose the option at installation time to install SMTP
> service.
> "farshad" <farshad@.discussions.microsoft.com> wrote in message
> news:91C6988E-808B-4049-AFA1-3B7A793F0220@.microsoft.com...
> >I would like to automate a report to be emailed to an email address.
> > When viewing the report, clicked on new subscription.
> > In the subscription window what options should there be for Delievered By:
> > ?
> > I currently have: Report Server File Share in the drop down. Should there
> > be
> > other entries in the list too?
> > Thanks
>
>|||Hello again,
I do not remember seeing the SMTP option during the install.
Please note I am using SSRS 2005. The email we use is loyus notes.
Any thoughts pls?
Thanks
"Immy" wrote:
> yes , you should have 'report serve email ' option too- if you dont, its
> because you didnt choose the option at installation time to install SMTP
> service.
> "farshad" <farshad@.discussions.microsoft.com> wrote in message
> news:91C6988E-808B-4049-AFA1-3B7A793F0220@.microsoft.com...
> >I would like to automate a report to be emailed to an email address.
> > When viewing the report, clicked on new subscription.
> > In the subscription window what options should there be for Delievered By:
> > ?
> > I currently have: Report Server File Share in the drop down. Should there
> > be
> > other entries in the list too?
> > Thanks
>
>|||OK farshad, in RS2000 you have the option at installation time. For 2005 you
need to use the configuration tool.
See link below for steps:
http://msdn2.microsoft.com/en-us/library/ms159155.aspx
Immy
"farshad" <farshad@.discussions.microsoft.com> wrote in message
news:D25E292B-6886-4B0D-AD51-A518AF50BCA8@.microsoft.com...
> Hello again,
> I do not remember seeing the SMTP option during the install.
> Please note I am using SSRS 2005. The email we use is loyus notes.
> Any thoughts pls?
> Thanks
> "Immy" wrote:
>> yes , you should have 'report serve email ' option too- if you dont, its
>> because you didnt choose the option at installation time to install SMTP
>> service.
>> "farshad" <farshad@.discussions.microsoft.com> wrote in message
>> news:91C6988E-808B-4049-AFA1-3B7A793F0220@.microsoft.com...
>> >I would like to automate a report to be emailed to an email address.
>> > When viewing the report, clicked on new subscription.
>> > In the subscription window what options should there be for Delievered
>> > By:
>> > ?
>> > I currently have: Report Server File Share in the drop down. Should
>> > there
>> > be
>> > other entries in the list too?
>> > Thanks
>>