locked
SSRS 2012 with MTHML subscriptions, Graphs, and Outlook cache issues RRS feed

  • Question

  • Hi,

    I looked for a resolution to this but couldn't fine one; hopefully someone has solved this issue or has a workaround and can point me in the right direction.  This seems to be both an issue with the SSRS Render method and Outlook caching, but since the source of the problem is with the Render method I'm posting here.

    We have several parameterized reports that use the same chart which is emailed in MTHML format to users.  Each email subscription sends a different parameter which in turn generates different chart data output.

    I've noticed that when SSRS renders the graphs in MTHML it uses an algorithm that generates code similar to the following for the image source:

    <img onerror="this.errored=true;" src="cid:C_632iT7_1">

    This image src value is the same for EVERY chart output regardless of the parameters passed to it.  This value is the same across all emails even when the parameters are different.

    The problem is when the report is emailed, Outlook's caching mechanism will display the wrong chart when clicking between different report result emails.  When opening the report in IE the correct chart for each is displayed correctly.  I understand this is because (a) the rendering engines are different and (b) due to how Outlook caches emails.

    The Render method of the report seems to generate this value rather than using some uniqueId each time.  Without using a custom Render method implementation or a custom Email delivery assembly to intercept and change this source id, has anyone been able to find a resolution to this?

    Due to our business model we cannot turn off cached exchange mode on the outlook client machines (although I haven't seen that this fixes anything in most circumstances).

    Thanks,

    Kevin

    Friday, January 2, 2015 12:06 PM

Answers

  • Hi Kevin,

    We can duplicate the issue in the office 2013 64 bit environment, below is our suggestion.

    1,As the issue doesn't appeared at office 2010,  so we suspect the outlook 2013 used a different algorithm from 2010 to retrieve the images , please also post a thread to the office forum.

    2, From a support perspective to further analize this issue is really beyond what we can do here in the forums. If the issue affect your business seriously, consider opening a support case with us. Visit this link to see the various support options that are available to better meet your needs:  http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone

    • Marked as answer by Kevin Lloyd Thursday, January 8, 2015 7:49 AM
    Thursday, January 8, 2015 6:07 AM

All replies

  • Hi Kevin,

    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.

    Thanks,
    Wendy Fu

    If you have any feedback on our support, please click here.
    Tuesday, January 6, 2015 2:41 AM
  • Hi Kevin,

    We did the testing based one your description, but unfortunately the issue cannot be duplicated in our lab, the following the testing steps.
    1, Setting the outlook used the cache mode.

    2, Sending the report to the user by the Data-Driven Subscription with different parameter values, ,we used three different  values in this testing.

    3,After getting three mails, and found the all of the three images in different emails used the same value src="cid:C_107iT1_1", however when clicking between different report result emails, we stiil can see the different images.

    Snapshot getting from the testing process.

    Testing Environment:
    Sql Server 2012 SP1 64 bit
    Exchange 2010 SP3
    Microsoft Office Professional plus 2010

    Wednesday, January 7, 2015 2:32 AM
  • Thank you for the update.

    I should have noted, and it is my fault, that we are using Office 365 and Outlook 2013.  From what I have been told, this didn't happen until moving to Outlook 2013 (i.e., it didn't happen with 2010).

    I'm a bit stumped to know if it's an Office issue or SSRS not generating unique ids for Outlook to use the correct version of the image from cache in 2013.

    For reference, our environment is slightly different:

    SQL Server 2012 SSRS

    Data resides in SQL 2008 R2

    Office 365 and Outlook 2013 x64 SP1

    Here are the results of what I see (both generate the same value src="cid:C_19iT0_1").  Note in the screenshot that the values for report name and chart title should match, showing the appropriate results.  The first two are taken directly from email and the last is opened in the browser and correctly shows the chart data.

    Wednesday, January 7, 2015 12:36 PM
  • Hi Kevin,

    We can duplicate the issue in the office 2013 64 bit environment, below is our suggestion.

    1,As the issue doesn't appeared at office 2010,  so we suspect the outlook 2013 used a different algorithm from 2010 to retrieve the images , please also post a thread to the office forum.

    2, From a support perspective to further analize this issue is really beyond what we can do here in the forums. If the issue affect your business seriously, consider opening a support case with us. Visit this link to see the various support options that are available to better meet your needs:  http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone

    • Marked as answer by Kevin Lloyd Thursday, January 8, 2015 7:49 AM
    Thursday, January 8, 2015 6:07 AM
  • Hi,

    Thank you for the confirmation that it is likely a problem in outlook 2013 and I will likely post there.  I had checked those forums in the past but there were no real solutions so thought I'd start here.

    Is there any way to override the image src tag in either the report design or the rendering to override this default image src tagging to use a unique id?  I don't want to have to write a custom delivery extension as this is the only time this issue presents itself.

    Thanks,

    Kevin

    Thursday, January 8, 2015 7:20 AM
  • Hi Kevin,

    Except changing the source code, as I know there is no easy way to generate unique id image src for every report from reporting service side, and I also doubt if it is necessary to do it ,  firstly we cannot 100% make sure the same src for the different images cause the issue, secondly even with the same src it still can display the images correcttly just like in the outlook 2010.

    Thursday, January 8, 2015 9:00 AM