SSRS HTML4.0 Outlook Html Output - Graphs images show cross - And additional header row appears in Outlook

Good day,

I am rendering a report HTML4.0 via SSIS output in Outlook HTML:

        Dim content = client.DownloadString(http://intranet/ReportServer?http://intranet/workspace/departments/itws/Reports%20Test/R-MF001+ComplaintsDashboard.rdl&rs:Command=Render&rc:Format=HTML4.0&rc:Toolbar=False&rc:HTMLFragment=True&rc:OutlookCompat=True&rc:ExpandContent=True)
        myHtmlMessage = New MailMessage("test@test.co.za", myself@test.co.za, "test", "<meta name='ProgId' content='Word.Document'>" + content)

1. The report works running on my PC mailing myself, I can see the matrix table & graphs with no mail warnings popups etc. But when running on my PC to other users graphs don't show as if they don't have access to the image source and when I run Pkg from the server email to myself then I also get the image cross. I added the site to trusted sites & allowed email trust center but I am out of ideas - Please Any ideas?

2. The data table matrix displays in outlook but has an extra row/header omn top of matrix where in SSRS there is nothing, I tried in the script to remove the html source to remove the record but it does not work, it works only if remove all spaces then the entire matrix & report has no format - this is very important as I can afford extra lines on top of email as they want the report to be in your face cant ignore

content = content.Replace("<p '</o:p></p>", "")

Please Any help on any of these 2 points, as I am thinking after struggling for days on point 1 to have a matrix that has conditional formatting like excel that fills the cell with the cell weight but that is last resort

Thank You

July 24th, 2015 4:12pm

please any ideas?

Free Windows Admin Tool Kit Click here and download it now
July 26th, 2015 3:45pm

Hi Ismailc1,

Thank you for your question. 

I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 

Thank you for your understanding and support.

Best regards,
Qiuyun Yu

July 28th, 2015 5:01am
Very much appreciated
Free Windows Admin Tool Kit Click here and download it now
July 28th, 2015 5:48am

Hi Ismailc,

The code appends "<meta name='ProgId' content='Word.Document'>" at the front of the content as the mail body. Generally saying the <meta> tag should be located in the <head> tag.

Could you first debug to check the real content of the mail body? Is it a valid HTML format?

Thanks,

Wynn

July 29th, 2015 1:34am

Hi, Thank You for assisting.

I removed the tag & the problem persists

Dim client As New WebClient()
        client.Credentials = CredentialCache.DefaultNetworkCredentials
        Dim content = client.DownloadString("http://intranet/ReportServer?http://intranet/workspace/departments/itws/Reports%20Test/R-MF001+ComplaintsDashboard.rdl&rs:Command=Render&rc:Format=HTML4.0&rc:Toolbar=False&rc:HTMLFragment=True&rc:OutlookCompat=True&rc:ExpandContent=True")

        myHtmlMessage = New MailMessage("from", "to", "subject",content)

Its an SSRS report rendered within SSIS then output in HTML4.0, my images only display for me from my PC but not from another User & the Tag disables the Outlook warning

Please any other ideas?

Free Windows Admin Tool Kit Click here and download it now
July 29th, 2015 11:43am
Unfortunately not solution to this matter :(
August 6th, 2015 2:48am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics