Solved

Strange SSRS printing issue.

Posted on 2014-02-12
3
654 Views
Last Modified: 2014-02-14
Hello Experts,

I've recently setup a new webserver with Windows Server 2012.  I installed SSRS 2008 R2 with SP2.  I've made sure all udpates are done.

I have an aspx page with a reportviewer and some code-behind.  Here is the code:

            ReportViewer1.ProcessingMode = ProcessingMode.Remote
            ReportViewer1.ServerReport.ReportServerUrl = New System.Uri("http://myweb/SSRS")
            ReportViewer1.ServerReport.ReportPath = "/mypath"
            ReportViewer1.ShowCredentialPrompts = False
            ReportViewer1.ServerReport.ReportServerCredentials = New MyReportServerCredentials

Open in new window


I've used this code on many pages before without any issues.  I also assign about 7 different report parameters.  Since setting up a test page I've had issues printing reports.  Whenever I load a report it will print normally.  If I change one of the report parameters and then try to print the report it will always print the original report, the settings prior to the parameter change.  Doesn't matter if I click "View Report" a few times, or refresh the report.  The data on the report changed to the new parameter setting, but when I print the report it is still the original data.  

I thought it was a browser issue, or maybe the print client.  I have tried this on two different desktops, along with the actual webserver.  I've deleted the print client and re-installed it.  I even updated sql 2008 r2 with SP2 to see if that would help and it doesn't.

When I view this report in the report manager it works fine.  Looking at the print preview, the data always changes after a parameter change.  So my assumption is that there is an issue with my code for the reportviewer, or some IIS issue related to reports and printing?

Any help?  I can't seem to find anyone else with this problem...
0
Comment
Question by:jay-are
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
3 Comments
 

Author Comment

by:jay-are
ID: 39854866
I just used debug in VS2010 with my test page.  It worked fine.  So it works on the report manager and in VS debug, but not when printing from IE.

I can also export the report to pdf, excel, csv etc. with no issues.
0
 

Author Comment

by:jay-are
ID: 39857686
There must be something simple I'm doing wrong here.  Anyone?

Win server 2012
SQL 2008 R2 SP2
VS 2010

All patches done.  Works in debug and it works on the reportmanager, doesn't work on published page.
0
 

Accepted Solution

by:
jay-are earned 0 total points
ID: 39859826
I was able to resolve this issue.  Some time back I was trying to stop my clients from caching the website pages.  In my web.config I had this:

<httpProtocol>
      <customHeaders>
        <add name="Cache-Control" value="max-age=2592000;" />
      </customHeaders>
    </httpProtocol>
    <staticContent>
      <clientCache cacheControlMode="UseMaxAge" cacheControlMaxAge="30.00:00:00" />
    </staticContent>

Open in new window


This was actually causing the client browser to cache the report when it first loads.  When you click the print icon in the reportviewer it would not make a call to the server to get the current report info.  It was simply using its cached data.  Such a simple and stupid mistake on my part.

Just leaving this here in case anyone ever has this issue.  I hope others don't make these mistakes like I do!  :)
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question