Share via

SSRS Report date period field not working in iFrame

Jamie Shand 1 Reputation point
2020-10-13T09:26:13.987+00:00

I've had to perform an in-place upgrade to a Windows 2008 R2 server -> 2012 R2 -> 2016 for reasons out of my control. The end result is actually quite stable from what I can see/tell but have a few niggles I'm struggling to find a solution to.

The main one being with SSRS reports. Since the OS upgrade, browsing to reports hosted by SSRS on a dedicated server, with a date period field in them, will no longer load in an iFrame within a web application hosted on the upgraded server, however, works fine if browsing directly to the SSRS report outside of an iFrame. Also if I change it to a text field it'll work fine, so it's obviously got a issue with the date period field within an iFrame hosted by the upgraded OS server specifically.

There's nothing getting logged in "D:\Program Files\Microsoft SQL Server\MSRS13.SQL_BI\Reporting Services\LogFiles\ReportServerService__xxxxx.log" on the SSRS server when running this in an iFrame so doesn't look like it's making any calls at all. This is opposed to directly browsing to the report in the same browser, where it works as expected.

If I browse to a different environment that's running the same config but still running 2008 R2 servers, it works in the iFrame fine so is definitely something to do with the newer OS.

Any ideas?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,878 questions
0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,571 Reputation points
    2020-10-14T06:22:45.757+00:00

    Hi @Jamie Shand ,
    To be honest , it is hard to diagnose which part went wrong, since this is a complicated scenario. But as described, I tend to believe this is a browser support issue, since the report could work independently without issue.
    Could you try switch browser? You could try the application on newest Edge or Chrome on you window server see if the issue exists or not.
    Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. Jamie Shand 1 Reputation point
    2020-10-14T11:07:31.143+00:00

    Thanks for the reply Joyzhao-MSFT but I'm using the same browser to compare an environment with non-upgraded servers and the report works fine so it looks more to do with IIS serving the reporting services report within an iFrame from the upgraded server.

    Cheers
    Jamie

    0 comments
  3. Joyzhao-MSFT 15,571 Reputation points
    2020-10-15T02:30:34.643+00:00

    Hi Jamie,

    Thanks for the feedback.
    Well, I am not quite professional on web developing , my thought is that this may not have much to do with IIS. What is the error info and is there error in ssrs trace log?
    Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  4. Jamie Shand 1 Reputation point
    2020-10-15T09:04:18.033+00:00

    Hi Joy,

    I didn't know about that logfile location for SSRS so thanks for that but alas.......there's only a couple of INFO entries logged when running this report. No useful errors or anything you'd hope for. The absence of any errors at all is the hardest part when it comes to troubleshooting!

    0 comments
  5. Joyzhao-MSFT 15,571 Reputation points
    2020-10-16T02:59:30.517+00:00

    Hi,

    I'm not sure , is there no rendering info in the log ?

    For this case, I really would suggest you to reach MS to open a ticket at https://support.microsoft.com/en-us/assistedsupportproducts

    With more professional background and remote desktop or other troubleshooting tool, they could be able to resolve this issue.

    Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments