Strange SSRS printing issue.

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...
jay-areAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jay-areAuthor Commented:
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
jay-areAuthor Commented:
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
jay-areAuthor Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.