Showing posts with label images. Show all posts
Showing posts with label images. Show all posts

Wednesday, March 28, 2012

images, stream ids, etc

ok, I have finally made my mind about how I will be doing the displaying
images in my site when I am using soap access ... here is the thread I posted
before:
http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=9888dd27-6e44-4c0d-8293-4d3a6ae93860&mid=e8ede148-3266-4bd0-ba1c-4f65f4197643
as long as I understand stream ids are unique, so the way I am doing this is
as follows:
1) I have an aspx page to render my reports
2) I have a grid to display the parameters, which definition I grab
dinamically trough soap access ... which gives me nice things, like types,
valid values (which are translated to dropdownlists:P), default values,
dependencies, etc ...
3) Once the user clicks the view report button (there are others, as export,
...) and the parameters have been validated I get the report from Reporting
Services, indicating that the streamroot is a special page I will have to
display images, indicating in the query string the parameters values and
related stuff selected by the user ...
4) As I said I will have a page to display the images. Right at the moment
the user is accesing this page, it will make the call to the reporting
services, thus I wont be having the need to handle saving the images and then
deleting them.
5) I dont want that page to be asking for an image it has already handled,
which might in turn be an image that appears in the very same report several
times ... In order to do this I will be turning asp.net cache on in that
page, so asp.net will handle saving it temporarily ...
The Question:
Does that way of handling the image is good enough when talking about
performance? ...
in the mean time, I will be doing that image page, and testing all this ...
I would highly apreciate any comments on this ...Eglasius,
Did you have success with this? I have done nearly the exact same thing,
but have found a couple of problems with chart images.
I first wanted (and prefer) to allow the client browser to cache the entire
page so that as they drill through the report charts, they can easily go back
by using the browser's back button -- requiring no return to the server.
However, I found that the streamIDs are NOT unique in some cases. For
example, I have a pie chart that with one set of data has a stream id of
C_21_S. The user drills through this chart and the chart is now rendered
using different data which obviously produces a different looking chart.
BUT! -- the stream id is still C_21_S! The browser of course cached the last
version of the image so the report renders with the wrong chart.
I considered a couple of options:
1) Adding something unique to the streamroot in addition to the
not-so-unique streamid. Then, the client browser would consider the image
url unique even if the streamid is not. I guess I would have to generate a
guid to use in the stream root. Perhasps something like this:
"<StreamRoot>/Reports/Report/ImgProxy.aspx?guid=" & GetGuid()&
"&imageid=</StreamRoot>"
2) Second option would be to send HTTP headers to prevent caching of just
the image elements -- I think this is possible, but wanted to avoid it.
Thoughts anyone?
"eglasius" wrote:
> ok, I have finally made my mind about how I will be doing the displaying
> images in my site when I am using soap access ... here is the thread I posted
> before:
> http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=9888dd27-6e44-4c0d-8293-4d3a6ae93860&mid=e8ede148-3266-4bd0-ba1c-4f65f4197643
> as long as I understand stream ids are unique, so the way I am doing this is
> as follows:
> 1) I have an aspx page to render my reports
> 2) I have a grid to display the parameters, which definition I grab
> dinamically trough soap access ... which gives me nice things, like types,
> valid values (which are translated to dropdownlists:P), default values,
> dependencies, etc ...
> 3) Once the user clicks the view report button (there are others, as export,
> ...) and the parameters have been validated I get the report from Reporting
> Services, indicating that the streamroot is a special page I will have to
> display images, indicating in the query string the parameters values and
> related stuff selected by the user ...
> 4) As I said I will have a page to display the images. Right at the moment
> the user is accesing this page, it will make the call to the reporting
> services, thus I wont be having the need to handle saving the images and then
> deleting them.
> 5) I dont want that page to be asking for an image it has already handled,
> which might in turn be an image that appears in the very same report several
> times ... In order to do this I will be turning asp.net cache on in that
> page, so asp.net will handle saving it temporarily ...
> The Question:
> Does that way of handling the image is good enough when talking about
> performance? ...
> in the mean time, I will be doing that image page, and testing all this ...
> I would highly apreciate any comments on this ...|||Well, my case was a very particular one, since I wasnt using dynamic images
(it was a static logo) yet, but I did want the image to be grabbed from the
report. The solution I used also needed to be compatible in case I were to
use dynamic images.
The thing is so far it has worked well, but we are using any dynamic image.
Because of this, I have no clue if I would experience the very same problem
that is happening to you.
On the other hand, I do have to say that at the end I didn't have to turn
asp.net cache on for the image served, since the browser seems to ask for the
image only once regardless of configuration (what I was worried about was a
browser with the "every visit to the page" configuration turned on asking for
a 20 pages report and ending up getting the image 20 times, which at the end
didn't happen).
In your case I would check if the drilled down page is actually being asked
to asp.net (or it is coming from the cache), and if not using a guid sounds
reasonable. If you have any other "unique" value (that relates to drilling
down) you are already using at hand, you might as well use that one instead.
One thing that really grabbed my attention, is that you aren't including
which report or params in the stream root. Unless your report doesn't have
parameters, all of them are fixed or your are saving them in some middle
object, I don't seem to understand how your are doing it.
I say so, because of this:
reports.RenderStream(report, format, streamId, null, deviceInfo, parms, out
encoding, out mimeType);
when getting the image one sends the report + streamId+parms.
"David Swanson" wrote:
> Eglasius,
> Did you have success with this? I have done nearly the exact same thing,
> but have found a couple of problems with chart images.
> I first wanted (and prefer) to allow the client browser to cache the entire
> page so that as they drill through the report charts, they can easily go back
> by using the browser's back button -- requiring no return to the server.
> However, I found that the streamIDs are NOT unique in some cases. For
> example, I have a pie chart that with one set of data has a stream id of
> C_21_S. The user drills through this chart and the chart is now rendered
> using different data which obviously produces a different looking chart.
> BUT! -- the stream id is still C_21_S! The browser of course cached the last
> version of the image so the report renders with the wrong chart.
> I considered a couple of options:
> 1) Adding something unique to the streamroot in addition to the
> not-so-unique streamid. Then, the client browser would consider the image
> url unique even if the streamid is not. I guess I would have to generate a
> guid to use in the stream root. Perhasps something like this:
> "<StreamRoot>/Reports/Report/ImgProxy.aspx?guid=" & GetGuid()&
> "&imageid=</StreamRoot>"
> 2) Second option would be to send HTTP headers to prevent caching of just
> the image elements -- I think this is possible, but wanted to avoid it.
> Thoughts anyone?
> "eglasius" wrote:
> > ok, I have finally made my mind about how I will be doing the displaying
> > images in my site when I am using soap access ... here is the thread I posted
> > before:
> > http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=9888dd27-6e44-4c0d-8293-4d3a6ae93860&mid=e8ede148-3266-4bd0-ba1c-4f65f4197643
> >
> > as long as I understand stream ids are unique, so the way I am doing this is
> > as follows:
> > 1) I have an aspx page to render my reports
> > 2) I have a grid to display the parameters, which definition I grab
> > dinamically trough soap access ... which gives me nice things, like types,
> > valid values (which are translated to dropdownlists:P), default values,
> > dependencies, etc ...
> > 3) Once the user clicks the view report button (there are others, as export,
> > ...) and the parameters have been validated I get the report from Reporting
> > Services, indicating that the streamroot is a special page I will have to
> > display images, indicating in the query string the parameters values and
> > related stuff selected by the user ...
> > 4) As I said I will have a page to display the images. Right at the moment
> > the user is accesing this page, it will make the call to the reporting
> > services, thus I wont be having the need to handle saving the images and then
> > deleting them.
> > 5) I dont want that page to be asking for an image it has already handled,
> > which might in turn be an image that appears in the very same report several
> > times ... In order to do this I will be turning asp.net cache on in that
> > page, so asp.net will handle saving it temporarily ...
> >
> > The Question:
> > Does that way of handling the image is good enough when talking about
> > performance? ...
> >
> > in the mean time, I will be doing that image page, and testing all this ...
> > I would highly apreciate any comments on this ...|||Thanks for your prompt reply!
Yes, I was being lazy and store the report params in the user session. We
have a boat load of params that are used in a custom DPE and it was a
headache to format them all on the querystring, so I just keep the params
collection in the session and the imageproxy page gets it from there.
Unless someone from the MS team has a better idea, I think I will have to
include a guid. The other really odd thing is that the report has a pie
chart and a stacked bar chart. The pie chart always seems to use the same
stream id, but the stacked bar chart has always created a unique id --so far.
Can anyone from the MS Reporting Services team explain the behavior of how
the streamids are generated for the dynamic images produced by the chart
objects?
Much appreciated, David
"eglasius" wrote:
> Well, my case was a very particular one, since I wasnt using dynamic images
> (it was a static logo) yet, but I did want the image to be grabbed from the
> report. The solution I used also needed to be compatible in case I were to
> use dynamic images.
> The thing is so far it has worked well, but we are using any dynamic image.
> Because of this, I have no clue if I would experience the very same problem
> that is happening to you.
> On the other hand, I do have to say that at the end I didn't have to turn
> asp.net cache on for the image served, since the browser seems to ask for the
> image only once regardless of configuration (what I was worried about was a
> browser with the "every visit to the page" configuration turned on asking for
> a 20 pages report and ending up getting the image 20 times, which at the end
> didn't happen).
> In your case I would check if the drilled down page is actually being asked
> to asp.net (or it is coming from the cache), and if not using a guid sounds
> reasonable. If you have any other "unique" value (that relates to drilling
> down) you are already using at hand, you might as well use that one instead.
> One thing that really grabbed my attention, is that you aren't including
> which report or params in the stream root. Unless your report doesn't have
> parameters, all of them are fixed or your are saving them in some middle
> object, I don't seem to understand how your are doing it.
> I say so, because of this:
> reports.RenderStream(report, format, streamId, null, deviceInfo, parms, out
> encoding, out mimeType);
> when getting the image one sends the report + streamId+parms.
> "David Swanson" wrote:
> > Eglasius,
> >
> > Did you have success with this? I have done nearly the exact same thing,
> > but have found a couple of problems with chart images.
> >
> > I first wanted (and prefer) to allow the client browser to cache the entire
> > page so that as they drill through the report charts, they can easily go back
> > by using the browser's back button -- requiring no return to the server.
> >
> > However, I found that the streamIDs are NOT unique in some cases. For
> > example, I have a pie chart that with one set of data has a stream id of
> > C_21_S. The user drills through this chart and the chart is now rendered
> > using different data which obviously produces a different looking chart.
> > BUT! -- the stream id is still C_21_S! The browser of course cached the last
> > version of the image so the report renders with the wrong chart.
> >
> > I considered a couple of options:
> >
> > 1) Adding something unique to the streamroot in addition to the
> > not-so-unique streamid. Then, the client browser would consider the image
> > url unique even if the streamid is not. I guess I would have to generate a
> > guid to use in the stream root. Perhasps something like this:
> >
> > "<StreamRoot>/Reports/Report/ImgProxy.aspx?guid=" & GetGuid()&
> > "&imageid=</StreamRoot>"
> >
> > 2) Second option would be to send HTTP headers to prevent caching of just
> > the image elements -- I think this is possible, but wanted to avoid it.
> >
> > Thoughts anyone?
> >
> > "eglasius" wrote:
> >
> > > ok, I have finally made my mind about how I will be doing the displaying
> > > images in my site when I am using soap access ... here is the thread I posted
> > > before:
> > > http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=9888dd27-6e44-4c0d-8293-4d3a6ae93860&mid=e8ede148-3266-4bd0-ba1c-4f65f4197643
> > >
> > > as long as I understand stream ids are unique, so the way I am doing this is
> > > as follows:
> > > 1) I have an aspx page to render my reports
> > > 2) I have a grid to display the parameters, which definition I grab
> > > dinamically trough soap access ... which gives me nice things, like types,
> > > valid values (which are translated to dropdownlists:P), default values,
> > > dependencies, etc ...
> > > 3) Once the user clicks the view report button (there are others, as export,
> > > ...) and the parameters have been validated I get the report from Reporting
> > > Services, indicating that the streamroot is a special page I will have to
> > > display images, indicating in the query string the parameters values and
> > > related stuff selected by the user ...
> > > 4) As I said I will have a page to display the images. Right at the moment
> > > the user is accesing this page, it will make the call to the reporting
> > > services, thus I wont be having the need to handle saving the images and then
> > > deleting them.
> > > 5) I dont want that page to be asking for an image it has already handled,
> > > which might in turn be an image that appears in the very same report several
> > > times ... In order to do this I will be turning asp.net cache on in that
> > > page, so asp.net will handle saving it temporarily ...
> > >
> > > The Question:
> > > Does that way of handling the image is good enough when talking about
> > > performance? ...
> > >
> > > in the mean time, I will be doing that image page, and testing all this ...
> > > I would highly apreciate any comments on this ...|||FYI: I did add a guid and it works perfectly now. I still would like MS to
explain to the newsgroup how streamids are created and why they would not be
unique for a dynamic chart image. Seems like a bug to me.
"David Swanson" wrote:
> Thanks for your prompt reply!
> Yes, I was being lazy and store the report params in the user session. We
> have a boat load of params that are used in a custom DPE and it was a
> headache to format them all on the querystring, so I just keep the params
> collection in the session and the imageproxy page gets it from there.
> Unless someone from the MS team has a better idea, I think I will have to
> include a guid. The other really odd thing is that the report has a pie
> chart and a stacked bar chart. The pie chart always seems to use the same
> stream id, but the stacked bar chart has always created a unique id --so far.
>
> Can anyone from the MS Reporting Services team explain the behavior of how
> the streamids are generated for the dynamic images produced by the chart
> objects?
> Much appreciated, David
> "eglasius" wrote:
> > Well, my case was a very particular one, since I wasnt using dynamic images
> > (it was a static logo) yet, but I did want the image to be grabbed from the
> > report. The solution I used also needed to be compatible in case I were to
> > use dynamic images.
> >
> > The thing is so far it has worked well, but we are using any dynamic image.
> > Because of this, I have no clue if I would experience the very same problem
> > that is happening to you.
> >
> > On the other hand, I do have to say that at the end I didn't have to turn
> > asp.net cache on for the image served, since the browser seems to ask for the
> > image only once regardless of configuration (what I was worried about was a
> > browser with the "every visit to the page" configuration turned on asking for
> > a 20 pages report and ending up getting the image 20 times, which at the end
> > didn't happen).
> >
> > In your case I would check if the drilled down page is actually being asked
> > to asp.net (or it is coming from the cache), and if not using a guid sounds
> > reasonable. If you have any other "unique" value (that relates to drilling
> > down) you are already using at hand, you might as well use that one instead.
> >
> > One thing that really grabbed my attention, is that you aren't including
> > which report or params in the stream root. Unless your report doesn't have
> > parameters, all of them are fixed or your are saving them in some middle
> > object, I don't seem to understand how your are doing it.
> > I say so, because of this:
> > reports.RenderStream(report, format, streamId, null, deviceInfo, parms, out
> > encoding, out mimeType);
> > when getting the image one sends the report + streamId+parms.
> >
> > "David Swanson" wrote:
> >
> > > Eglasius,
> > >
> > > Did you have success with this? I have done nearly the exact same thing,
> > > but have found a couple of problems with chart images.
> > >
> > > I first wanted (and prefer) to allow the client browser to cache the entire
> > > page so that as they drill through the report charts, they can easily go back
> > > by using the browser's back button -- requiring no return to the server.
> > >
> > > However, I found that the streamIDs are NOT unique in some cases. For
> > > example, I have a pie chart that with one set of data has a stream id of
> > > C_21_S. The user drills through this chart and the chart is now rendered
> > > using different data which obviously produces a different looking chart.
> > > BUT! -- the stream id is still C_21_S! The browser of course cached the last
> > > version of the image so the report renders with the wrong chart.
> > >
> > > I considered a couple of options:
> > >
> > > 1) Adding something unique to the streamroot in addition to the
> > > not-so-unique streamid. Then, the client browser would consider the image
> > > url unique even if the streamid is not. I guess I would have to generate a
> > > guid to use in the stream root. Perhasps something like this:
> > >
> > > "<StreamRoot>/Reports/Report/ImgProxy.aspx?guid=" & GetGuid()&
> > > "&imageid=</StreamRoot>"
> > >
> > > 2) Second option would be to send HTTP headers to prevent caching of just
> > > the image elements -- I think this is possible, but wanted to avoid it.
> > >
> > > Thoughts anyone?
> > >
> > > "eglasius" wrote:
> > >
> > > > ok, I have finally made my mind about how I will be doing the displaying
> > > > images in my site when I am using soap access ... here is the thread I posted
> > > > before:
> > > > http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=9888dd27-6e44-4c0d-8293-4d3a6ae93860&mid=e8ede148-3266-4bd0-ba1c-4f65f4197643
> > > >
> > > > as long as I understand stream ids are unique, so the way I am doing this is
> > > > as follows:
> > > > 1) I have an aspx page to render my reports
> > > > 2) I have a grid to display the parameters, which definition I grab
> > > > dinamically trough soap access ... which gives me nice things, like types,
> > > > valid values (which are translated to dropdownlists:P), default values,
> > > > dependencies, etc ...
> > > > 3) Once the user clicks the view report button (there are others, as export,
> > > > ...) and the parameters have been validated I get the report from Reporting
> > > > Services, indicating that the streamroot is a special page I will have to
> > > > display images, indicating in the query string the parameters values and
> > > > related stuff selected by the user ...
> > > > 4) As I said I will have a page to display the images. Right at the moment
> > > > the user is accesing this page, it will make the call to the reporting
> > > > services, thus I wont be having the need to handle saving the images and then
> > > > deleting them.
> > > > 5) I dont want that page to be asking for an image it has already handled,
> > > > which might in turn be an image that appears in the very same report several
> > > > times ... In order to do this I will be turning asp.net cache on in that
> > > > page, so asp.net will handle saving it temporarily ...
> > > >
> > > > The Question:
> > > > Does that way of handling the image is good enough when talking about
> > > > performance? ...
> > > >
> > > > in the mean time, I will be doing that image page, and testing all this ...
> > > > I would highly apreciate any comments on this ...|||> > Yes, I was being lazy and store the report params in the user session. We
> > have a boat load of params that are used in a custom DPE and it was a
> > headache to format them all on the querystring, so I just keep the params
> > collection in the session and the imageproxy page gets it from there.
As long as the user doesn't open different reports at the same time (it
hardly should happen ...) and you don't have an incredibly large amount of
users, it is ok :)
I also wan't to know if it is a bug or a behavior by design (and why) ...
"David Swanson" wrote:
> FYI: I did add a guid and it works perfectly now. I still would like MS to
> explain to the newsgroup how streamids are created and why they would not be
> unique for a dynamic chart image. Seems like a bug to me.
> "David Swanson" wrote:
> > Thanks for your prompt reply!
> >
> > Yes, I was being lazy and store the report params in the user session. We
> > have a boat load of params that are used in a custom DPE and it was a
> > headache to format them all on the querystring, so I just keep the params
> > collection in the session and the imageproxy page gets it from there.
> >
> > Unless someone from the MS team has a better idea, I think I will have to
> > include a guid. The other really odd thing is that the report has a pie
> > chart and a stacked bar chart. The pie chart always seems to use the same
> > stream id, but the stacked bar chart has always created a unique id --so far.
> >
> >
> > Can anyone from the MS Reporting Services team explain the behavior of how
> > the streamids are generated for the dynamic images produced by the chart
> > objects?
> >
> > Much appreciated, David
> >
> > "eglasius" wrote:
> >
> > > Well, my case was a very particular one, since I wasnt using dynamic images
> > > (it was a static logo) yet, but I did want the image to be grabbed from the
> > > report. The solution I used also needed to be compatible in case I were to
> > > use dynamic images.
> > >
> > > The thing is so far it has worked well, but we are using any dynamic image.
> > > Because of this, I have no clue if I would experience the very same problem
> > > that is happening to you.
> > >
> > > On the other hand, I do have to say that at the end I didn't have to turn
> > > asp.net cache on for the image served, since the browser seems to ask for the
> > > image only once regardless of configuration (what I was worried about was a
> > > browser with the "every visit to the page" configuration turned on asking for
> > > a 20 pages report and ending up getting the image 20 times, which at the end
> > > didn't happen).
> > >
> > > In your case I would check if the drilled down page is actually being asked
> > > to asp.net (or it is coming from the cache), and if not using a guid sounds
> > > reasonable. If you have any other "unique" value (that relates to drilling
> > > down) you are already using at hand, you might as well use that one instead.
> > >
> > > One thing that really grabbed my attention, is that you aren't including
> > > which report or params in the stream root. Unless your report doesn't have
> > > parameters, all of them are fixed or your are saving them in some middle
> > > object, I don't seem to understand how your are doing it.
> > > I say so, because of this:
> > > reports.RenderStream(report, format, streamId, null, deviceInfo, parms, out
> > > encoding, out mimeType);
> > > when getting the image one sends the report + streamId+parms.
> > >
> > > "David Swanson" wrote:
> > >
> > > > Eglasius,
> > > >
> > > > Did you have success with this? I have done nearly the exact same thing,
> > > > but have found a couple of problems with chart images.
> > > >
> > > > I first wanted (and prefer) to allow the client browser to cache the entire
> > > > page so that as they drill through the report charts, they can easily go back
> > > > by using the browser's back button -- requiring no return to the server.
> > > >
> > > > However, I found that the streamIDs are NOT unique in some cases. For
> > > > example, I have a pie chart that with one set of data has a stream id of
> > > > C_21_S. The user drills through this chart and the chart is now rendered
> > > > using different data which obviously produces a different looking chart.
> > > > BUT! -- the stream id is still C_21_S! The browser of course cached the last
> > > > version of the image so the report renders with the wrong chart.
> > > >
> > > > I considered a couple of options:
> > > >
> > > > 1) Adding something unique to the streamroot in addition to the
> > > > not-so-unique streamid. Then, the client browser would consider the image
> > > > url unique even if the streamid is not. I guess I would have to generate a
> > > > guid to use in the stream root. Perhasps something like this:
> > > >
> > > > "<StreamRoot>/Reports/Report/ImgProxy.aspx?guid=" & GetGuid()&
> > > > "&imageid=</StreamRoot>"
> > > >
> > > > 2) Second option would be to send HTTP headers to prevent caching of just
> > > > the image elements -- I think this is possible, but wanted to avoid it.
> > > >
> > > > Thoughts anyone?
> > > >
> > > > "eglasius" wrote:
> > > >
> > > > > ok, I have finally made my mind about how I will be doing the displaying
> > > > > images in my site when I am using soap access ... here is the thread I posted
> > > > > before:
> > > > > http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=9888dd27-6e44-4c0d-8293-4d3a6ae93860&mid=e8ede148-3266-4bd0-ba1c-4f65f4197643
> > > > >
> > > > > as long as I understand stream ids are unique, so the way I am doing this is
> > > > > as follows:
> > > > > 1) I have an aspx page to render my reports
> > > > > 2) I have a grid to display the parameters, which definition I grab
> > > > > dinamically trough soap access ... which gives me nice things, like types,
> > > > > valid values (which are translated to dropdownlists:P), default values,
> > > > > dependencies, etc ...
> > > > > 3) Once the user clicks the view report button (there are others, as export,
> > > > > ...) and the parameters have been validated I get the report from Reporting
> > > > > Services, indicating that the streamroot is a special page I will have to
> > > > > display images, indicating in the query string the parameters values and
> > > > > related stuff selected by the user ...
> > > > > 4) As I said I will have a page to display the images. Right at the moment
> > > > > the user is accesing this page, it will make the call to the reporting
> > > > > services, thus I wont be having the need to handle saving the images and then
> > > > > deleting them.
> > > > > 5) I dont want that page to be asking for an image it has already handled,
> > > > > which might in turn be an image that appears in the very same report several
> > > > > times ... In order to do this I will be turning asp.net cache on in that
> > > > > page, so asp.net will handle saving it temporarily ...
> > > > >
> > > > > The Question:
> > > > > Does that way of handling the image is good enough when talking about
> > > > > performance? ...
> > > > >
> > > > > in the mean time, I will be doing that image page, and testing all this ...
> > > > > I would highly apreciate any comments on this ...|||thanks you guys!.. I have been having a similar problem.
Recently we went live with reporting services. We are showing some charts,
and everything works fine the first time you show a chart. Subsequent charts
all show the image from the first chart. Hitting ctrl-R gets rid of the
problem, but this is undesirable (users would be confused). I took your idea
about slapping a GUID of some sort to the streamroot so that each request the
browser gets the image from the server.
Thanks again you guys!
Happy new years!

Images will not show in report

I am trying to add a Company Logo image to my report and it will not render.
I have tried to add it all three ways, but still no luck. Is there something
that I am missing?
I can see the image when I preview the report locally, but when I deploy the
report to the sever, I cannot view the image either from the Report Server or
through my .NET application that is utilizing the report.
Any help would be greatly appreciated.You can try making it an embedded image.
Add the image as a new embedded image to the report. (Reports\Images)
Then, design your report by adding an image to it from the toolbox.
Set the properties for that image to point to the embedded image you added.
You can make it an linked image by setting the properties to point to a
path. http://myserver/myimageshare/myimage.jpg
--
| Thread-Topic: Images will not show in report
| thread-index: AcWC+zNf2GzxbBXnQVO+cfwpRtcPTg==| X-WBNR-Posting-Host: 69.213.32.34
| From: "=?Utf-8?B?RXJpYyBHbmFnZXk=?=" <Eric
Gnagey@.discussions.microsoft.com>
| Subject: Images will not show in report
| Date: Thu, 7 Jul 2005 06:53:06 -0700
| Lines: 9
| Message-ID: <3EBB5FE6-34BE-4211-BA22-5003727008B2@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:47590
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I am trying to add a Company Logo image to my report and it will not
render.
| I have tried to add it all three ways, but still no luck. Is there
something
| that I am missing?
|
| I can see the image when I preview the report locally, but when I deploy
the
| report to the sever, I cannot view the image either from the Report
Server or
| through my .NET application that is utilizing the report.
|
| Any help would be greatly appreciated.
|sql

Images rendering poorly?

Has anyone else out there had any problems with images rendering improperly
in the reports? When I add our company logo (a gif) to a report, it looks
fine in the development environment. Also, when I export the reports (say,
to a pdf) the images are fine, but when I view the report in a browser
(through the reporting services) the image is slightly skewed. Has anyone
else run across this, and if so, any idea on how to fix this?
Thanks for any help offered.Yes Hammer I have also had this problem for some time now. I have tried all
forms of image input into the report (embedded, project, database, and web)
and all have the same results; a lower quality image.
Anyone else?
"The Hammer" <david.hamilton@.datashapers.com> wrote in message
news:OCHYNpw1EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Has anyone else out there had any problems with images rendering
> improperly
> in the reports? When I add our company logo (a gif) to a report, it looks
> fine in the development environment. Also, when I export the reports (say,
> to a pdf) the images are fine, but when I view the report in a browser
> (through the reporting services) the image is slightly skewed. Has anyone
> else run across this, and if so, any idea on how to fix this?
> Thanks for any help offered.
>

Images on a report

I am trying to put an image behind a textbox. It's one of those rounded rectangles and the effect I'm after is that the text looks like it is inside a nice rectangle graphic. It looks fine in preview mode, but when I deploy the report the text is below the image and not 'inside' it.
What am I doing wrong?
Thanks

dear,

What is the source of the image.

I mean from database,or web or Disk.

HTH

from

sufian

|||The image is embedded into the report - it resides on the disk of the server.
I've got round the problem to an extent by making a textbox, typing the text and then setting a background image that is exactly the same size as the textbox, but if you get the textbox slightly too big or small, it either cuts a bit off or repeats (I could switch off the repeat I s'pose).|||

Dear,

Set the backgroundrepeat option to norepeat.

HTH

from

sufian

Images on a report

Hi being new to reporting services this is probably simple, so here goes.

Using Visual Studio 2005 to create the report. I have a SQLExpress db.

In the Product table that I want to run the report on there is a field called ImageName it contains the image filename e.g CanonIXUS.jpg

and I have a directory with all the images in it.

So how do I get the report writer to show the Image for the product in the row?

Thanks

Please check the documentation:
http://msdn2.microsoft.com/en-us/library/ms156482(SQL.90).aspx

In your case, it sounds like you want to add an "external" image where you will need to dynamically construct the path with an expression.

-- Robert

|||

Hi,

Thanks for that.

However all the documentation talks of an image wizard and various properties when you drag an image control onto a report.

Unfortunatly after adding a report (test.rdlc) to my VS2005 project none of these options seem to be available to me. I can easily display data but I don't have a place to select the various properties for an image eg. "external" .

Any Ideas ?

|||

You can use the VS property browser to set the image properties. To set the source of an image to "external", select the image, go to the Properties window and locate the Source property.

-Albert

Images on a report

Hi being new to reporting services this is probably simple, so here goes.

Using Visual Studio 2005 to create the report. I have a SQLExpress db.

In the Product table that I want to run the report on there is a field called ImageName it contains the image filename e.g CanonIXUS.jpg

and I have a directory with all the images in it.

So how do I get the report writer to show the Image for the product in the row?

Thanks

Please check the documentation:
http://msdn2.microsoft.com/en-us/library/ms156482(SQL.90).aspx

In your case, it sounds like you want to add an "external" image where you will need to dynamically construct the path with an expression.

-- Robert

|||

Hi,

Thanks for that.

However all the documentation talks of an image wizard and various properties when you drag an image control onto a report.

Unfortunatly after adding a report (test.rdlc) to my VS2005 project none of these options seem to be available to me. I can easily display data but I don't have a place to select the various properties for an image eg. "external" .

Any Ideas ?

|||

You can use the VS property browser to set the image properties. To set the source of an image to "external", select the image, go to the Properties window and locate the Source property.

-Albert

sql

images not showing up on server

I am serving up reports using the web service using the render method.
The reports have images on them. The following scenarios work
.Net application and Reporting Services are all on the same
workstation. Images show up and everything works well.
.Net application on same workstation and I point to Reporting Services
which is on Test environment server A. Images show up and everthing
works well.
This is not working
.Net application is on server B and Reporting Services is on the same
server A. The report shows up but all images show up with the red x.
What can be different between the code on my local workstation and the
code on the server? I have copied all the neccessary files out there.
Is there something on my workstation which has Visual Studio installed
that is not on the server B which only has IIS installed? Or is there
something else I could be missing in the migration to the server
environment?We have found that the report comes up just fine in the server
environment but the image is using different credentials than the user
that is logged in. If we run impersonate as user ABC, all reports come
up fine under ABC, but the image prompts a login box. The image wants
to load under the users that logged in and not the user we use to
impersonate. Any thoughts on how to get around this?

Images not lining up with text box

In several of my reports, within the header, I use a small, square, image as a navigation widget to drill through to a related report. Within VS, the report displays fine in both the layout and preview windows; the image is in complete alignment with the textbox on both the right and bottom edge. When I open the report in IE, the right edge remains in perfect alignment, but the bottom edge is 1px higher than the textbox to the left. I have assigned both the textbox and the image a 1pt border and the images are not overlapped. Is it possible to make the textbox line up with the navigation widget on the bottom, or will I need to come up with some workaround. Thanks

This is a poorly done illustration of how my header is laid out, as my description may be a bit confusing.
__
|TEXTBOX (Report title) |
|TEXTBOX (Widget caption) | Image|

Thanks
|||

Hey Dude,

Dunno if you have found a fix for this but i found using rectangles a huge help in aligning multi text boxes... maybe the same can help here

Stephen

Images not lining up with text box

In several of my reports, within the header, I use a small, square, image as a navigation widget to drill through to a related report. Within VS, the report displays fine in both the layout and preview windows; the image is in complete alignment with the textbox on both the right and bottom edge. When I open the report in IE, the right edge remains in perfect alignment, but the bottom edge is 1px higher than the textbox to the left. I have assigned both the textbox and the image a 1pt border and the images are not overlapped. Is it possible to make the textbox line up with the navigation widget on the bottom, or will I need to come up with some workaround. Thanks

This is a poorly done illustration of how my header is laid out, as my description may be a bit confusing.
__
|TEXTBOX (Report title) |
|TEXTBOX (Widget caption) | Image|

Thanks
|||

Hey Dude,

Dunno if you have found a fix for this but i found using rectangles a huge help in aligning multi text boxes... maybe the same can help here

Stephen

images not lined up

hi all
i have a large image in the header of the report but when
i deploy a report to the report server the images and
words in the header of the report are not lined up with
the rest of the report i have smaller images in the
footer of the report that line up fine any ideas on this?
thanks in advance
jeremyYou may have overlapping report items. This is only supported in image
oriented output formats (e.g. Preview, TIFF, PDF), but not in HTML.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"jeremy" <anonymous@.discussions.microsoft.com> wrote in message
news:0a1e01c499a6$cafd3830$3501280a@.phx.gbl...
> hi all
> i have a large image in the header of the report but when
> i deploy a report to the report server the images and
> words in the header of the report are not lined up with
> the rest of the report i have smaller images in the
> footer of the report that line up fine any ideas on this?
> thanks in advance
> jeremy|||If you use a drillthrough action, then just specifying the report name and
parameters is sufficient.
See also:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSUIREF/htm/f1_rsc_designer_v1_34fi.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"jeremy" <jeremy@.discussions.microsoft.com> wrote in message
news:48FE0851-F250-46A3-B54D-DC2471B47167@.microsoft.com...
> thanks for your help
> the images were overlapping and once i changed that the reports look fine
> now im having a problem where im navigating from one report to another
> the second report does not load on the report server do i have to set
the
> link to the url or am i missing something with the link to the other
report
> "Robert Bruckner [MSFT]" wrote:
> > You may have overlapping report items. This is only supported in image
> > oriented output formats (e.g. Preview, TIFF, PDF), but not in HTML.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "jeremy" <anonymous@.discussions.microsoft.com> wrote in message
> > news:0a1e01c499a6$cafd3830$3501280a@.phx.gbl...
> > > hi all
> > > i have a large image in the header of the report but when
> > > i deploy a report to the report server the images and
> > > words in the header of the report are not lined up with
> > > the rest of the report i have smaller images in the
> > > footer of the report that line up fine any ideas on this?
> > > thanks in advance
> > > jeremy
> >
> >
> >

Images not displaying on reports!

We are trying to create a Report w/ images that are stored in the SQL Server table.

These images are being copied and pasted into an ACCESS application (w/, as said above, a SQL Server back-end)....

All I get on the report is a box with a red 'X'.

(Now, I have tried the routine to remove the OLE header as suggested on other places on the Internet. While this works for the Northwind images, this is not working on our images. Which leads me to guess that the OLE Header on our images may be different than 78. But how do we know or calculate that?)..

My guess would be that some other people have encountered similar problems.

Any help will be highly appreciated.

Thanks..

Were you able to find the solution for this?

I'm encountering the same problem.

Thanks!

sql

Images not displaying

Hi,
I have images that reside in a database table on SQL server. When previewing
a report in Report Designer, the images display just fine. After uploading
the report to Report Manager, the images don't display and a red x displays.
Another issue is that the graph on the report is not displaying as well. A
red x displays instead. Again, the report previews perfectly in Report
Designer. Any suggestions?
Thanks!One more thing I forgot to mention. All drilldowns are not working either.
When you click on a drilldown, it makes the "click" sound and moves a bit to
the left. It doesn't drilldown. Again, it works just fine in Report Designer.
"clutch" wrote:
> Hi,
> I have images that reside in a database table on SQL server. When previewing
> a report in Report Designer, the images display just fine. After uploading
> the report to Report Manager, the images don't display and a red x displays.
> Another issue is that the graph on the report is not displaying as well. A
> red x displays instead. Again, the report previews perfectly in Report
> Designer. Any suggestions?
> Thanks!

Images Not Displayed On Server

Ok maybe someone here can help me with this. I have a crystal report with both static images (images dragged onto the report in the designer) and images that are pulled and inserted into the report as BLOBs.

The reports are displayed fine on my machine and on the test server we use for demo builds.

When I place a build on our remote webserver the images don't display correctly. They don't show up as red x's, but only the outline of the image and the icon specifying that the object is an image is visible. Another developer is working with the project on his machine and is experiencing the same problem.

What could be causing this? I don't think this is a permissions issue, as I have given both Everyone and IUSER full read privileges on the image directories of both problem machines.

I am running Windows XP Pro and we are using Framework V1.1. The problem machines are running windows server 2003 and windows server 2000 respectively.

Does anyone have any clue as to what the problem could be?

Thanks,

RonWhere the image files are stored? Have u tested the path is taken in a right way by ur server. (i.e, it may points to local path)|||Hmm, well the path shown when I right click and view properties of the image isn't anything that I can go check... it is an image that is dynamically generated by the report engine.

Do you know of anyway I can specify the image locations as relative, as opposed to absolute? The test server that works fine is using a directory structure identical to the one I am using, however the other two machines are slightly different.

If you know how to specify a path as relative please let me know, I really appreciate it.

Ron|||I'm not sure is this the right way?

For static images, store the image files in the folder where rpt files are located.

Goto your report, select the image from that path. It'll work will accessing from the server.

But for dynamic images? If it is dynamic, u must have specified the path somewhere in your code. right?|||No, the images are all being specified correctly... in fact, when I generate a PDF or Word document from the report the images display just fine.

I am really curious as to what could be causing this?|||Sorry, no idea

