pdf caching problems when being populated from SQL reporting

I have a report that runs fine with html4.0 but if you call it using a pdf the report continues to hold on to a previous copy that was opened in that session. PLease help.

mwhodgesAsked:
Who is Participating?
 
gdupadhyayConnect With a Mentor Commented:
Change the parameter always. Add timestamp as a parameter and pass current time.

Reason is: If parameters and URL is same, report manager fetch the report from cache. So try to add new parameter @TimeStame and pass to report as parameter. Don't change any thing in sql or stored procedure
0
 
planoczCommented:
If you are doing web. then place this in your load event
        Response.Buffer = True
        Response.Expires = -1442
        Response.AddHeader("cache-control", "private")
        Response.AddHeader("pragma", "no-cache")
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.