Cannot display image from Database

Hi,
When i try to display an image from the database,it does not give any error
and does not show the image either. It does not show the box also which has
the cross sign. On seeing the report it seems there is no image eventhough
i have an image from the db on the report.
Please help.
Thanx,
Warm Regards,
Kalpnacan you list down the steps that you performed to display an image?
"kalpna" <kalpna.prakash@.grapecity.com> wrote in message
news:%23jvG%23G4rEHA.3868@.TK2MSFTNGP15.phx.gbl...
> Hi,
> When i try to display an image from the database,it does not give any
> error
> and does not show the image either. It does not show the box also which
> has
> the cross sign. On seeing the report it seems there is no image
> eventhough
> i have an image from the db on the report.
> Please help.
> Thanx,
> Warm Regards,
> Kalpna
>|||i drag an image object from the toolbox
Then in the image wizard that pops up i select image from Database and set
the datset that has the image item from the database and the corresponding
field and the mime type(tried with all the available mime types) and then
say OK and finish.
When i preview /view the report nothing is shown.It does not even show the
image box with a cross or something like that.
Any help wud be of great use.
Thanx,
Kalpna
"avnrao" <avn@.newsgroups.com> wrote in message
news:Ofay1n5rEHA.868@.TK2MSFTNGP12.phx.gbl...
> can you list down the steps that you performed to display an image?
> "kalpna" <kalpna.prakash@.grapecity.com> wrote in message
> news:%23jvG%23G4rEHA.3868@.TK2MSFTNGP15.phx.gbl...
> > Hi,
> >
> > When i try to display an image from the database,it does not give any
> > error
> > and does not show the image either. It does not show the box also which
> > has
> > the cross sign. On seeing the report it seems there is no image
> > eventhough
> > i have an image from the db on the report.
> >
> > Please help.
> >
> > Thanx,
> > Warm Regards,
> > Kalpna
> >
> >
>|||Any solution to this?
I have the same problem :( No images are served from the database allthough
I have verified that they are there...
"kalpna" wrote:
> i drag an image object from the toolbox
> Then in the image wizard that pops up i select image from Database and set
> the datset that has the image item from the database and the corresponding
> field and the mime type(tried with all the available mime types) and then
> say OK and finish.
> When i preview /view the report nothing is shown.It does not even show the
> image box with a cross or something like that.
> Any help wud be of great use.
> Thanx,
> Kalpna
> "avnrao" <avn@.newsgroups.com> wrote in message
> news:Ofay1n5rEHA.868@.TK2MSFTNGP12.phx.gbl...
> > can you list down the steps that you performed to display an image?
> >
> > "kalpna" <kalpna.prakash@.grapecity.com> wrote in message
> > news:%23jvG%23G4rEHA.3868@.TK2MSFTNGP15.phx.gbl...
> > > Hi,
> > >
> > > When i try to display an image from the database,it does not give any
> > > error
> > > and does not show the image either. It does not show the box also which
> > > has
> > > the cross sign. On seeing the report it seems there is no image
> > > eventhough
> > > i have an image from the db on the report.
> > >
> > > Please help.
> > >
> > > Thanx,
> > > Warm Regards,
> > > Kalpna
> > >
> > >
> >
> >
>
>|||This sounds like the images are stored as OLE images in the database (e.g.
Access would convert images into OLE images). You can try the following
expression to get rid of the OLE chunk:
=System.Convert.FromBase64String(Mid(System.Convert.ToBase64String(Fields!Pi
cture.Value), 105))
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"alfgaba" <alfgaba@.discussions.microsoft.com> wrote in message
news:C49DC28A-BEA6-4827-AC27-5025DED46EF2@.microsoft.com...
> Any solution to this?
> I have the same problem :( No images are served from the database
allthough
> I have verified that they are there...
> "kalpna" wrote:
> > i drag an image object from the toolbox
> >
> > Then in the image wizard that pops up i select image from Database and
set
> > the datset that has the image item from the database and the
corresponding
> > field and the mime type(tried with all the available mime types) and
then
> > say OK and finish.
> >
> > When i preview /view the report nothing is shown.It does not even show
the
> > image box with a cross or something like that.
> >
> > Any help wud be of great use.
> >
> > Thanx,
> >
> > Kalpna
> >
> > "avnrao" <avn@.newsgroups.com> wrote in message
> > news:Ofay1n5rEHA.868@.TK2MSFTNGP12.phx.gbl...
> > > can you list down the steps that you performed to display an image?
> > >
> > > "kalpna" <kalpna.prakash@.grapecity.com> wrote in message
> > > news:%23jvG%23G4rEHA.3868@.TK2MSFTNGP15.phx.gbl...
> > > > Hi,
> > > >
> > > > When i try to display an image from the database,it does not give
any
> > > > error
> > > > and does not show the image either. It does not show the box also
which
> > > > has
> > > > the cross sign. On seeing the report it seems there is no image
> > > > eventhough
> > > > i have an image from the db on the report.
> > > >
> > > > Please help.
> > > >
> > > > Thanx,
> > > > Warm Regards,
> > > > Kalpna
> > > >
> > > >
> > >
> > >
> >
> >
> >|||I am having the same problem. I tried the expression below but it doesn't
work for me. All of my images are inserted with an Access Data Project to SQL
Image fields. Some are BMP files, JPG files, or even AutoCAD files. Access
displays them correctly, but Reporting Services will not. Is there any other
way to strip away the OLE junk and get the image placeholder to display? Any
help is greatly appreciated.
"Robert Bruckner [MSFT]" wrote:
> This sounds like the images are stored as OLE images in the database (e.g.
> Access would convert images into OLE images). You can try the following
> expression to get rid of the OLE chunk:
> =System.Convert.FromBase64String(Mid(System.Convert.ToBase64String(Fields!Pi
> cture.Value), 105))
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "alfgaba" <alfgaba@.discussions.microsoft.com> wrote in message
> news:C49DC28A-BEA6-4827-AC27-5025DED46EF2@.microsoft.com...
> > Any solution to this?
> >
> > I have the same problem :( No images are served from the database
> allthough
> > I have verified that they are there...
> >
> > "kalpna" wrote:
> >
> > > i drag an image object from the toolbox
> > >
> > > Then in the image wizard that pops up i select image from Database and
> set
> > > the datset that has the image item from the database and the
> corresponding
> > > field and the mime type(tried with all the available mime types) and
> then
> > > say OK and finish.
> > >
> > > When i preview /view the report nothing is shown.It does not even show
> the
> > > image box with a cross or something like that.
> > >
> > > Any help wud be of great use.
> > >
> > > Thanx,
> > >
> > > Kalpna
> > >
> > > "avnrao" <avn@.newsgroups.com> wrote in message
> > > news:Ofay1n5rEHA.868@.TK2MSFTNGP12.phx.gbl...
> > > > can you list down the steps that you performed to display an image?
> > > >
> > > > "kalpna" <kalpna.prakash@.grapecity.com> wrote in message
> > > > news:%23jvG%23G4rEHA.3868@.TK2MSFTNGP15.phx.gbl...
> > > > > Hi,
> > > > >
> > > > > When i try to display an image from the database,it does not give
> any
> > > > > error
> > > > > and does not show the image either. It does not show the box also
> which
> > > > > has
> > > > > the cross sign. On seeing the report it seems there is no image
> > > > > eventhough
> > > > > i have an image from the db on the report.
> > > > >
> > > > > Please help.
> > > > >
> > > > > Thanx,
> > > > > Warm Regards,
> > > > > Kalpna
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> > >
>
>|||That doesn't help. I get exactly the same thing as before -- red x in little
square indicating no source for the image. (I am trying to display a Visio,
AutoCAD, or other OLE object drawing).
What should MIMEType be set to?
-prophead
"Robert Bruckner [MSFT]" wrote:
> This sounds like the images are stored as OLE images in the database (e.g.
> Access would convert images into OLE images). You can try the following
> expression to get rid of the OLE chunk:
> =System.Convert.FromBase64String(Mid(System.Convert.ToBase64String(Fields!Pi
> cture.Value), 105))
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "alfgaba" <alfgaba@.discussions.microsoft.com> wrote in message
> news:C49DC28A-BEA6-4827-AC27-5025DED46EF2@.microsoft.com...
> > Any solution to this?
> >
> > I have the same problem :( No images are served from the database
> allthough
> > I have verified that they are there...
> >
> > "kalpna" wrote:
> >
> > > i drag an image object from the toolbox
> > >
> > > Then in the image wizard that pops up i select image from Database and
> set
> > > the datset that has the image item from the database and the
> corresponding
> > > field and the mime type(tried with all the available mime types) and
> then
> > > say OK and finish.
> > >
> > > When i preview /view the report nothing is shown.It does not even show
> the
> > > image box with a cross or something like that.
> > >
> > > Any help wud be of great use.
> > >
> > > Thanx,
> > >
> > > Kalpna
> > >
> > > "avnrao" <avn@.newsgroups.com> wrote in message
> > > news:Ofay1n5rEHA.868@.TK2MSFTNGP12.phx.gbl...
> > > > can you list down the steps that you performed to display an image?
> > > >
> > > > "kalpna" <kalpna.prakash@.grapecity.com> wrote in message
> > > > news:%23jvG%23G4rEHA.3868@.TK2MSFTNGP15.phx.gbl...
> > > > > Hi,
> > > > >
> > > > > When i try to display an image from the database,it does not give
> any
> > > > > error
> > > > > and does not show the image either. It does not show the box also
> which
> > > > > has
> > > > > the cross sign. On seeing the report it seems there is no image
> > > > > eventhough
> > > > > i have an image from the db on the report.
> > > > >
> > > > > Please help.
> > > > >
> > > > > Thanx,
> > > > > Warm Regards,
> > > > > Kalpna
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> > >
>
>|||The supported image types in RS are listed in the "Remarks" section of this
MSDN page:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSRDL/htm/rsp_ref_rdl_elements_fp_5er8.asp
RS does not support any arbitrary OLE object drawing, because we need to be
able to export images correctly to various output formats like PDF etc.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"prophead" <prophead@.discussions.microsoft.com> wrote in message
news:67A353DB-16BD-4910-9B68-CF6E19053FD6@.microsoft.com...
> That doesn't help. I get exactly the same thing as before -- red x in
> little
> square indicating no source for the image. (I am trying to display a
> Visio,
> AutoCAD, or other OLE object drawing).
> What should MIMEType be set to?
> -prophead
> "Robert Bruckner [MSFT]" wrote:
>> This sounds like the images are stored as OLE images in the database
>> (e.g.
>> Access would convert images into OLE images). You can try the following
>> expression to get rid of the OLE chunk:
>> =System.Convert.FromBase64String(Mid(System.Convert.ToBase64String(Fields!Pi
>> cture.Value), 105))
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "alfgaba" <alfgaba@.discussions.microsoft.com> wrote in message
>> news:C49DC28A-BEA6-4827-AC27-5025DED46EF2@.microsoft.com...
>> > Any solution to this?
>> >
>> > I have the same problem :( No images are served from the database
>> allthough
>> > I have verified that they are there...
>> >
>> > "kalpna" wrote:
>> >
>> > > i drag an image object from the toolbox
>> > >
>> > > Then in the image wizard that pops up i select image from Database
>> > > and
>> set
>> > > the datset that has the image item from the database and the
>> corresponding
>> > > field and the mime type(tried with all the available mime types) and
>> then
>> > > say OK and finish.
>> > >
>> > > When i preview /view the report nothing is shown.It does not even
>> > > show
>> the
>> > > image box with a cross or something like that.
>> > >
>> > > Any help wud be of great use.
>> > >
>> > > Thanx,
>> > >
>> > > Kalpna
>> > >
>> > > "avnrao" <avn@.newsgroups.com> wrote in message
>> > > news:Ofay1n5rEHA.868@.TK2MSFTNGP12.phx.gbl...
>> > > > can you list down the steps that you performed to display an image?
>> > > >
>> > > > "kalpna" <kalpna.prakash@.grapecity.com> wrote in message
>> > > > news:%23jvG%23G4rEHA.3868@.TK2MSFTNGP15.phx.gbl...
>> > > > > Hi,
>> > > > >
>> > > > > When i try to display an image from the database,it does not give
>> any
>> > > > > error
>> > > > > and does not show the image either. It does not show the box also
>> which
>> > > > > has
>> > > > > the cross sign. On seeing the report it seems there is no image
>> > > > > eventhough
>> > > > > i have an image from the db on the report.
>> > > > >
>> > > > > Please help.
>> > > > >
>> > > > > Thanx,
>> > > > > Warm Regards,
>> > > > > Kalpna
>> > > > >
>> > > > >
>> > > >
>> > > >
>> > >
>> > >
>> > >
>>|||Thanks, Robert.
Is there a way to specify an ActiveX container to be deployed and used for
other types of OLE objects stored in the db, or even as files on the server
(using Source = External) in the RS 2000 report design?
-prophead
"Robert Bruckner [MSFT]" wrote:
> The supported image types in RS are listed in the "Remarks" section of this
> MSDN page:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSRDL/htm/rsp_ref_rdl_elements_fp_5er8.asp
> RS does not support any arbitrary OLE object drawing, because we need to be
> able to export images correctly to various output formats like PDF etc.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "prophead" <prophead@.discussions.microsoft.com> wrote in message
> news:67A353DB-16BD-4910-9B68-CF6E19053FD6@.microsoft.com...
> > That doesn't help. I get exactly the same thing as before -- red x in
> > little
> > square indicating no source for the image. (I am trying to display a
> > Visio,
> > AutoCAD, or other OLE object drawing).
> >
> > What should MIMEType be set to?
> >
> > -prophead
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> >> This sounds like the images are stored as OLE images in the database
> >> (e.g.
> >> Access would convert images into OLE images). You can try the following
> >> expression to get rid of the OLE chunk:
> >> =System.Convert.FromBase64String(Mid(System.Convert.ToBase64String(Fields!Pi
> >> cture.Value), 105))
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "alfgaba" <alfgaba@.discussions.microsoft.com> wrote in message
> >> news:C49DC28A-BEA6-4827-AC27-5025DED46EF2@.microsoft.com...
> >> > Any solution to this?
> >> >
> >> > I have the same problem :( No images are served from the database
> >> allthough
> >> > I have verified that they are there...
> >> >
> >> > "kalpna" wrote:
> >> >
> >> > > i drag an image object from the toolbox
> >> > >
> >> > > Then in the image wizard that pops up i select image from Database
> >> > > and
> >> set
> >> > > the datset that has the image item from the database and the
> >> corresponding
> >> > > field and the mime type(tried with all the available mime types) and
> >> then
> >> > > say OK and finish.
> >> > >
> >> > > When i preview /view the report nothing is shown.It does not even
> >> > > show
> >> the
> >> > > image box with a cross or something like that.
> >> > >
> >> > > Any help wud be of great use.
> >> > >
> >> > > Thanx,
> >> > >
> >> > > Kalpna
> >> > >
> >> > > "avnrao" <avn@.newsgroups.com> wrote in message
> >> > > news:Ofay1n5rEHA.868@.TK2MSFTNGP12.phx.gbl...
> >> > > > can you list down the steps that you performed to display an image?
> >> > > >
> >> > > > "kalpna" <kalpna.prakash@.grapecity.com> wrote in message
> >> > > > news:%23jvG%23G4rEHA.3868@.TK2MSFTNGP15.phx.gbl...
> >> > > > > Hi,
> >> > > > >
> >> > > > > When i try to display an image from the database,it does not give
> >> any
> >> > > > > error
> >> > > > > and does not show the image either. It does not show the box also
> >> which
> >> > > > > has
> >> > > > > the cross sign. On seeing the report it seems there is no image
> >> > > > > eventhough
> >> > > > > i have an image from the db on the report.
> >> > > > >
> >> > > > > Please help.
> >> > > > >
> >> > > > > Thanx,
> >> > > > > Warm Regards,
> >> > > > > Kalpna
> >> > > > >
> >> > > > >
> >> > > >
> >> > > >
> >> > >
> >> > >
> >> > >
> >>
> >>
> >>
>
>|||You cannot use ActiveX directly - you would need to go through a custom
assembly and convert the data into an image format RS can work with.
For external server files we allow only the given list of MimeTypes - also
for security reasons. Another reason is that when you create a history
snapshot, you would not only expect to get an exact snapshot of your data,
but also an exact snapshot of external images that were available at
snapshot creation time. So, when you render the history snapshot years
later, you still get *exactly* the same data and images across the supported
output formats.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"prophead" <prophead@.discussions.microsoft.com> wrote in message
news:B92199A9-BAA7-4CC4-97BD-11FE05AA2A53@.microsoft.com...
> Thanks, Robert.
> Is there a way to specify an ActiveX container to be deployed and used for
> other types of OLE objects stored in the db, or even as files on the
> server
> (using Source = External) in the RS 2000 report design?
> -prophead
> "Robert Bruckner [MSFT]" wrote:
>> The supported image types in RS are listed in the "Remarks" section of
>> this
>> MSDN page:
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSRDL/htm/rsp_ref_rdl_elements_fp_5er8.asp
>> RS does not support any arbitrary OLE object drawing, because we need to
>> be
>> able to export images correctly to various output formats like PDF etc.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "prophead" <prophead@.discussions.microsoft.com> wrote in message
>> news:67A353DB-16BD-4910-9B68-CF6E19053FD6@.microsoft.com...
>> > That doesn't help. I get exactly the same thing as before -- red x in
>> > little
>> > square indicating no source for the image. (I am trying to display a
>> > Visio,
>> > AutoCAD, or other OLE object drawing).
>> >
>> > What should MIMEType be set to?
>> >
>> > -prophead
>> >
>> > "Robert Bruckner [MSFT]" wrote:
>> >
>> >> This sounds like the images are stored as OLE images in the database
>> >> (e.g.
>> >> Access would convert images into OLE images). You can try the
>> >> following
>> >> expression to get rid of the OLE chunk:
>> >> =System.Convert.FromBase64String(Mid(System.Convert.ToBase64String(Fields!Pi
>> >> cture.Value), 105))
>> >>
>> >> --
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >> "alfgaba" <alfgaba@.discussions.microsoft.com> wrote in message
>> >> news:C49DC28A-BEA6-4827-AC27-5025DED46EF2@.microsoft.com...
>> >> > Any solution to this?
>> >> >
>> >> > I have the same problem :( No images are served from the database
>> >> allthough
>> >> > I have verified that they are there...
>> >> >
>> >> > "kalpna" wrote:
>> >> >
>> >> > > i drag an image object from the toolbox
>> >> > >
>> >> > > Then in the image wizard that pops up i select image from Database
>> >> > > and
>> >> set
>> >> > > the datset that has the image item from the database and the
>> >> corresponding
>> >> > > field and the mime type(tried with all the available mime types)
>> >> > > and
>> >> then
>> >> > > say OK and finish.
>> >> > >
>> >> > > When i preview /view the report nothing is shown.It does not even
>> >> > > show
>> >> the
>> >> > > image box with a cross or something like that.
>> >> > >
>> >> > > Any help wud be of great use.
>> >> > >
>> >> > > Thanx,
>> >> > >
>> >> > > Kalpna
>> >> > >
>> >> > > "avnrao" <avn@.newsgroups.com> wrote in message
>> >> > > news:Ofay1n5rEHA.868@.TK2MSFTNGP12.phx.gbl...
>> >> > > > can you list down the steps that you performed to display an
>> >> > > > image?
>> >> > > >
>> >> > > > "kalpna" <kalpna.prakash@.grapecity.com> wrote in message
>> >> > > > news:%23jvG%23G4rEHA.3868@.TK2MSFTNGP15.phx.gbl...
>> >> > > > > Hi,
>> >> > > > >
>> >> > > > > When i try to display an image from the database,it does not
>> >> > > > > give
>> >> any
>> >> > > > > error
>> >> > > > > and does not show the image either. It does not show the box
>> >> > > > > also
>> >> which
>> >> > > > > has
>> >> > > > > the cross sign. On seeing the report it seems there is no
>> >> > > > > image
>> >> > > > > eventhough
>> >> > > > > i have an image from the db on the report.
>> >> > > > >
>> >> > > > > Please help.
>> >> > > > >
>> >> > > > > Thanx,
>> >> > > > > Warm Regards,
>> >> > > > > Kalpna
>> >> > > > >
>> >> > > > >
>> >> > > >
>> >> > > >
>> >> > >
>> >> > >
>> >> > >
>> >>
>> >>
>> >>
>>