Try to search businessobjects web site. U may have some info.

Images not being displayed.

1. I am using the webservice to render the images from a report, and they dont render.

I paste this URL to the browser

http://agamenon:90/ReportServer?%2fGescomRpts%2fRPT_MediosDesarrollo&rs%3aFormat=HTML4.0&rs:ImageID=6c809239-753f-4988-abcf-231416dff0d6

and I get this

No se encuentra la secuencia. No se encuentra el identificador de secuencia proporcionado a una operación en la base de datos del servidor de informes. (rsStreamNotFound) Obtener ayuda en pantalla

This is the code

the problem is that I need to know the streamid, and to know the streamid I first have to render the report where the image is to be placed.

This is the page getimage.aspx

protected void Page_Load(object sender, EventArgs e)

{

string reportPath = Server.UrlDecode(Request["report"]);

//string streamID = Request["streamid"];

ReportExecutionService rs = (ReportExecutionService)Session["rs"];

DataSourceCredentials[] credentials = null;

string showHideToggle = null;

string encoding;

string mimeType;

string extension;

Warning[] warnings = null;

ParameterValue[] reportHistoryParameters = null;

string historyID = null;

string[] streamIDs = null;

ServerInfoHeader sh = new ServerInfoHeader();

rs.ServerInfoHeaderValue = sh;

byte[] result = null;

ParameterValue[] reportParameterValues2 = null;

string deviceInfo = "<DeviceInfo>" +

//"<StreamRoot>" + streamRoot + "</StreamRoot>" +

"<Toolbar>False</Toolbar>" +

"<Parameters>False</Parameters>" +

"<HTMLFragment>True</HTMLFragment>" +

"<StyleStream>False</StyleStream>" +

"<Section>0</Section>" +

"<Zoom>" +

"</Zoom>" +

"</DeviceInfo>";

result = rs.Render("HTML4.0", deviceInfo, out extension, out mimeType, out encoding, out warnings, out streamIDs);

string streamID = streamIDs[0];

string encodingImage;

string mimeTypeImage;

byte[] image;

ParameterValue[] pv = (ParameterValue[])Session["reportParameterValues"];

//image = rs.RenderStream(reportPath, "HTML4.0", streamID, null, null, pv, out encodingImage, out mimeTypeImage);

image=rs.RenderStream("HTML4.0", streamID, null, out encodingImage, out mimeTypeImage);

Response.Clear();

Response.ContentType = mimeTypeImage;

Response.AppendHeader("content-length", image.Length.ToString());

Response.BinaryWrite(image);

Response.Flush();

Response.Close();

}

and this is the page of the report. Sorry for the long code.

if (reportCanBeRendered)

{

string deviceInfo;

string streamRoot;

Session["rs"] = rs;

streamRoot = ("getimage.aspx?report="+ (path + "&streamid="));

switch (format)

{

case "HTML4.0":

case "HTML3.2":

deviceInfo = "<DeviceInfo>" +

"<StreamRoot></StreamRoot>" +

"<Toolbar>False</Toolbar>" +

"<Parameters>False</Parameters>" +

"<HTMLFragment>True</HTMLFragment>" +

"<StyleStream>False</StyleStream>" +

"<Section>0</Section>" +

"<Zoom>" +

"</Zoom>" +

"</DeviceInfo>";

break;

default:

deviceInfo = "<DeviceInfo></DeviceInfo>";

break;

}

// SQLRS-ReportViewer

if (!(reportParameterValues == null))

{

//reportParameterValues2 = reportParameterValues.ToArray(typeof(ParameterValue));

//reportParameterValues2 = (ParameterValue[])reportParameterValues.ToArray(typeof(ParameterValue));

}

DataSourceCredentials[] credentials = null;

string showHideToggle = null;

string encoding;

string mimeType;

string extension;

Warning[] warnings = null;

ParameterValue[] reportHistoryParameters = null;

string historyID = null;

string[] streamIDs = null;

ServerInfoHeader sh = new ServerInfoHeader();

rs.ServerInfoHeaderValue = sh;

byte[] result = null;

ParameterValue[] reportParameterValues2 = null;

result = rs.Render(format, deviceInfo, out extension, out mimeType, out encoding, out warnings, out streamIDs);

streamRoot = "getimage.aspx?report=" + path + "&amp;streamid=" + streamIDs[0];

//string reportPath2 = Server.UrlDecode(Request["report"]);

//string streamID = streamIDs[0];

////string streamID = "";

//ReportExecutionService rs2 = new ReportExecutionService();

//Session["rs"] = rs;

//rs2=(ReportExecutionService)Session["rs"];

//////ReportingService rs = (ReportingService)Session["rs"];

//string encodingImage;

//string mimeTypeImage;

//byte[] image;

//ParameterValue[] pv = (ParameterValue[])Session["reportParameterValues"];

//////image = rs.RenderStream(reportPath, "HTML4.0", streamID, null, null, pv, out encodingImage, out mimeTypeImage);

//image = rs2.RenderStream("HTML4.0", streamID, null, out encodingImage, out mimeTypeImage);

//Response.Clear();

//Response.ContentType = mimeTypeImage;

//Response.AppendHeader("content-length", image.Length.ToString());

//Response.BinaryWrite(image);

//Response.Flush();

//Response.Close();

// store ReportingServices and parameters object is session layer in case we need it for image streams

Session["rs"] = rs;

Session["reportParameterValues"] = reportParameterValues2;

switch (format)

{

case "HTML4.0":

case "HTML3.2":

System.Text.Encoding enc = System.Text.Encoding.UTF8;

// get the report as a string

string tmpReport = enc.GetString(result);

// replace all occurrences of report server link with current page link

tmpReport = tmpReport.Replace(reportServerURL.Replace("/ReportService.asmx", "?"), ("http://"

+ (Request["SERVER_NAME"]

+ (Request["SCRIPT_NAME"] + "?Report="))));

ReportPlaceholder.InnerHtml = tmpReport;

break;

default:

Response.ClearContent();

Response.AppendHeader("content-length", result.Length.ToString());

Response.ContentType = mimeType;

Response.BinaryWrite(result);

Response.Flush();

Response.Close();

break;

}

}

I actually solved the proble, this code has a little of garbage, but it began working.

private void GenerarInPlaceHTML()

