all groups > sql server reporting services > september 2005 >
You're in the

sql server reporting services

group:

HtmlFragment seems to be caching chart images


HtmlFragment seems to be caching chart images Gregor
9/28/2005 1:02:31 PM
sql server reporting services:
I'm pulling reports from rs web services to implement my own custom
security. I used the following DeviceInfo element to determine where to
render the image (i use imageRender.aspx to write the stream to an
image).

<DeviceInfo><HTMLFragment>True</HTMLFragment><StreamRoot>imageRender.aspx?imageID=</StreamRoot></DeviceInfo>

after returning the report i loop through each of the image streams as
follows:


Dim image() As Byte
For Each streamID As String In streamIDs
image = rs.RenderStream(reportPath, format, streamID, _
historyID, devInfo, proxyParameters, _
encoding, mimeType)
Session(streamID) = image
Next

That way i use store the image stream in a session variable which i can
render on imageRender.aspx.

That works great for the first char image, but it seems like the images
are cached. Each additional report shows the same chart. I tried
debugging the imagerender page to see if that is where it was cached,
but that page doesn't even execute once the first report runs. I think
is has something to do with the streamID because when I have different
chart types they produce different streamID's and they render properly
- but if i run two consecutive reports with the sam number of charts
and the same chart type (coulumn vs pie) the image gets cached.

Any suggestions?
Re: HtmlFragment seems to be caching chart images Gregor
9/28/2005 1:53:05 PM
Never mind, it was a browser caching issue.
AddThis Social Bookmark Button