bmp BLOP fields

Hi,
Does Sql reporting services support Bmp BLOB files?
SapnilSapnil, I believe the answer is yes.
You'll need an image control and choose 'Database' as the 'Source' and
the appropriate column name as the 'Value'. Also select the appropriate
MIME type.
Chris
Sapnil wrote:
> Hi,
> Does Sql reporting services support Bmp BLOB files?
> Sapnil|||Having re-read your post, I should clarify that I assume you mean
bitmaps stored in the database as BLOB fields?
If you mean external files then again yes it can, either using a field
containing the url/unc path or some other direct path are expression to
the path.
Chris
Chris McGuigan wrote:
> Sapnil, I believe the answer is yes.
> You'll need an image control and choose 'Database' as the 'Source' and
> the appropriate column name as the 'Value'. Also select the
> appropriate MIME type.
> Chris
> Sapnil wrote:
> > Hi,
> >
> > Does Sql reporting services support Bmp BLOB files?
> >
> > Sapnil|||I tried as you said. But the BMP imgaes are not displayed in the report.
I tried the same with crystal reports and it worked.
"Chris McGuigan" wrote:
> Having re-read your post, I should clarify that I assume you mean
> bitmaps stored in the database as BLOB fields?
> If you mean external files then again yes it can, either using a field
> containing the url/unc path or some other direct path are expression to
> the path.
> Chris
>
> Chris McGuigan wrote:
> > Sapnil, I believe the answer is yes.
> > You'll need an image control and choose 'Database' as the 'Source' and
> > the appropriate column name as the 'Value'. Also select the
> > appropriate MIME type.
> >
> > Chris
> >
> > Sapnil wrote:
> >
> > > Hi,
> > >
> > > Does Sql reporting services support Bmp BLOB files?
> > >
> > > Sapnil
>|||Sapnil,
I've just checked the Sample Report, Product Catalogue. This uses this
feature and works. It shows an image for each stock item and the image
is taken directly from the database. I suspect you've a setting wrong.
I suggest you load and take a look at this sample report. Look up
sample reports in BOL for details.
In the sample the image is inside a rectangle, which may confuse you
when trying to select it. In the properties pane, in the drop-down list
of property names select ProdPhoto.
Chris
Sapnil wrote:
> I tried as you said. But the BMP imgaes are not displayed in the
> report. I tried the same with crystal reports and it worked.
> "Chris McGuigan" wrote:
> > Having re-read your post, I should clarify that I assume you mean
> > bitmaps stored in the database as BLOB fields?
> > If you mean external files then again yes it can, either using a
> > field containing the url/unc path or some other direct path are
> > expression to the path.
> >
> > Chris
> >
> >
> > Chris McGuigan wrote:
> >
> > > Sapnil, I believe the answer is yes.
> > > You'll need an image control and choose 'Database' as the
> > > 'Source' and the appropriate column name as the 'Value'. Also
> > > select the appropriate MIME type.
> > >
> > > Chris
> > >
> > > Sapnil wrote:
> > >
> > > > Hi,
> > > >
> > > > Does Sql reporting services support Bmp BLOB files?
> > > >
> > > > Sapnil
> >
> >|||Chirs,
I have tried the sample product catalog sample report and it works for me too.
But If I am not wrong the images stored in the BLOB fieds are of type GIF
I tried the same thing with the Northwind database, trying to display the
employees on the report, but there seems to be some problem.
Sapnil
"Chris McGuigan" wrote:
> Sapnil,
> I've just checked the Sample Report, Product Catalogue. This uses this
> feature and works. It shows an image for each stock item and the image
> is taken directly from the database. I suspect you've a setting wrong.
> I suggest you load and take a look at this sample report. Look up
> sample reports in BOL for details.
> In the sample the image is inside a rectangle, which may confuse you
> when trying to select it. In the properties pane, in the drop-down list
> of property names select ProdPhoto.
> Chris
>
> Sapnil wrote:
> > I tried as you said. But the BMP imgaes are not displayed in the
> > report. I tried the same with crystal reports and it worked.
> >
> > "Chris McGuigan" wrote:
> >
> > > Having re-read your post, I should clarify that I assume you mean
> > > bitmaps stored in the database as BLOB fields?
> > > If you mean external files then again yes it can, either using a
> > > field containing the url/unc path or some other direct path are
> > > expression to the path.
> > >
> > > Chris
> > >
> > >
> > > Chris McGuigan wrote:
> > >
> > > > Sapnil, I believe the answer is yes.
> > > > You'll need an image control and choose 'Database' as the
> > > > 'Source' and the appropriate column name as the 'Value'. Also
> > > > select the appropriate MIME type.
> > > >
> > > > Chris
> > > >
> > > > Sapnil wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > Does Sql reporting services support Bmp BLOB files?
> > > > >
> > > > > Sapnil
> > >
> > >
>|||It's MIME type is set to image/bmp, so I assume it's bmp!
I've never actually used Blob fields. So I'm going by the book rather
than experience! Have you tried all the different MIME types against
your data? Are you 100% sure your fields contain bitmaps and not gifs
or jpegs? I guess you are because you've had it working in Crystal, but
it's worth a check!
Regards
Chris
Sapnil wrote:
> Chirs,
> I have tried the sample product catalog sample report and it works
> for me too. But If I am not wrong the images stored in the BLOB
> fieds are of type GIF I tried the same thing with the Northwind
> database, trying to display the employees on the report, but there
> seems to be some problem.
> Sapnil
> "Chris McGuigan" wrote:
> > Sapnil,
> > I've just checked the Sample Report, Product Catalogue. This uses
> > this feature and works. It shows an image for each stock item and
> > the image is taken directly from the database. I suspect you've a
> > setting wrong.
> >
> > I suggest you load and take a look at this sample report. Look up
> > sample reports in BOL for details.
> >
> > In the sample the image is inside a rectangle, which may confuse you
> > when trying to select it. In the properties pane, in the drop-down
> > list of property names select ProdPhoto.
> >
> > Chris
> >
> >
> > Sapnil wrote:
> >
> > > I tried as you said. But the BMP imgaes are not displayed in the
> > > report. I tried the same with crystal reports and it worked.
> > >
> > > "Chris McGuigan" wrote:
> > >
> > > > Having re-read your post, I should clarify that I assume you
> > > > mean bitmaps stored in the database as BLOB fields?
> > > > If you mean external files then again yes it can, either using a
> > > > field containing the url/unc path or some other direct path are
> > > > expression to the path.
> > > >
> > > > Chris
> > > >
> > > >
> > > > Chris McGuigan wrote:
> > > >
> > > > > Sapnil, I believe the answer is yes.
> > > > > You'll need an image control and choose 'Database' as the
> > > > > 'Source' and the appropriate column name as the 'Value'. Also
> > > > > select the appropriate MIME type.
> > > > >
> > > > > Chris
> > > > >
> > > > > Sapnil wrote:
> > > > >
> > > > > > Hi,
> > > > > >
> > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > >
> > > > > > Sapnil
> > > >
> > > >
> >
> >|||I have tried all MIME types.
And you are right, its working with crystal reports.
Actually I am in the process of evaluating repoting tools.
"Chris McGuigan" wrote:
> It's MIME type is set to image/bmp, so I assume it's bmp!
> I've never actually used Blob fields. So I'm going by the book rather
> than experience! Have you tried all the different MIME types against
> your data? Are you 100% sure your fields contain bitmaps and not gifs
> or jpegs? I guess you are because you've had it working in Crystal, but
> it's worth a check!
> Regards
> Chris
>
> Sapnil wrote:
> > Chirs,
> > I have tried the sample product catalog sample report and it works
> > for me too. But If I am not wrong the images stored in the BLOB
> > fieds are of type GIF I tried the same thing with the Northwind
> > database, trying to display the employees on the report, but there
> > seems to be some problem.
> >
> > Sapnil
> >
> > "Chris McGuigan" wrote:
> >
> > > Sapnil,
> > > I've just checked the Sample Report, Product Catalogue. This uses
> > > this feature and works. It shows an image for each stock item and
> > > the image is taken directly from the database. I suspect you've a
> > > setting wrong.
> > >
> > > I suggest you load and take a look at this sample report. Look up
> > > sample reports in BOL for details.
> > >
> > > In the sample the image is inside a rectangle, which may confuse you
> > > when trying to select it. In the properties pane, in the drop-down
> > > list of property names select ProdPhoto.
> > >
> > > Chris
> > >
> > >
> > > Sapnil wrote:
> > >
> > > > I tried as you said. But the BMP imgaes are not displayed in the
> > > > report. I tried the same with crystal reports and it worked.
> > > >
> > > > "Chris McGuigan" wrote:
> > > >
> > > > > Having re-read your post, I should clarify that I assume you
> > > > > mean bitmaps stored in the database as BLOB fields?
> > > > > If you mean external files then again yes it can, either using a
> > > > > field containing the url/unc path or some other direct path are
> > > > > expression to the path.
> > > > >
> > > > > Chris
> > > > >
> > > > >
> > > > > Chris McGuigan wrote:
> > > > >
> > > > > > Sapnil, I believe the answer is yes.
> > > > > > You'll need an image control and choose 'Database' as the
> > > > > > 'Source' and the appropriate column name as the 'Value'. Also
> > > > > > select the appropriate MIME type.
> > > > > >
> > > > > > Chris
> > > > > >
> > > > > > Sapnil wrote:
> > > > > >
> > > > > > > Hi,
> > > > > > >
> > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > >
> > > > > > > Sapnil
> > > > >
> > > > >
> > >
> > >
>|||Hi Sapnil,
I'm a bit stumped I'm afraid. What exactly are you getting?
In terms of evaluation, I'm an ex-Crystal user who switched to RS last
February and have had little need to revert back since.
That's not to say that there are things Crystal doesn't do better than
RS, but for my environment, RS has many more advantages. I'm playing
with RS2005 now (due to be "launched" early November) and it's looking
good with ReportBuilder filling many of the RS's shortcomings against
Crystal. This is a bit off topic now but if you trawl this newsgroup
you'll see plenty of worthwhile exchanges on the pro's and con's of
various reporting tools.
Obviously this image issue is a problem for you! Are you using SP1 or
SP2?
Chris
Sapnil wrote:
> I have tried all MIME types.
> And you are right, its working with crystal reports.
> Actually I am in the process of evaluating repoting tools.
> "Chris McGuigan" wrote:
> > It's MIME type is set to image/bmp, so I assume it's bmp!
> > I've never actually used Blob fields. So I'm going by the book
> > rather than experience! Have you tried all the different MIME types
> > against your data? Are you 100% sure your fields contain bitmaps
> > and not gifs or jpegs? I guess you are because you've had it
> > working in Crystal, but it's worth a check!
> >
> > Regards
> > Chris
> >
> >
> > Sapnil wrote:
> >
> > > Chirs,
> > > I have tried the sample product catalog sample report and it works
> > > for me too. But If I am not wrong the images stored in the BLOB
> > > fieds are of type GIF I tried the same thing with the Northwind
> > > database, trying to display the employees on the report, but there
> > > seems to be some problem.
> > >
> > > Sapnil
> > >
> > > "Chris McGuigan" wrote:
> > >
> > > > Sapnil,
> > > > I've just checked the Sample Report, Product Catalogue. This
> > > > uses this feature and works. It shows an image for each stock
> > > > item and the image is taken directly from the database. I
> > > > suspect you've a setting wrong.
> > > >
> > > > I suggest you load and take a look at this sample report. Look
> > > > up sample reports in BOL for details.
> > > >
> > > > In the sample the image is inside a rectangle, which may
> > > > confuse you when trying to select it. In the properties pane,
> > > > in the drop-down list of property names select ProdPhoto.
> > > >
> > > > Chris
> > > >
> > > >
> > > > Sapnil wrote:
> > > >
> > > > > I tried as you said. But the BMP imgaes are not displayed in
> > > > > the report. I tried the same with crystal reports and it
> > > > > worked.
> > > > >
> > > > > "Chris McGuigan" wrote:
> > > > >
> > > > > > Having re-read your post, I should clarify that I assume you
> > > > > > mean bitmaps stored in the database as BLOB fields?
> > > > > > If you mean external files then again yes it can, either
> > > > > > using a field containing the url/unc path or some other
> > > > > > direct path are expression to the path.
> > > > > >
> > > > > > Chris
> > > > > >
> > > > > >
> > > > > > Chris McGuigan wrote:
> > > > > >
> > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > You'll need an image control and choose 'Database' as the
> > > > > > > 'Source' and the appropriate column name as the 'Value'.
> > > > > > > Also select the appropriate MIME type.
> > > > > > >
> > > > > > > Chris
> > > > > > >
> > > > > > > Sapnil wrote:
> > > > > > >
> > > > > > > > Hi,
> > > > > > > >
> > > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > > >
> > > > > > > > Sapnil
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >|||I am using SP2
"Chris McGuigan" wrote:
> Hi Sapnil,
> I'm a bit stumped I'm afraid. What exactly are you getting?
> In terms of evaluation, I'm an ex-Crystal user who switched to RS last
> February and have had little need to revert back since.
> That's not to say that there are things Crystal doesn't do better than
> RS, but for my environment, RS has many more advantages. I'm playing
> with RS2005 now (due to be "launched" early November) and it's looking
> good with ReportBuilder filling many of the RS's shortcomings against
> Crystal. This is a bit off topic now but if you trawl this newsgroup
> you'll see plenty of worthwhile exchanges on the pro's and con's of
> various reporting tools.
> Obviously this image issue is a problem for you! Are you using SP1 or
> SP2?
> Chris
>
> Sapnil wrote:
> > I have tried all MIME types.
> > And you are right, its working with crystal reports.
> > Actually I am in the process of evaluating repoting tools.
> >
> > "Chris McGuigan" wrote:
> >
> > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > I've never actually used Blob fields. So I'm going by the book
> > > rather than experience! Have you tried all the different MIME types
> > > against your data? Are you 100% sure your fields contain bitmaps
> > > and not gifs or jpegs? I guess you are because you've had it
> > > working in Crystal, but it's worth a check!
> > >
> > > Regards
> > > Chris
> > >
> > >
> > > Sapnil wrote:
> > >
> > > > Chirs,
> > > > I have tried the sample product catalog sample report and it works
> > > > for me too. But If I am not wrong the images stored in the BLOB
> > > > fieds are of type GIF I tried the same thing with the Northwind
> > > > database, trying to display the employees on the report, but there
> > > > seems to be some problem.
> > > >
> > > > Sapnil
> > > >
> > > > "Chris McGuigan" wrote:
> > > >
> > > > > Sapnil,
> > > > > I've just checked the Sample Report, Product Catalogue. This
> > > > > uses this feature and works. It shows an image for each stock
> > > > > item and the image is taken directly from the database. I
> > > > > suspect you've a setting wrong.
> > > > >
> > > > > I suggest you load and take a look at this sample report. Look
> > > > > up sample reports in BOL for details.
> > > > >
> > > > > In the sample the image is inside a rectangle, which may
> > > > > confuse you when trying to select it. In the properties pane,
> > > > > in the drop-down list of property names select ProdPhoto.
> > > > >
> > > > > Chris
> > > > >
> > > > >
> > > > > Sapnil wrote:
> > > > >
> > > > > > I tried as you said. But the BMP imgaes are not displayed in
> > > > > > the report. I tried the same with crystal reports and it
> > > > > > worked.
> > > > > >
> > > > > > "Chris McGuigan" wrote:
> > > > > >
> > > > > > > Having re-read your post, I should clarify that I assume you
> > > > > > > mean bitmaps stored in the database as BLOB fields?
> > > > > > > If you mean external files then again yes it can, either
> > > > > > > using a field containing the url/unc path or some other
> > > > > > > direct path are expression to the path.
> > > > > > >
> > > > > > > Chris
> > > > > > >
> > > > > > >
> > > > > > > Chris McGuigan wrote:
> > > > > > >
> > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > You'll need an image control and choose 'Database' as the
> > > > > > > > 'Source' and the appropriate column name as the 'Value'.
> > > > > > > > Also select the appropriate MIME type.
> > > > > > > >
> > > > > > > > Chris
> > > > > > > >
> > > > > > > > Sapnil wrote:
> > > > > > > >
> > > > > > > > > Hi,
> > > > > > > > >
> > > > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > > > >
> > > > > > > > > Sapnil
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>|||What exactly do you get in your image control, have you tried deploying
it? The VS Preview renderer is not the same as the RM renderer.
Maybe you could look at the code around the image control in the sample
report and that on your report for some clues.
Regards
Chris
Sapnil wrote:
> I am using SP2
>
> "Chris McGuigan" wrote:
> > Hi Sapnil,
> > I'm a bit stumped I'm afraid. What exactly are you getting?
> >
> > In terms of evaluation, I'm an ex-Crystal user who switched to RS
> > last February and have had little need to revert back since.
> > That's not to say that there are things Crystal doesn't do better
> > than RS, but for my environment, RS has many more advantages. I'm
> > playing with RS2005 now (due to be "launched" early November) and
> > it's looking good with ReportBuilder filling many of the RS's
> > shortcomings against Crystal. This is a bit off topic now but if
> > you trawl this newsgroup you'll see plenty of worthwhile exchanges
> > on the pro's and con's of various reporting tools.
> >
> > Obviously this image issue is a problem for you! Are you using SP1
> > or SP2?
> >
> > Chris
> >
> >
> >
> > Sapnil wrote:
> >
> > > I have tried all MIME types.
> > > And you are right, its working with crystal reports.
> > > Actually I am in the process of evaluating repoting tools.
> > >
> > > "Chris McGuigan" wrote:
> > >
> > > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > > I've never actually used Blob fields. So I'm going by the book
> > > > rather than experience! Have you tried all the different MIME
> > > > types against your data? Are you 100% sure your fields contain
> > > > bitmaps and not gifs or jpegs? I guess you are because you've
> > > > had it working in Crystal, but it's worth a check!
> > > >
> > > > Regards
> > > > Chris
> > > >
> > > >
> > > > Sapnil wrote:
> > > >
> > > > > Chirs,
> > > > > I have tried the sample product catalog sample report and it
> > > > > works for me too. But If I am not wrong the images stored in
> > > > > the BLOB fieds are of type GIF I tried the same thing with
> > > > > the Northwind database, trying to display the employees on
> > > > > the report, but there seems to be some problem.
> > > > >
> > > > > Sapnil
> > > > >
> > > > > "Chris McGuigan" wrote:
> > > > >
> > > > > > Sapnil,
> > > > > > I've just checked the Sample Report, Product Catalogue. This
> > > > > > uses this feature and works. It shows an image for each
> > > > > > stock item and the image is taken directly from the
> > > > > > database. I suspect you've a setting wrong.
> > > > > >
> > > > > > I suggest you load and take a look at this sample report.
> > > > > > Look up sample reports in BOL for details.
> > > > > >
> > > > > > In the sample the image is inside a rectangle, which may
> > > > > > confuse you when trying to select it. In the properties
> > > > > > pane, in the drop-down list of property names select
> > > > > > ProdPhoto.
> > > > > >
> > > > > > Chris
> > > > > >
> > > > > >
> > > > > > Sapnil wrote:
> > > > > >
> > > > > > > I tried as you said. But the BMP imgaes are not displayed
> > > > > > > in the report. I tried the same with crystal reports and
> > > > > > > it worked.
> > > > > > >
> > > > > > > "Chris McGuigan" wrote:
> > > > > > >
> > > > > > > > Having re-read your post, I should clarify that I
> > > > > > > > assume you mean bitmaps stored in the database as BLOB
> > > > > > > > fields? If you mean external files then again yes it
> > > > > > > > can, either using a field containing the url/unc path
> > > > > > > > or some other direct path are expression to the path.
> > > > > > > >
> > > > > > > > Chris
> > > > > > > >
> > > > > > > >
> > > > > > > > Chris McGuigan wrote:
> > > > > > > >
> > > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > > You'll need an image control and choose 'Database' as
> > > > > > > > > the 'Source' and the appropriate column name as the
> > > > > > > > > 'Value'. Also select the appropriate MIME type.
> > > > > > > > >
> > > > > > > > > Chris
> > > > > > > > >
> > > > > > > > > Sapnil wrote:
> > > > > > > > >
> > > > > > > > > > Hi,
> > > > > > > > > >
> > > > > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > > > > >
> > > > > > > > > > Sapnil
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >|||The images are not displayed on the report, instead I get X marks on the
report.
I checked the RDL for the reports and there is no difference
Pretty strange
"Chris McGuigan" wrote:
> What exactly do you get in your image control, have you tried deploying
> it? The VS Preview renderer is not the same as the RM renderer.
> Maybe you could look at the code around the image control in the sample
> report and that on your report for some clues.
> Regards
> Chris
>
> Sapnil wrote:
> > I am using SP2
> >
> >
> > "Chris McGuigan" wrote:
> >
> > > Hi Sapnil,
> > > I'm a bit stumped I'm afraid. What exactly are you getting?
> > >
> > > In terms of evaluation, I'm an ex-Crystal user who switched to RS
> > > last February and have had little need to revert back since.
> > > That's not to say that there are things Crystal doesn't do better
> > > than RS, but for my environment, RS has many more advantages. I'm
> > > playing with RS2005 now (due to be "launched" early November) and
> > > it's looking good with ReportBuilder filling many of the RS's
> > > shortcomings against Crystal. This is a bit off topic now but if
> > > you trawl this newsgroup you'll see plenty of worthwhile exchanges
> > > on the pro's and con's of various reporting tools.
> > >
> > > Obviously this image issue is a problem for you! Are you using SP1
> > > or SP2?
> > >
> > > Chris
> > >
> > >
> > >
> > > Sapnil wrote:
> > >
> > > > I have tried all MIME types.
> > > > And you are right, its working with crystal reports.
> > > > Actually I am in the process of evaluating repoting tools.
> > > >
> > > > "Chris McGuigan" wrote:
> > > >
> > > > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > > > I've never actually used Blob fields. So I'm going by the book
> > > > > rather than experience! Have you tried all the different MIME
> > > > > types against your data? Are you 100% sure your fields contain
> > > > > bitmaps and not gifs or jpegs? I guess you are because you've
> > > > > had it working in Crystal, but it's worth a check!
> > > > >
> > > > > Regards
> > > > > Chris
> > > > >
> > > > >
> > > > > Sapnil wrote:
> > > > >
> > > > > > Chirs,
> > > > > > I have tried the sample product catalog sample report and it
> > > > > > works for me too. But If I am not wrong the images stored in
> > > > > > the BLOB fieds are of type GIF I tried the same thing with
> > > > > > the Northwind database, trying to display the employees on
> > > > > > the report, but there seems to be some problem.
> > > > > >
> > > > > > Sapnil
> > > > > >
> > > > > > "Chris McGuigan" wrote:
> > > > > >
> > > > > > > Sapnil,
> > > > > > > I've just checked the Sample Report, Product Catalogue. This
> > > > > > > uses this feature and works. It shows an image for each
> > > > > > > stock item and the image is taken directly from the
> > > > > > > database. I suspect you've a setting wrong.
> > > > > > >
> > > > > > > I suggest you load and take a look at this sample report.
> > > > > > > Look up sample reports in BOL for details.
> > > > > > >
> > > > > > > In the sample the image is inside a rectangle, which may
> > > > > > > confuse you when trying to select it. In the properties
> > > > > > > pane, in the drop-down list of property names select
> > > > > > > ProdPhoto.
> > > > > > >
> > > > > > > Chris
> > > > > > >
> > > > > > >
> > > > > > > Sapnil wrote:
> > > > > > >
> > > > > > > > I tried as you said. But the BMP imgaes are not displayed
> > > > > > > > in the report. I tried the same with crystal reports and
> > > > > > > > it worked.
> > > > > > > >
> > > > > > > > "Chris McGuigan" wrote:
> > > > > > > >
> > > > > > > > > Having re-read your post, I should clarify that I
> > > > > > > > > assume you mean bitmaps stored in the database as BLOB
> > > > > > > > > fields? If you mean external files then again yes it
> > > > > > > > > can, either using a field containing the url/unc path
> > > > > > > > > or some other direct path are expression to the path.
> > > > > > > > >
> > > > > > > > > Chris
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Chris McGuigan wrote:
> > > > > > > > >
> > > > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > > > You'll need an image control and choose 'Database' as
> > > > > > > > > > the 'Source' and the appropriate column name as the
> > > > > > > > > > 'Value'. Also select the appropriate MIME type.
> > > > > > > > > >
> > > > > > > > > > Chris
> > > > > > > > > >
> > > > > > > > > > Sapnil wrote:
> > > > > > > > > >
> > > > > > > > > > > Hi,
> > > > > > > > > > >
> > > > > > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > > > > > >
> > > > > > > > > > > Sapnil
> > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>|||The only thing that comes to mind is some minor difference in the way
the bitmap is stored in the DB compared to what Microsoft expects.
It may be worth raising a support incident with Microsoft if you have
an MSDN subscription. It would be a shame for you to decide not to use
RS because of this one glitch. In an enterpirise environment RS is far
better than Crystal, in my view, not to mention a whole lot cheaper if
you already use MS SQL Server.
Chris
Sapnil wrote:
> The images are not displayed on the report, instead I get X marks on
> the report.
> I checked the RDL for the reports and there is no difference
> Pretty strange
> "Chris McGuigan" wrote:
> > What exactly do you get in your image control, have you tried
> > deploying it? The VS Preview renderer is not the same as the RM
> > renderer.
> >
> > Maybe you could look at the code around the image control in the
> > sample report and that on your report for some clues.
> >
> > Regards
> > Chris
> >
> >
> >
> > Sapnil wrote:
> >
> > > I am using SP2
> > >
> > >
> > > "Chris McGuigan" wrote:
> > >
> > > > Hi Sapnil,
> > > > I'm a bit stumped I'm afraid. What exactly are you getting?
> > > >
> > > > In terms of evaluation, I'm an ex-Crystal user who switched to
> > > > RS last February and have had little need to revert back since.
> > > > That's not to say that there are things Crystal doesn't do
> > > > better than RS, but for my environment, RS has many more
> > > > advantages. I'm playing with RS2005 now (due to be "launched"
> > > > early November) and it's looking good with ReportBuilder
> > > > filling many of the RS's shortcomings against Crystal. This is
> > > > a bit off topic now but if you trawl this newsgroup you'll see
> > > > plenty of worthwhile exchanges on the pro's and con's of
> > > > various reporting tools.
> > > >
> > > > Obviously this image issue is a problem for you! Are you using
> > > > SP1 or SP2?
> > > >
> > > > Chris
> > > >
> > > >
> > > >
> > > > Sapnil wrote:
> > > >
> > > > > I have tried all MIME types.
> > > > > And you are right, its working with crystal reports.
> > > > > Actually I am in the process of evaluating repoting tools.
> > > > >
> > > > > "Chris McGuigan" wrote:
> > > > >
> > > > > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > > > > I've never actually used Blob fields. So I'm going by the
> > > > > > book rather than experience! Have you tried all the
> > > > > > different MIME types against your data? Are you 100% sure
> > > > > > your fields contain bitmaps and not gifs or jpegs? I guess
> > > > > > you are because you've had it working in Crystal, but it's
> > > > > > worth a check!
> > > > > >
> > > > > > Regards
> > > > > > Chris
> > > > > >
> > > > > >
> > > > > > Sapnil wrote:
> > > > > >
> > > > > > > Chirs,
> > > > > > > I have tried the sample product catalog sample report and
> > > > > > > it works for me too. But If I am not wrong the images
> > > > > > > stored in the BLOB fieds are of type GIF I tried the same
> > > > > > > thing with the Northwind database, trying to display the
> > > > > > > employees on the report, but there seems to be some
> > > > > > > problem.
> > > > > > >
> > > > > > > Sapnil
> > > > > > >
> > > > > > > "Chris McGuigan" wrote:
> > > > > > >
> > > > > > > > Sapnil,
> > > > > > > > I've just checked the Sample Report, Product Catalogue.
> > > > > > > > This uses this feature and works. It shows an image for
> > > > > > > > each stock item and the image is taken directly from the
> > > > > > > > database. I suspect you've a setting wrong.
> > > > > > > >
> > > > > > > > I suggest you load and take a look at this sample
> > > > > > > > report. Look up sample reports in BOL for details.
> > > > > > > >
> > > > > > > > In the sample the image is inside a rectangle, which may
> > > > > > > > confuse you when trying to select it. In the properties
> > > > > > > > pane, in the drop-down list of property names select
> > > > > > > > ProdPhoto.
> > > > > > > >
> > > > > > > > Chris
> > > > > > > >
> > > > > > > >
> > > > > > > > Sapnil wrote:
> > > > > > > >
> > > > > > > > > I tried as you said. But the BMP imgaes are not
> > > > > > > > > displayed in the report. I tried the same with
> > > > > > > > > crystal reports and it worked.
> > > > > > > > >
> > > > > > > > > "Chris McGuigan" wrote:
> > > > > > > > >
> > > > > > > > > > Having re-read your post, I should clarify that I
> > > > > > > > > > assume you mean bitmaps stored in the database as
> > > > > > > > > > BLOB fields? If you mean external files then again
> > > > > > > > > > yes it can, either using a field containing the
> > > > > > > > > > url/unc path or some other direct path are
> > > > > > > > > > expression to the path.
> > > > > > > > > >
> > > > > > > > > > Chris
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Chris McGuigan wrote:
> > > > > > > > > >
> > > > > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > > > > You'll need an image control and choose
> > > > > > > > > > > 'Database' as the 'Source' and the appropriate
> > > > > > > > > > > column name as the 'Value'. Also select the
> > > > > > > > > > > appropriate MIME type.
> > > > > > > > > > >
> > > > > > > > > > > Chris
> > > > > > > > > > >
> > > > > > > > > > > Sapnil wrote:
> > > > > > > > > > >
> > > > > > > > > > > > Hi,
> > > > > > > > > > > >
> > > > > > > > > > > > Does Sql reporting services support Bmp BLOB
> > > > > > > > > > > > files?
> > > > > > > > > > > >
> > > > > > > > > > > > Sapnil
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >|||Hi Chris,
Thankyou very much for you comments
Sapnil
"Chris McGuigan" wrote:
> The only thing that comes to mind is some minor difference in the way
> the bitmap is stored in the DB compared to what Microsoft expects.
> It may be worth raising a support incident with Microsoft if you have
> an MSDN subscription. It would be a shame for you to decide not to use
> RS because of this one glitch. In an enterpirise environment RS is far
> better than Crystal, in my view, not to mention a whole lot cheaper if
> you already use MS SQL Server.
> Chris
>
> Sapnil wrote:
> > The images are not displayed on the report, instead I get X marks on
> > the report.
> > I checked the RDL for the reports and there is no difference
> > Pretty strange
> >
> > "Chris McGuigan" wrote:
> >
> > > What exactly do you get in your image control, have you tried
> > > deploying it? The VS Preview renderer is not the same as the RM
> > > renderer.
> > >
> > > Maybe you could look at the code around the image control in the
> > > sample report and that on your report for some clues.
> > >
> > > Regards
> > > Chris
> > >
> > >
> > >
> > > Sapnil wrote:
> > >
> > > > I am using SP2
> > > >
> > > >
> > > > "Chris McGuigan" wrote:
> > > >
> > > > > Hi Sapnil,
> > > > > I'm a bit stumped I'm afraid. What exactly are you getting?
> > > > >
> > > > > In terms of evaluation, I'm an ex-Crystal user who switched to
> > > > > RS last February and have had little need to revert back since.
> > > > > That's not to say that there are things Crystal doesn't do
> > > > > better than RS, but for my environment, RS has many more
> > > > > advantages. I'm playing with RS2005 now (due to be "launched"
> > > > > early November) and it's looking good with ReportBuilder
> > > > > filling many of the RS's shortcomings against Crystal. This is
> > > > > a bit off topic now but if you trawl this newsgroup you'll see
> > > > > plenty of worthwhile exchanges on the pro's and con's of
> > > > > various reporting tools.
> > > > >
> > > > > Obviously this image issue is a problem for you! Are you using
> > > > > SP1 or SP2?
> > > > >
> > > > > Chris
> > > > >
> > > > >
> > > > >
> > > > > Sapnil wrote:
> > > > >
> > > > > > I have tried all MIME types.
> > > > > > And you are right, its working with crystal reports.
> > > > > > Actually I am in the process of evaluating repoting tools.
> > > > > >
> > > > > > "Chris McGuigan" wrote:
> > > > > >
> > > > > > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > > > > > I've never actually used Blob fields. So I'm going by the
> > > > > > > book rather than experience! Have you tried all the
> > > > > > > different MIME types against your data? Are you 100% sure
> > > > > > > your fields contain bitmaps and not gifs or jpegs? I guess
> > > > > > > you are because you've had it working in Crystal, but it's
> > > > > > > worth a check!
> > > > > > >
> > > > > > > Regards
> > > > > > > Chris
> > > > > > >
> > > > > > >
> > > > > > > Sapnil wrote:
> > > > > > >
> > > > > > > > Chirs,
> > > > > > > > I have tried the sample product catalog sample report and
> > > > > > > > it works for me too. But If I am not wrong the images
> > > > > > > > stored in the BLOB fieds are of type GIF I tried the same
> > > > > > > > thing with the Northwind database, trying to display the
> > > > > > > > employees on the report, but there seems to be some
> > > > > > > > problem.
> > > > > > > >
> > > > > > > > Sapnil
> > > > > > > >
> > > > > > > > "Chris McGuigan" wrote:
> > > > > > > >
> > > > > > > > > Sapnil,
> > > > > > > > > I've just checked the Sample Report, Product Catalogue.
> > > > > > > > > This uses this feature and works. It shows an image for
> > > > > > > > > each stock item and the image is taken directly from the
> > > > > > > > > database. I suspect you've a setting wrong.
> > > > > > > > >
> > > > > > > > > I suggest you load and take a look at this sample
> > > > > > > > > report. Look up sample reports in BOL for details.
> > > > > > > > >
> > > > > > > > > In the sample the image is inside a rectangle, which may
> > > > > > > > > confuse you when trying to select it. In the properties
> > > > > > > > > pane, in the drop-down list of property names select
> > > > > > > > > ProdPhoto.
> > > > > > > > >
> > > > > > > > > Chris
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Sapnil wrote:
> > > > > > > > >
> > > > > > > > > > I tried as you said. But the BMP imgaes are not
> > > > > > > > > > displayed in the report. I tried the same with
> > > > > > > > > > crystal reports and it worked.
> > > > > > > > > >
> > > > > > > > > > "Chris McGuigan" wrote:
> > > > > > > > > >
> > > > > > > > > > > Having re-read your post, I should clarify that I
> > > > > > > > > > > assume you mean bitmaps stored in the database as
> > > > > > > > > > > BLOB fields? If you mean external files then again
> > > > > > > > > > > yes it can, either using a field containing the
> > > > > > > > > > > url/unc path or some other direct path are
> > > > > > > > > > > expression to the path.
> > > > > > > > > > >
> > > > > > > > > > > Chris
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > Chris McGuigan wrote:
> > > > > > > > > > >
> > > > > > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > > > > > You'll need an image control and choose
> > > > > > > > > > > > 'Database' as the 'Source' and the appropriate
> > > > > > > > > > > > column name as the 'Value'. Also select the
> > > > > > > > > > > > appropriate MIME type.
> > > > > > > > > > > >
> > > > > > > > > > > > Chris
> > > > > > > > > > > >
> > > > > > > > > > > > Sapnil wrote:
> > > > > > > > > > > >
> > > > > > > > > > > > > Hi,
> > > > > > > > > > > > >
> > > > > > > > > > > > > Does Sql reporting services support Bmp BLOB
> > > > > > > > > > > > > files?
> > > > > > > > > > > > >
> > > > > > > > > > > > > Sapnil
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>