{

string path = reportPath+ "RPT_MediosDesarrollo";

ReportExecutionService rs = new ReportExecutionService();

rs.Url = reportServerURL;

System.Net.NetworkCredential reportCredentials = new System.Net.NetworkCredential(reportUser, userPassword, domain);

rs.Credentials = reportCredentials;

// see if Report URL parameter is defined and if it is then consider that report

if (!(Request["Report"] == null))

{

reportPath = Request["Report"];

}

// set the Report hidden parameter

Report.Value = reportPath;

// Get the list of parameters. without specifing to render the report (ForRendering set to false)

// valid values for these parameters will not be populated

ExecutionInfo execInfo;

execInfo = rs.LoadReport(path, null);

ReportParameter[] reportParametersArray = execInfo.Parameters;

//reportParametersArray = rs.GetReportParameters(path, null, false, null, null);

//// If there are parametrs then we generate an array with values that should be populated from either

//// - previous submission ,

//// - URL parameters,

//// - default value defined inside the report

//// some usefull declarations

System.Web.UI.HtmlControls.HtmlTableRow TR = new HtmlTableRow();

System.Web.UI.HtmlControls.HtmlTableCell TD;

System.Web.UI.HtmlControls.HtmlSelect S;

System.Web.UI.WebControls.ListItem LI;

System.Web.UI.HtmlControls.HtmlInputText T;

//// hash table with dependecies

System.Collections.Hashtable Dependencies = new System.Collections.Hashtable();

//// we need a dynamic array for storing parameter values

ArrayList reportParameterValues= new ArrayList();

if (reportCanBeRendered)

{

string deviceInfo;

string streamRoot;

Session["rs"] = rs;

streamRoot = ("getimage.aspx?report="+ (path + "&streamid="));

switch (format)

{

case "HTML4.0":

case "HTML3.2":

deviceInfo = "<DeviceInfo>" +

"<StreamRoot>http://ImagenesTemporales/</StreamRoot>" +

"<Toolbar>False</Toolbar>" +

"<Parameters>False</Parameters>" +

"<HTMLFragment>True</HTMLFragment>" +

"<StyleStream>False</StyleStream>" +

"<Section>0</Section>" +

"<Zoom>" +

"</Zoom>" +

"</DeviceInfo>";

break;

default:

deviceInfo = "<DeviceInfo></DeviceInfo>";

break;

}

// SQLRS-ReportViewer

if (!(reportParameterValues == null))

{

//reportParameterValues2 = reportParameterValues.ToArray(typeof(ParameterValue));

//reportParameterValues2 = (ParameterValue[])reportParameterValues.ToArray(typeof(ParameterValue));

}

DataSourceCredentials[] credentials = null;

string showHideToggle = null;

string encoding;

string mimeType;

string extension;

Warning[] warnings = null;

ParameterValue[] reportHistoryParameters = null;

string historyID = null;

string[] streamIDs = null;

ServerInfoHeader sh = new ServerInfoHeader();

rs.ServerInfoHeaderValue = sh;

byte[] result = null;

ParameterValue[] reportParameterValues2 = null;

result = rs.Render(format, deviceInfo, out extension, out mimeType, out encoding, out warnings, out streamIDs);

string encodingImage;

string mimeTypeImage;

byte[] image = rs.RenderStream("HTML4.0", streamIDs[0], null, out encodingImage,out mimeTypeImage);

System.IO.FileStream fs = System.IO.File.OpenWrite(@."C:\Inetpub\wwwroot\GescomDllo\ImagenesTemporales\" + streamIDs[0]);

fs.Write(image, 0, Convert.ToInt32(image.Length));

fs.Close();

// store ReportingServices and parameters object is session layer in case we need it for image streams

Session["rs"] = rs;

Session["reportParameterValues"] = reportParameterValues2;

switch (format)

{

case "HTML4.0":

case "HTML3.2":

System.Text.Encoding enc = System.Text.Encoding.UTF8;

// get the report as a string

string tmpReport = enc.GetString(result);

// replace all occurrences of report server link with current page link

tmpReport = tmpReport.Replace(reportServerURL.Replace("/ReportService.asmx", "?"), ("http://"

+ (Request["SERVER_NAME"]

+ (Request["SCRIPT_NAME"] + "?Report="))));

ReportPlaceholder.InnerHtml = tmpReport;

break;

default:

Response.ClearContent();

Response.AppendHeader("content-length", result.Length.ToString());

Response.ContentType = mimeType;

Response.BinaryWrite(result);

Response.Flush();

Response.Close();

break;

}

}

}

|||

Thanks buddy!!!

you answer helped me, though it was tough to figure out what i was doing wrong previosly. the only mistake i was doing is here .

it should be this.

image=rs.RenderStream("HTML4.0", streamID, null, out encodingImage, out mimeTypeImage);

i was doing this.

image=rs.RenderStream("IMAGE", streamID, null, out encodingImage, out mimeTypeImage);

Thanks again

|||

Luis Esteban, tendras ese mismo codigo pero para reporting services 2000?

Saludos

Images not being displayed.

1. I am using the webservice to render the images from a report, and they dont render.

I paste this URL to the browser

http://agamenon:90/ReportServer?%2fGescomRpts%2fRPT_MediosDesarrollo&rs%3aFormat=HTML4.0&rs:ImageID=6c809239-753f-4988-abcf-231416dff0d6

and I get this

No se encuentra la secuencia. No se encuentra el identificador de secuencia proporcionado a una operación en la base de datos del servidor de informes. (rsStreamNotFound) Obtener ayuda en pantalla

This is the code

the problem is that I need to know the streamid, and to know the streamid I first have to render the report where the image is to be placed.

This is the page getimage.aspx

protectedvoid Page_Load(object sender, EventArgs e)

{

string reportPath = Server.UrlDecode(Request["report"]);

//string streamID = Request["streamid"];

ReportExecutionService rs = (ReportExecutionService)Session["rs"];

DataSourceCredentials[] credentials = null;

string showHideToggle = null;

string encoding;

string mimeType;

string extension;

Warning[] warnings = null;

ParameterValue[] reportHistoryParameters = null;

string historyID = null;

string[] streamIDs = null;

ServerInfoHeader sh = newServerInfoHeader();

rs.ServerInfoHeaderValue = sh;

byte[] result = null;

ParameterValue[] reportParameterValues2 = null;

string deviceInfo = "<DeviceInfo>" +

//"<StreamRoot>" + streamRoot + "</StreamRoot>" +

"<Toolbar>False</Toolbar>" +

"<Parameters>False</Parameters>" +

"<HTMLFragment>True</HTMLFragment>" +

"<StyleStream>False</StyleStream>" +

"<Section>0</Section>" +

"<Zoom>" +

"</Zoom>" +

"</DeviceInfo>";

result = rs.Render("HTML4.0", deviceInfo, out extension, out mimeType, out encoding, out warnings, out streamIDs);

string streamID = streamIDs[0];

string encodingImage;

string mimeTypeImage;

byte[] image;

ParameterValue[] pv = (ParameterValue[])Session["reportParameterValues"];

//image = rs.RenderStream(reportPath, "HTML4.0", streamID, null, null, pv, out encodingImage, out mimeTypeImage);

image=rs.RenderStream("HTML4.0", streamID, null, out encodingImage, out mimeTypeImage);

Response.Clear();

Response.ContentType = mimeTypeImage;

Response.AppendHeader("content-length", image.Length.ToString());

Response.BinaryWrite(image);

Response.Flush();

Response.Close();

}

and this is the page of the report. Sorry for the long code.

if (reportCanBeRendered)

{

string deviceInfo;

string streamRoot;

Session["rs"] = rs;

streamRoot = ("getimage.aspx?report="+ (path + "&streamid="));

switch (format)

{

case"HTML4.0":

case"HTML3.2":

deviceInfo = "<DeviceInfo>" +

"<StreamRoot></StreamRoot>" +

"<Toolbar>False</Toolbar>" +

"<Parameters>False</Parameters>" +

"<HTMLFragment>True</HTMLFragment>" +

"<StyleStream>False</StyleStream>" +

"<Section>0</Section>" +

"<Zoom>" +

"</Zoom>" +

"</DeviceInfo>";

break;

default:

deviceInfo = "<DeviceInfo></DeviceInfo>";

break;

}

// SQLRS-ReportViewer

if (!(reportParameterValues == null))

{

//reportParameterValues2 = reportParameterValues.ToArray(typeof(ParameterValue));

//reportParameterValues2 = (ParameterValue[])reportParameterValues.ToArray(typeof(ParameterValue));

}

DataSourceCredentials[] credentials = null;

string showHideToggle = null;

string encoding;

string mimeType;

string extension;

Warning[] warnings = null;

ParameterValue[] reportHistoryParameters = null;

string historyID = null;

string[] streamIDs = null;

ServerInfoHeader sh = newServerInfoHeader();

rs.ServerInfoHeaderValue = sh;

byte[] result = null;

ParameterValue[] reportParameterValues2 = null;

result = rs.Render(format, deviceInfo, out extension, out mimeType, out encoding, out warnings, out streamIDs);

streamRoot = "getimage.aspx?report=" + path + "&amp;streamid=" + streamIDs[0];

//string reportPath2 = Server.UrlDecode(Request["report"]);

//string streamID = streamIDs[0];

////string streamID = "";

//ReportExecutionService rs2 = new ReportExecutionService();

//Session["rs"] = rs;

//rs2=(ReportExecutionService)Session["rs"];

//////ReportingService rs = (ReportingService)Session["rs"];

//string encodingImage;

//string mimeTypeImage;

//byte[] image;

//ParameterValue[] pv = (ParameterValue[])Session["reportParameterValues"];

//////image = rs.RenderStream(reportPath, "HTML4.0", streamID, null, null, pv, out encodingImage, out mimeTypeImage);

//image = rs2.RenderStream("HTML4.0", streamID, null, out encodingImage, out mimeTypeImage);

//Response.Clear();

//Response.ContentType = mimeTypeImage;

//Response.AppendHeader("content-length", image.Length.ToString());

//Response.BinaryWrite(image);

//Response.Flush();

//Response.Close();

// store ReportingServices and parameters object is session layer in case we need it for image streams

Session["rs"] = rs;

Session["reportParameterValues"] = reportParameterValues2;

switch (format)

{

case"HTML4.0":

case"HTML3.2":

System.Text.Encoding enc = System.Text.Encoding.UTF8;

// get the report as a string

string tmpReport = enc.GetString(result);

// replace all occurrences of report server link with current page link

tmpReport = tmpReport.Replace(reportServerURL.Replace("/ReportService.asmx", "?"), ("http://"

+ (Request["SERVER_NAME"]

+ (Request["SCRIPT_NAME"] + "?Report="))));

ReportPlaceholder.InnerHtml = tmpReport;

break;

default:

Response.ClearContent();

Response.AppendHeader("content-length", result.Length.ToString());

Response.ContentType = mimeType;

Response.BinaryWrite(result);

Response.Flush();

Response.Close();

break;

}

}

I actually solved the proble, this code has a little of garbage, but it began working.

privatevoid GenerarInPlaceHTML()

{

string path = reportPath+ "RPT_MediosDesarrollo";

ReportExecutionService rs = newReportExecutionService();

rs.Url = reportServerURL;

System.Net.NetworkCredential reportCredentials = new System.Net.NetworkCredential(reportUser, userPassword, domain);

rs.Credentials = reportCredentials;

// see if Report URL parameter is defined and if it is then consider that report

if (!(Request["Report"] == null))

{

reportPath = Request["Report"];

}

// set the Report hidden parameter

Report.Value = reportPath;

// Get the list of parameters. without specifing to render the report (ForRendering set to false)

// valid values for these parameters will not be populated

ExecutionInfo execInfo;

execInfo = rs.LoadReport(path, null);

ReportParameter[] reportParametersArray = execInfo.Parameters;

//reportParametersArray = rs.GetReportParameters(path, null, false, null, null);

//// If there are parametrs then we generate an array with values that should be populated from either

//// - previous submission ,

//// - URL parameters,

//// - default value defined inside the report

//// some usefull declarations

System.Web.UI.HtmlControls.HtmlTableRow TR = newHtmlTableRow();

System.Web.UI.HtmlControls.HtmlTableCell TD;

System.Web.UI.HtmlControls.HtmlSelect S;

System.Web.UI.WebControls.ListItem LI;

System.Web.UI.HtmlControls.HtmlInputText T;

//// hash table with dependecies

System.Collections.Hashtable Dependencies = new System.Collections.Hashtable();

//// we need a dynamic array for storing parameter values

ArrayList reportParameterValues= newArrayList();

if (reportCanBeRendered)

{

string deviceInfo;

string streamRoot;

Session["rs"] = rs;

streamRoot = ("getimage.aspx?report="+ (path + "&streamid="));

switch (format)

{

case"HTML4.0":

case"HTML3.2":

deviceInfo = "<DeviceInfo>" +

"<StreamRoot>http://ImagenesTemporales/</StreamRoot>" +

"<Toolbar>False</Toolbar>" +

"<Parameters>False</Parameters>" +

"<HTMLFragment>True</HTMLFragment>" +

"<StyleStream>False</StyleStream>" +

"<Section>0</Section>" +

"<Zoom>" +

"</Zoom>" +

"</DeviceInfo>";

break;

default:

deviceInfo = "<DeviceInfo></DeviceInfo>";

break;

}

// SQLRS-ReportViewer

if (!(reportParameterValues == null))

{

//reportParameterValues2 = reportParameterValues.ToArray(typeof(ParameterValue));

//reportParameterValues2 = (ParameterValue[])reportParameterValues.ToArray(typeof(ParameterValue));

}

DataSourceCredentials[] credentials = null;

string showHideToggle = null;

string encoding;

string mimeType;

string extension;

Warning[] warnings = null;

ParameterValue[] reportHistoryParameters = null;

string historyID = null;

string[] streamIDs = null;

ServerInfoHeader sh = newServerInfoHeader();

rs.ServerInfoHeaderValue = sh;

byte[] result = null;

ParameterValue[] reportParameterValues2 = null;

result = rs.Render(format, deviceInfo, out extension, out mimeType, out encoding, out warnings, out streamIDs);

string encodingImage;

string mimeTypeImage;

byte[] image = rs.RenderStream("HTML4.0", streamIDs[0], null, out encodingImage,out mimeTypeImage);

System.IO.FileStream fs = System.IO.File.OpenWrite(@."C:\Inetpub\wwwroot\GescomDllo\ImagenesTemporales\" + streamIDs[0]);

fs.Write(image, 0, Convert.ToInt32(image.Length));

fs.Close();

// store ReportingServices and parameters object is session layer in case we need it for image streams

Session["rs"] = rs;

Session["reportParameterValues"] = reportParameterValues2;

switch (format)

{

case"HTML4.0":

case"HTML3.2":

System.Text.Encoding enc = System.Text.Encoding.UTF8;

// get the report as a string

string tmpReport = enc.GetString(result);

// replace all occurrences of report server link with current page link

tmpReport = tmpReport.Replace(reportServerURL.Replace("/ReportService.asmx", "?"), ("http://"

+ (Request["SERVER_NAME"]

+ (Request["SCRIPT_NAME"] + "?Report="))));

ReportPlaceholder.InnerHtml = tmpReport;

break;

default:

Response.ClearContent();

Response.AppendHeader("content-length", result.Length.ToString());

Response.ContentType = mimeType;

Response.BinaryWrite(result);

Response.Flush();

Response.Close();

break;

}

}

}

|||

Thanks buddy!!!

you answer helped me, though it was tough to figure out what i was doing wrong previosly. the only mistake i was doing is here .

it should be this.

image=rs.RenderStream("HTML4.0", streamID, null, out encodingImage, out mimeTypeImage);

i was doing this.

image=rs.RenderStream("IMAGE", streamID, null, out encodingImage, out mimeTypeImage);

Thanks again

|||

Luis Esteban, tendras ese mismo codigo pero para reporting services 2000?

Saludos

Images not being displayed.

1. I am using the webservice to render the images from a report, and they dont render.

I paste this URL to the browser

http://agamenon:90/ReportServer?%2fGescomRpts%2fRPT_MediosDesarrollo&rs%3aFormat=HTML4.0&rs:ImageID=6c809239-753f-4988-abcf-231416dff0d6

and I get this

No se encuentra la secuencia. No se encuentra el identificador de secuencia proporcionado a una operación en la base de datos del servidor de informes. (rsStreamNotFound) Obtener ayuda en pantalla

This is the code

the problem is that I need to know the streamid, and to know the streamid I first have to render the report where the image is to be placed.

This is the page getimage.aspx

protected void Page_Load(object sender, EventArgs e)

{

string reportPath = Server.UrlDecode(Request["report"]);

//string streamID = Request["streamid"];

ReportExecutionService rs = (ReportExecutionService)Session["rs"];

DataSourceCredentials[] credentials = null;

string showHideToggle = null;

string encoding;

string mimeType;

string extension;

Warning[] warnings = null;

ParameterValue[] reportHistoryParameters = null;

string historyID = null;

string[] streamIDs = null;

ServerInfoHeader sh = new ServerInfoHeader();

rs.ServerInfoHeaderValue = sh;

byte[] result = null;

ParameterValue[] reportParameterValues2 = null;

string deviceInfo = "<DeviceInfo>" +

//"<StreamRoot>" + streamRoot + "</StreamRoot>" +

"<Toolbar>False</Toolbar>" +

"<Parameters>False</Parameters>" +

"<HTMLFragment>True</HTMLFragment>" +

"<StyleStream>False</StyleStream>" +

"<Section>0</Section>" +

"<Zoom>" +

"</Zoom>" +

"</DeviceInfo>";

result = rs.Render("HTML4.0", deviceInfo, out extension, out mimeType, out encoding, out warnings, out streamIDs);

string streamID = streamIDs[0];

string encodingImage;

string mimeTypeImage;

byte[] image;

ParameterValue[] pv = (ParameterValue[])Session["reportParameterValues"];

//image = rs.RenderStream(reportPath, "HTML4.0", streamID, null, null, pv, out encodingImage, out mimeTypeImage);

image=rs.RenderStream("HTML4.0", streamID, null, out encodingImage, out mimeTypeImage);

Response.Clear();

Response.ContentType = mimeTypeImage;

Response.AppendHeader("content-length", image.Length.ToString());

Response.BinaryWrite(image);

Response.Flush();

Response.Close();

}

and this is the page of the report. Sorry for the long code.

if (reportCanBeRendered)

{

string deviceInfo;

string streamRoot;

Session["rs"] = rs;

streamRoot = ("getimage.aspx?report="+ (path + "&streamid="));

switch (format)

{

case "HTML4.0":

case "HTML3.2":

deviceInfo = "<DeviceInfo>" +

"<StreamRoot></StreamRoot>" +

"<Toolbar>False</Toolbar>" +

"<Parameters>False</Parameters>" +

"<HTMLFragment>True</HTMLFragment>" +

"<StyleStream>False</StyleStream>" +

"<Section>0</Section>" +

"<Zoom>" +

"</Zoom>" +

"</DeviceInfo>";

break;

default:

deviceInfo = "<DeviceInfo></DeviceInfo>";

break;

}

// SQLRS-ReportViewer

if (!(reportParameterValues == null))

{

//reportParameterValues2 = reportParameterValues.ToArray(typeof(ParameterValue));

//reportParameterValues2 = (ParameterValue[])reportParameterValues.ToArray(typeof(ParameterValue));

}

DataSourceCredentials[] credentials = null;

string showHideToggle = null;

string encoding;

string mimeType;

string extension;

Warning[] warnings = null;

ParameterValue[] reportHistoryParameters = null;

string historyID = null;

string[] streamIDs = null;

ServerInfoHeader sh = new ServerInfoHeader();

rs.ServerInfoHeaderValue = sh;

byte[] result = null;

ParameterValue[] reportParameterValues2 = null;

result = rs.Render(format, deviceInfo, out extension, out mimeType, out encoding, out warnings, out streamIDs);

streamRoot = "getimage.aspx?report=" + path + "&amp;streamid=" + streamIDs[0];

//string reportPath2 = Server.UrlDecode(Request["report"]);

//string streamID = streamIDs[0];

////string streamID = "";

//ReportExecutionService rs2 = new ReportExecutionService();

//Session["rs"] = rs;

//rs2=(ReportExecutionService)Session["rs"];

//////ReportingService rs = (ReportingService)Session["rs"];

//string encodingImage;

//string mimeTypeImage;

//byte[] image;

//ParameterValue[] pv = (ParameterValue[])Session["reportParameterValues"];

//////image = rs.RenderStream(reportPath, "HTML4.0", streamID, null, null, pv, out encodingImage, out mimeTypeImage);

//image = rs2.RenderStream("HTML4.0", streamID, null, out encodingImage, out mimeTypeImage);

//Response.Clear();

//Response.ContentType = mimeTypeImage;

//Response.AppendHeader("content-length", image.Length.ToString());

//Response.BinaryWrite(image);

//Response.Flush();

//Response.Close();

// store ReportingServices and parameters object is session layer in case we need it for image streams

Session["rs"] = rs;

Session["reportParameterValues"] = reportParameterValues2;

switch (format)

{

case "HTML4.0":

case "HTML3.2":

System.Text.Encoding enc = System.Text.Encoding.UTF8;

// get the report as a string

string tmpReport = enc.GetString(result);

// replace all occurrences of report server link with current page link

tmpReport = tmpReport.Replace(reportServerURL.Replace("/ReportService.asmx", "?"), ("http://"

+ (Request["SERVER_NAME"]

+ (Request["SCRIPT_NAME"] + "?Report="))));

ReportPlaceholder.InnerHtml = tmpReport;

break;

default:

Response.ClearContent();

Response.AppendHeader("content-length", result.Length.ToString());

Response.ContentType = mimeType;

Response.BinaryWrite(result);

Response.Flush();

Response.Close();

break;

}

}

I actually solved the proble, this code has a little of garbage, but it began working.

private void GenerarInPlaceHTML()

{

string path = reportPath+ "RPT_MediosDesarrollo";

ReportExecutionService rs = new ReportExecutionService();

rs.Url = reportServerURL;

System.Net.NetworkCredential reportCredentials = new System.Net.NetworkCredential(reportUser, userPassword, domain);

rs.Credentials = reportCredentials;

// see if Report URL parameter is defined and if it is then consider that report

if (!(Request["Report"] == null))

{

reportPath = Request["Report"];

}

// set the Report hidden parameter

Report.Value = reportPath;

// Get the list of parameters. without specifing to render the report (ForRendering set to false)

// valid values for these parameters will not be populated

ExecutionInfo execInfo;

execInfo = rs.LoadReport(path, null);

ReportParameter[] reportParametersArray = execInfo.Parameters;

//reportParametersArray = rs.GetReportParameters(path, null, false, null, null);

//// If there are parametrs then we generate an array with values that should be populated from either

//// - previous submission ,

//// - URL parameters,

//// - default value defined inside the report

//// some usefull declarations

System.Web.UI.HtmlControls.HtmlTableRow TR = new HtmlTableRow();

System.Web.UI.HtmlControls.HtmlTableCell TD;

System.Web.UI.HtmlControls.HtmlSelect S;

System.Web.UI.WebControls.ListItem LI;

System.Web.UI.HtmlControls.HtmlInputText T;

//// hash table with dependecies

System.Collections.Hashtable Dependencies = new System.Collections.Hashtable();

//// we need a dynamic array for storing parameter values

ArrayList reportParameterValues= new ArrayList();

if (reportCanBeRendered)

{

string deviceInfo;

string streamRoot;

Session["rs"] = rs;

streamRoot = ("getimage.aspx?report="+ (path + "&streamid="));

switch (format)

{

case "HTML4.0":

case "HTML3.2":

deviceInfo = "<DeviceInfo>" +

"<StreamRoot>http://ImagenesTemporales/</StreamRoot>" +

"<Toolbar>False</Toolbar>" +

"<Parameters>False</Parameters>" +

"<HTMLFragment>True</HTMLFragment>" +

"<StyleStream>False</StyleStream>" +

"<Section>0</Section>" +

"<Zoom>" +

"</Zoom>" +

"</DeviceInfo>";

break;

default:

deviceInfo = "<DeviceInfo></DeviceInfo>";

break;

}

// SQLRS-ReportViewer

if (!(reportParameterValues == null))

{

//reportParameterValues2 = reportParameterValues.ToArray(typeof(ParameterValue));

//reportParameterValues2 = (ParameterValue[])reportParameterValues.ToArray(typeof(ParameterValue));

}

DataSourceCredentials[] credentials = null;

string showHideToggle = null;

string encoding;

string mimeType;

string extension;

Warning[] warnings = null;

ParameterValue[] reportHistoryParameters = null;

string historyID = null;

string[] streamIDs = null;

ServerInfoHeader sh = new ServerInfoHeader();

rs.ServerInfoHeaderValue = sh;

byte[] result = null;

ParameterValue[] reportParameterValues2 = null;

result = rs.Render(format, deviceInfo, out extension, out mimeType, out encoding, out warnings, out streamIDs);

string encodingImage;

string mimeTypeImage;

byte[] image = rs.RenderStream("HTML4.0", streamIDs[0], null, out encodingImage,out mimeTypeImage);

System.IO.FileStream fs = System.IO.File.OpenWrite(@."C:\Inetpub\wwwroot\GescomDllo\ImagenesTemporales\" + streamIDs[0]);

fs.Write(image, 0, Convert.ToInt32(image.Length));

fs.Close();

// store ReportingServices and parameters object is session layer in case we need it for image streams

Session["rs"] = rs;

Session["reportParameterValues"] = reportParameterValues2;

switch (format)

{

case "HTML4.0":

case "HTML3.2":

System.Text.Encoding enc = System.Text.Encoding.UTF8;

// get the report as a string

string tmpReport = enc.GetString(result);

// replace all occurrences of report server link with current page link

tmpReport = tmpReport.Replace(reportServerURL.Replace("/ReportService.asmx", "?"), ("http://"

+ (Request["SERVER_NAME"]

+ (Request["SCRIPT_NAME"] + "?Report="))));

ReportPlaceholder.InnerHtml = tmpReport;

break;

default:

Response.ClearContent();

Response.AppendHeader("content-length", result.Length.ToString());

Response.ContentType = mimeType;

Response.BinaryWrite(result);

Response.Flush();

Response.Close();

break;

}

}

}

|||

Thanks buddy!!!

you answer helped me, though it was tough to figure out what i was doing wrong previosly. the only mistake i was doing is here .

it should be this.

image=rs.RenderStream("HTML4.0", streamID, null, out encodingImage, out mimeTypeImage);

i was doing this.

image=rs.RenderStream("IMAGE", streamID, null, out encodingImage, out mimeTypeImage);

Thanks again

|||

Luis Esteban, tendras ese mismo codigo pero para reporting services 2000?

Saludos

sql

images loading slow corrupts the report

I have a report with an embedded image which appears in every row(static), it
also has a report that it drills down to. This page that calls this report
uses the reportviewer. the report loads quick, but the images take a while
longer. If I hit the column that drills to the next report, I can see the
page call the server, but the report stays on the same page. Yet the
reportviewer showbackbutton becomes active. If you hit the backbutton on
the reportviewer, it errors with Execution 'v0v2zx550yizfieksuf1ya45' cannot
be found .
How do I get the images quicker?
How do I keep the above problem from happening?On Jul 5, 5:32 pm, NeedToKnow <NeedToK...@.newsgroups.nospam> wrote:
> I have a report with an embedded image which appears in every row(static), it
> also has a report that it drills down to. This page that calls this report
> uses the reportviewer. the report loads quick, but the images take a while
> longer. If I hit the column that drills to the next report, I can see the
> page call the server, but the report stays on the same page. Yet the
> reportviewer showbackbutton becomes active. If you hit the backbutton on
> the reportviewer, it errors with Execution 'v0v2zx550yizfieksuf1ya45' cannot
> be found .
> How do I get the images quicker?
> How do I keep the above problem from happening?
It seems like you are using too many resources while trying to render
several images. If your images are MPEG, I would suggest converting
them to JPG/JPEG/GIF which should conserve space and improve
performance a little. It seems from your description that the
execution error is related to the resource utilization (of the
rendering). Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||My resource is one gif that is 925 bytes in size. It appears on every line
of the table. It is not a resource error. It comes from the reportviewer
when it is trying to load the drill down report.
"EMartinez" wrote:
> On Jul 5, 5:32 pm, NeedToKnow <NeedToK...@.newsgroups.nospam> wrote:
> > I have a report with an embedded image which appears in every row(static), it
> > also has a report that it drills down to. This page that calls this report
> > uses the reportviewer. the report loads quick, but the images take a while
> > longer. If I hit the column that drills to the next report, I can see the
> > page call the server, but the report stays on the same page. Yet the
> > reportviewer showbackbutton becomes active. If you hit the backbutton on
> > the reportviewer, it errors with Execution 'v0v2zx550yizfieksuf1ya45' cannot
> > be found .
> > How do I get the images quicker?
> > How do I keep the above problem from happening?
>
> It seems like you are using too many resources while trying to render
> several images. If your images are MPEG, I would suggest converting
> them to JPG/JPEG/GIF which should conserve space and improve
> performance a little. It seems from your description that the
> execution error is related to the resource utilization (of the
> rendering). Sorry that I could not be of greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Images inside a literal

I am displaying the output from a Report inside a literal. Everything
is OK, except the images are not displaying. Is there anything special
I have to do?
When using preview or the MS Sample Report Viewer Control, the images
appear.
I cannot use the Report Viewer Control as I need to pass XML to the
report, not a server side data source.
Can someone help?
Matt...As you probably know, there three types of getting imager into report:
1) From database â'it is not you case
2) Embedded into the report application
3) URL to the image â' this one you may try.
Regards, ProJester,
MSN Programmer.
"mtatro@.direcsoft.com" wrote:
> I am displaying the output from a Report inside a literal. Everything
> is OK, except the images are not displaying. Is there anything special
> I have to do?
> When using preview or the MS Sample Report Viewer Control, the images
> appear.
> I cannot use the Report Viewer Control as I need to pass XML to the
> report, not a server side data source.
> Can someone help?
> Matt...
>|||How can I get the Embedded option to work?
Matt...

Images in SQL Server 2005 Express

Hey all,

I'm working on a database which (I hope) will have photos in it. However, I'm having difficulty how to properly insert photos into an SQL database. I see that it has an 'image' data-type, but I don't know how to make proper use it.

Given that the answer to this question could be quite lengthy, if someone could provide me a link to somewhere, or a book to pick up that could answer this answer, I would be most gratified. Thanks!Smile [:)]

It is not that bad at all. Just convert your image to a ByteArray and it is ready to save.

Have a great day.

|||In general, I'm not a fan of storing images in the database directly. There just usually isn't any good reason to.

If you can, just store enough information in the database so you can find the image in question, and store the images on disk some place.

Images In Sql Server

Hi all,
How to store and retrive images in sql server ?
Thanks & Regards,
Selva Balaji B.You can use ADO with STREAM or GETCHUNK methods see these 2 articles.
HOWTO: Access and Modify SQL Server BLOB Data by Using the ADO Stream Object (Q258038) (http://support.microsoft.com/default.aspx?scid=kb;EN-US;q258038)

Tired of FileSystemObject? Use the Stream Object Instead! (http://www.4guysfromrolla.com/webtech/083100-1.shtml)