I have a bit field in my data source that displays as true/false on my
report. I can't see how to set this so that it displays as 1 or 0. In
Visual Studio, can someone help?=iif (Fields!yourData.value = "True", 1, 0)
"beeyule" wrote:
> I have a bit field in my data source that displays as true/false on my
> report. I can't see how to set this so that it displays as 1 or 0. In
> Visual Studio, can someone help?
Showing posts with label fields. Show all posts
Showing posts with label fields. Show all posts
Thursday, March 29, 2012
Tuesday, March 27, 2012
Boolean datatypes
Hi All,
How to create fields with boolean datatypes? There seems to be no 'boolean'
SQL data type. Can the bit datatype be used to store 0 for false and 1 for
true?
Thanks,
kdkd,
There are no boolean datatype in SQL Server 7/2000. You can use bit (or
another "numeric" datatype, tinyint for example) or use a char(1)
storing "F"/"T" (or "Y"/"N" or whatever). Bit is normally "converted" to
a boolean by ADO (but I'm not sure if bit=0 is TRUE or FALSE, I _think_
it "means" FALSE...).
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
kd wrote:
> Hi All,
> How to create fields with boolean datatypes? There seems to be no 'boolean'
> SQL data type. Can the bit datatype be used to store 0 for false and 1 for
> true?
> Thanks,
> kd|||You are correct that there is no Boolean datatype in SQL Server. You can choose whatever you want to
represent what you want to call "true" and "false", these will only be values of that datatype for
SQL Server. Some programming environments will consider bit as Boolean and bind such automatically;
but to SQL Server, bit is a numeric datatype restricted to 0 and 1 (*). There has been several
discussions ion this group and .programming on the subject and I recommend that you check the
archives and determine whether you want to use bit or, for example, char(1) with a check constraint
restricting to 't' pr 'f', 'y' or 'n' etc (see the old discussions other options exists).
(*) One strange thing with the bit datatype in SQL Server is that you will not get an overflow if
you assign, for instance, the value 2 to a bit datatype. The result will be 1.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"kd" <kd@.discussions.microsoft.com> wrote in message
news:3F70CFF6-3B66-497A-B2D0-5A98E9D6F597@.microsoft.com...
> Hi All,
> How to create fields with boolean datatypes? There seems to be no 'boolean'
> SQL data type. Can the bit datatype be used to store 0 for false and 1 for
> true?
> Thanks,
> kd|||In addition to the other comments... When deciding whether to use bit or
char(1), you are (essentially) weighing the space savings of bit, versus the
ease of printing with a char(1)( no conversion on output)...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"kd" <kd@.discussions.microsoft.com> wrote in message
news:3F70CFF6-3B66-497A-B2D0-5A98E9D6F597@.microsoft.com...
> Hi All,
> How to create fields with boolean datatypes? There seems to be no
> 'boolean'
> SQL data type. Can the bit datatype be used to store 0 for false and 1 for
> true?
> Thanks,
> kd
How to create fields with boolean datatypes? There seems to be no 'boolean'
SQL data type. Can the bit datatype be used to store 0 for false and 1 for
true?
Thanks,
kdkd,
There are no boolean datatype in SQL Server 7/2000. You can use bit (or
another "numeric" datatype, tinyint for example) or use a char(1)
storing "F"/"T" (or "Y"/"N" or whatever). Bit is normally "converted" to
a boolean by ADO (but I'm not sure if bit=0 is TRUE or FALSE, I _think_
it "means" FALSE...).
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
kd wrote:
> Hi All,
> How to create fields with boolean datatypes? There seems to be no 'boolean'
> SQL data type. Can the bit datatype be used to store 0 for false and 1 for
> true?
> Thanks,
> kd|||You are correct that there is no Boolean datatype in SQL Server. You can choose whatever you want to
represent what you want to call "true" and "false", these will only be values of that datatype for
SQL Server. Some programming environments will consider bit as Boolean and bind such automatically;
but to SQL Server, bit is a numeric datatype restricted to 0 and 1 (*). There has been several
discussions ion this group and .programming on the subject and I recommend that you check the
archives and determine whether you want to use bit or, for example, char(1) with a check constraint
restricting to 't' pr 'f', 'y' or 'n' etc (see the old discussions other options exists).
(*) One strange thing with the bit datatype in SQL Server is that you will not get an overflow if
you assign, for instance, the value 2 to a bit datatype. The result will be 1.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"kd" <kd@.discussions.microsoft.com> wrote in message
news:3F70CFF6-3B66-497A-B2D0-5A98E9D6F597@.microsoft.com...
> Hi All,
> How to create fields with boolean datatypes? There seems to be no 'boolean'
> SQL data type. Can the bit datatype be used to store 0 for false and 1 for
> true?
> Thanks,
> kd|||In addition to the other comments... When deciding whether to use bit or
char(1), you are (essentially) weighing the space savings of bit, versus the
ease of printing with a char(1)( no conversion on output)...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"kd" <kd@.discussions.microsoft.com> wrote in message
news:3F70CFF6-3B66-497A-B2D0-5A98E9D6F597@.microsoft.com...
> Hi All,
> How to create fields with boolean datatypes? There seems to be no
> 'boolean'
> SQL data type. Can the bit datatype be used to store 0 for false and 1 for
> true?
> Thanks,
> kd
Boolean datatypes
Hi All,
How to create fields with boolean datatypes? There seems to be no 'boolean'
SQL data type. Can the bit datatype be used to store 0 for false and 1 for
true?
Thanks,
kd
kd,
There are no boolean datatype in SQL Server 7/2000. You can use bit (or
another "numeric" datatype, tinyint for example) or use a char(1)
storing "F"/"T" (or "Y"/"N" or whatever). Bit is normally "converted" to
a boolean by ADO (but I'm not sure if bit=0 is TRUE or FALSE, I _think_
it "means" FALSE...).
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
kd wrote:
> Hi All,
> How to create fields with boolean datatypes? There seems to be no 'boolean'
> SQL data type. Can the bit datatype be used to store 0 for false and 1 for
> true?
> Thanks,
> kd
|||You are correct that there is no Boolean datatype in SQL Server. You can choose whatever you want to
represent what you want to call "true" and "false", these will only be values of that datatype for
SQL Server. Some programming environments will consider bit as Boolean and bind such automatically;
but to SQL Server, bit is a numeric datatype restricted to 0 and 1 (*). There has been several
discussions ion this group and .programming on the subject and I recommend that you check the
archives and determine whether you want to use bit or, for example, char(1) with a check constraint
restricting to 't' pr 'f', 'y' or 'n' etc (see the old discussions other options exists).
(*) One strange thing with the bit datatype in SQL Server is that you will not get an overflow if
you assign, for instance, the value 2 to a bit datatype. The result will be 1.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"kd" <kd@.discussions.microsoft.com> wrote in message
news:3F70CFF6-3B66-497A-B2D0-5A98E9D6F597@.microsoft.com...
> Hi All,
> How to create fields with boolean datatypes? There seems to be no 'boolean'
> SQL data type. Can the bit datatype be used to store 0 for false and 1 for
> true?
> Thanks,
> kd
|||In addition to the other comments... When deciding whether to use bit or
char(1), you are (essentially) weighing the space savings of bit, versus the
ease of printing with a char(1)( no conversion on output)...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"kd" <kd@.discussions.microsoft.com> wrote in message
news:3F70CFF6-3B66-497A-B2D0-5A98E9D6F597@.microsoft.com...
> Hi All,
> How to create fields with boolean datatypes? There seems to be no
> 'boolean'
> SQL data type. Can the bit datatype be used to store 0 for false and 1 for
> true?
> Thanks,
> kd
How to create fields with boolean datatypes? There seems to be no 'boolean'
SQL data type. Can the bit datatype be used to store 0 for false and 1 for
true?
Thanks,
kd
kd,
There are no boolean datatype in SQL Server 7/2000. You can use bit (or
another "numeric" datatype, tinyint for example) or use a char(1)
storing "F"/"T" (or "Y"/"N" or whatever). Bit is normally "converted" to
a boolean by ADO (but I'm not sure if bit=0 is TRUE or FALSE, I _think_
it "means" FALSE...).
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
kd wrote:
> Hi All,
> How to create fields with boolean datatypes? There seems to be no 'boolean'
> SQL data type. Can the bit datatype be used to store 0 for false and 1 for
> true?
> Thanks,
> kd
|||You are correct that there is no Boolean datatype in SQL Server. You can choose whatever you want to
represent what you want to call "true" and "false", these will only be values of that datatype for
SQL Server. Some programming environments will consider bit as Boolean and bind such automatically;
but to SQL Server, bit is a numeric datatype restricted to 0 and 1 (*). There has been several
discussions ion this group and .programming on the subject and I recommend that you check the
archives and determine whether you want to use bit or, for example, char(1) with a check constraint
restricting to 't' pr 'f', 'y' or 'n' etc (see the old discussions other options exists).
(*) One strange thing with the bit datatype in SQL Server is that you will not get an overflow if
you assign, for instance, the value 2 to a bit datatype. The result will be 1.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"kd" <kd@.discussions.microsoft.com> wrote in message
news:3F70CFF6-3B66-497A-B2D0-5A98E9D6F597@.microsoft.com...
> Hi All,
> How to create fields with boolean datatypes? There seems to be no 'boolean'
> SQL data type. Can the bit datatype be used to store 0 for false and 1 for
> true?
> Thanks,
> kd
|||In addition to the other comments... When deciding whether to use bit or
char(1), you are (essentially) weighing the space savings of bit, versus the
ease of printing with a char(1)( no conversion on output)...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"kd" <kd@.discussions.microsoft.com> wrote in message
news:3F70CFF6-3B66-497A-B2D0-5A98E9D6F597@.microsoft.com...
> Hi All,
> How to create fields with boolean datatypes? There seems to be no
> 'boolean'
> SQL data type. Can the bit datatype be used to store 0 for false and 1 for
> true?
> Thanks,
> kd
Boolean datatypes
Hi All,
How to create fields with boolean datatypes? There seems to be no 'boolean'
SQL data type. Can the bit datatype be used to store 0 for false and 1 for
true?
Thanks,
kdkd,
There are no boolean datatype in SQL Server 7/2000. You can use bit (or
another "numeric" datatype, tinyint for example) or use a char(1)
storing "F"/"T" (or "Y"/"N" or whatever). Bit is normally "converted" to
a boolean by ADO (but I'm not sure if bit=0 is TRUE or FALSE, I _think_
it "means" FALSE...).
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
kd wrote:
> Hi All,
> How to create fields with boolean datatypes? There seems to be no 'boolean
'
> SQL data type. Can the bit datatype be used to store 0 for false and 1 for
> true?
> Thanks,
> kd|||You are correct that there is no Boolean datatype in SQL Server. You can cho
ose whatever you want to
represent what you want to call "true" and "false", these will only be value
s of that datatype for
SQL Server. Some programming environments will consider bit as Boolean and b
ind such automatically;
but to SQL Server, bit is a numeric datatype restricted to 0 and 1 (*). Ther
e has been several
discussions ion this group and .programming on the subject and I recommend t
hat you check the
archives and determine whether you want to use bit or, for example, char(1)
with a check constraint
restricting to 't' pr 'f', 'y' or 'n' etc (see the old discussions other opt
ions exists).
(*) One strange thing with the bit datatype in SQL Server is that you will n
ot get an overflow if
you assign, for instance, the value 2 to a bit datatype. The result will be
1.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"kd" <kd@.discussions.microsoft.com> wrote in message
news:3F70CFF6-3B66-497A-B2D0-5A98E9D6F597@.microsoft.com...
> Hi All,
> How to create fields with boolean datatypes? There seems to be no 'boolean
'
> SQL data type. Can the bit datatype be used to store 0 for false and 1 for
> true?
> Thanks,
> kd|||In addition to the other comments... When deciding whether to use bit or
char(1), you are (essentially) weighing the space savings of bit, versus the
ease of printing with a char(1)( no conversion on output)...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"kd" <kd@.discussions.microsoft.com> wrote in message
news:3F70CFF6-3B66-497A-B2D0-5A98E9D6F597@.microsoft.com...
> Hi All,
> How to create fields with boolean datatypes? There seems to be no
> 'boolean'
> SQL data type. Can the bit datatype be used to store 0 for false and 1 for
> true?
> Thanks,
> kd
How to create fields with boolean datatypes? There seems to be no 'boolean'
SQL data type. Can the bit datatype be used to store 0 for false and 1 for
true?
Thanks,
kdkd,
There are no boolean datatype in SQL Server 7/2000. You can use bit (or
another "numeric" datatype, tinyint for example) or use a char(1)
storing "F"/"T" (or "Y"/"N" or whatever). Bit is normally "converted" to
a boolean by ADO (but I'm not sure if bit=0 is TRUE or FALSE, I _think_
it "means" FALSE...).
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
kd wrote:
> Hi All,
> How to create fields with boolean datatypes? There seems to be no 'boolean
'
> SQL data type. Can the bit datatype be used to store 0 for false and 1 for
> true?
> Thanks,
> kd|||You are correct that there is no Boolean datatype in SQL Server. You can cho
ose whatever you want to
represent what you want to call "true" and "false", these will only be value
s of that datatype for
SQL Server. Some programming environments will consider bit as Boolean and b
ind such automatically;
but to SQL Server, bit is a numeric datatype restricted to 0 and 1 (*). Ther
e has been several
discussions ion this group and .programming on the subject and I recommend t
hat you check the
archives and determine whether you want to use bit or, for example, char(1)
with a check constraint
restricting to 't' pr 'f', 'y' or 'n' etc (see the old discussions other opt
ions exists).
(*) One strange thing with the bit datatype in SQL Server is that you will n
ot get an overflow if
you assign, for instance, the value 2 to a bit datatype. The result will be
1.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"kd" <kd@.discussions.microsoft.com> wrote in message
news:3F70CFF6-3B66-497A-B2D0-5A98E9D6F597@.microsoft.com...
> Hi All,
> How to create fields with boolean datatypes? There seems to be no 'boolean
'
> SQL data type. Can the bit datatype be used to store 0 for false and 1 for
> true?
> Thanks,
> kd|||In addition to the other comments... When deciding whether to use bit or
char(1), you are (essentially) weighing the space savings of bit, versus the
ease of printing with a char(1)( no conversion on output)...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"kd" <kd@.discussions.microsoft.com> wrote in message
news:3F70CFF6-3B66-497A-B2D0-5A98E9D6F597@.microsoft.com...
> Hi All,
> How to create fields with boolean datatypes? There seems to be no
> 'boolean'
> SQL data type. Can the bit datatype be used to store 0 for false and 1 for
> true?
> Thanks,
> kd
Boolean Calculated Fields in SQL Server
Hi
This may seem amazing and a stupid question but:
Consider there is a parent table A and child table B and we want to write a query that has some fields from A and a calculated field which indicates whether A has any child record in B or not. The Value 1 means Yes and 0 means No. Has anybody an idea to write this in SQL Server?select foo
, bar
, fap
, case when exists
( select 1 from tableB
where Afk = tableA.pk )
then 1 else 0 end as calcfield
from tableA|||Originally posted by r937
select foo
, bar
, fap
, case when exists
( select 1 from tableB
where Afk = tableA.pk )
then 1 else 0 end as calcfield
from tableA
This may seem amazing and a stupid question but:
Consider there is a parent table A and child table B and we want to write a query that has some fields from A and a calculated field which indicates whether A has any child record in B or not. The Value 1 means Yes and 0 means No. Has anybody an idea to write this in SQL Server?select foo
, bar
, fap
, case when exists
( select 1 from tableB
where Afk = tableA.pk )
then 1 else 0 end as calcfield
from tableA|||Originally posted by r937
select foo
, bar
, fap
, case when exists
( select 1 from tableB
where Afk = tableA.pk )
then 1 else 0 end as calcfield
from tableA
Monday, March 19, 2012
Body is overlapping header
Hello~
I have a report with a header and body.
The header has the usual stuff, title, logo, parameter fields, etc
The body is a table.
When I run the report, the table overlaps the header... I don't
understand why this is happening...
So... what I'm doing right now is I have to leave an inch of blank
space just before the table in the body. But cosmetically the report
doesnt look right...
Thanks!On Jul 12, 4:55 pm, OogleGoogle <Yvonh...@.gmail.com> wrote:
> Hello~
> I have a report with a header and body.
> The header has the usual stuff, title, logo, parameter fields, etc
> The body is a table.
> When I run the report, the table overlaps the header... I don't
> understand why this is happening...
> So... what I'm doing right now is I have to leave an inch of blank
> space just before the table in the body. But cosmetically the report
> doesnt look right...
> Thanks!
This seems like a unique situation. I would suggest putting the
contents of the header into one rectangle and doing the same for the
table control in the body. Also, you might want to right-click inside
the blank area of the header -> select Properties -> and increase the
BorderWidth. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Jul 12, 9:40 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Jul 12, 4:55 pm, OogleGoogle <Yvonh...@.gmail.com> wrote:
> > Hello~
> > I have a report with a header and body.
> > The header has the usual stuff, title, logo, parameter fields, etc
> > The body is a table.
> > When I run the report, the table overlaps the header... I don't
> > understand why this is happening...
> > So... what I'm doing right now is I have to leave an inch of blank
> > space just before the table in the body. But cosmetically the report
> > doesnt look right...
> > Thanks!
> This seems like a unique situation. I would suggest putting the
> contents of the header into one rectangle and doing the same for the
> table control in the body. Also, you might want to right-click inside
> the blank area of the header -> select Properties -> and increase the
> BorderWidth. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Under the properties tab for the report itself, try changing the
margins it may or may not help.
I have a report with a header and body.
The header has the usual stuff, title, logo, parameter fields, etc
The body is a table.
When I run the report, the table overlaps the header... I don't
understand why this is happening...
So... what I'm doing right now is I have to leave an inch of blank
space just before the table in the body. But cosmetically the report
doesnt look right...
Thanks!On Jul 12, 4:55 pm, OogleGoogle <Yvonh...@.gmail.com> wrote:
> Hello~
> I have a report with a header and body.
> The header has the usual stuff, title, logo, parameter fields, etc
> The body is a table.
> When I run the report, the table overlaps the header... I don't
> understand why this is happening...
> So... what I'm doing right now is I have to leave an inch of blank
> space just before the table in the body. But cosmetically the report
> doesnt look right...
> Thanks!
This seems like a unique situation. I would suggest putting the
contents of the header into one rectangle and doing the same for the
table control in the body. Also, you might want to right-click inside
the blank area of the header -> select Properties -> and increase the
BorderWidth. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Jul 12, 9:40 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Jul 12, 4:55 pm, OogleGoogle <Yvonh...@.gmail.com> wrote:
> > Hello~
> > I have a report with a header and body.
> > The header has the usual stuff, title, logo, parameter fields, etc
> > The body is a table.
> > When I run the report, the table overlaps the header... I don't
> > understand why this is happening...
> > So... what I'm doing right now is I have to leave an inch of blank
> > space just before the table in the body. But cosmetically the report
> > doesnt look right...
> > Thanks!
> This seems like a unique situation. I would suggest putting the
> contents of the header into one rectangle and doing the same for the
> table control in the body. Also, you might want to right-click inside
> the blank area of the header -> select Properties -> and increase the
> BorderWidth. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Under the properties tab for the report itself, try changing the
margins it may or may not help.
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
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>
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
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>
Saturday, February 25, 2012
Blobs not displayed when printed programatically
Hey folks,
I have a report that I have created. It contains some graphical BLOB fields that are in a database. These blobs were simply dragged and dropped onto the report.
When I preview the report in Crystal Reports the BLOB fields are displayed. When I print the report programatically in VB .net the BLOBs are blank...
Any help would be much apreciated.
ThanksWhat type of image did you use?
Goto support section of this site and see if you find answer
www.BusinessObjects.com
I have a report that I have created. It contains some graphical BLOB fields that are in a database. These blobs were simply dragged and dropped onto the report.
When I preview the report in Crystal Reports the BLOB fields are displayed. When I print the report programatically in VB .net the BLOBs are blank...
Any help would be much apreciated.
ThanksWhat type of image did you use?
Goto support section of this site and see if you find answer
www.BusinessObjects.com
BLOB fields - questions
Hi,
Ok, I am pretty new to BLOB's on SQL SERVER 200 so I need some answeres.
1. Can BLOB Fields hold .doc and/or .pdf documents?
2. If yes, can the contents of the documents be searchable.
3. If documents are updated do BLOB Fields lengtht change/grow dynamically?
I would apreciate any answers in this matter and if possible examples were I can get a better idea on how to configure the BLOB fieds on my DB and/or documentation regarding BLOB's.
Thank you, Pepe.I am far from an expert in BLOB fields but here is my understanding of them. If there are any other gurus out there I will follow with interest as it is not something I have had cause to use/do yet.
1. Being Binary Large Objects I believe a BLOB field should be able to hold a pointer to a .doc or .pdf file.
2. I don't think you can search on the BLOB field as it is only a pointer to the actuall file. I seem to remember form somewhere though that you may be able to search them if it is full text indexed. (Don't quote me on that though)
3. As the table only stores a pointer to the BLOB the length of the field doesn't change when the file changes.
Sorry can't supply any examples for using or configuring BLOB fields|||If you want to learn more on this topic check the following link:
Brief tutorial on using text, ntext, and image data types (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro03/html/sp03g8.asp)|||Hi,
I need to upload .doc files to a BLOB field.
Does anyone know a way to do this? I guess I could use plain Insert commands from SQL Query Analyzer. Alternately, I want to use VB.NET to create an interface for the user to upload this .docs and to retrieve them.
Thank you and I would appreciate some examples if possible.
Pepe.|||ok, since you're saying whatever the website shows is not enough, here is what i came up with when i needed something similar to store various types of documents.
Ok, I am pretty new to BLOB's on SQL SERVER 200 so I need some answeres.
1. Can BLOB Fields hold .doc and/or .pdf documents?
2. If yes, can the contents of the documents be searchable.
3. If documents are updated do BLOB Fields lengtht change/grow dynamically?
I would apreciate any answers in this matter and if possible examples were I can get a better idea on how to configure the BLOB fieds on my DB and/or documentation regarding BLOB's.
Thank you, Pepe.I am far from an expert in BLOB fields but here is my understanding of them. If there are any other gurus out there I will follow with interest as it is not something I have had cause to use/do yet.
1. Being Binary Large Objects I believe a BLOB field should be able to hold a pointer to a .doc or .pdf file.
2. I don't think you can search on the BLOB field as it is only a pointer to the actuall file. I seem to remember form somewhere though that you may be able to search them if it is full text indexed. (Don't quote me on that though)
3. As the table only stores a pointer to the BLOB the length of the field doesn't change when the file changes.
Sorry can't supply any examples for using or configuring BLOB fields|||If you want to learn more on this topic check the following link:
Brief tutorial on using text, ntext, and image data types (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro03/html/sp03g8.asp)|||Hi,
I need to upload .doc files to a BLOB field.
Does anyone know a way to do this? I guess I could use plain Insert commands from SQL Query Analyzer. Alternately, I want to use VB.NET to create an interface for the user to upload this .docs and to retrieve them.
Thank you and I would appreciate some examples if possible.
Pepe.|||ok, since you're saying whatever the website shows is not enough, here is what i came up with when i needed something similar to store various types of documents.
Blob Fields
Can anyone explain me what is blob fields?A blob is a binary large object data type that allows the storage of things like a picture or text in SQL Server , or a pulsing ball of protoplasm from outer space that has an insatiable hunger for human flesh. :)|||rhigdon: don't talk bad about my mama! :)|||Hehe:D
Sunday, February 19, 2012
Blank spaces in my Crosstab
I'm using Crystal 10. I have several summary fields in my crosstab. Three of those columns occasionally show blank spaces (depending on the date range I use), even though I've formated the cells to print a zero if there's no data. Even the borders disappear.
The only thing unique about these 3 columns is that they hold 'sums' rather than 'counts'. The zero formatting works for all other fields.
What can I do to stop this disappearing act. It makes the crosstab look really strange.If any one of the values in Null then Sum is Null
Make sure values are not null
The only thing unique about these 3 columns is that they hold 'sums' rather than 'counts'. The zero formatting works for all other fields.
What can I do to stop this disappearing act. It makes the crosstab look really strange.If any one of the values in Null then Sum is Null
Make sure values are not null
Blank spaces
How can I pass blank spaces for Required fields into database from Forms as
Initial Value , On insert , Post insert options does not work.
Thanks- HAVE YOU TRIED SETTING THE SETTING THE DEFAULT VALUES ON THE FIELDS?
-DO THEY HAVE TO BE SPACES? WOULD 'NULL' VALUES WORK?|||Originally posted by edwinjames
- HAVE YOU TRIED SETTING THE SETTING THE DEFAULT VALUES ON THE FIELDS?
-DO THEY HAVE TO BE SPACES? WOULD 'NULL' VALUES WORK?
1. Forms will not take blank spaces as it will truncate it for varchar2 fiedls .
2. All fields are required.
3. Assigning it from triggers have different problems of record locking.
Initial Value , On insert , Post insert options does not work.
Thanks- HAVE YOU TRIED SETTING THE SETTING THE DEFAULT VALUES ON THE FIELDS?
-DO THEY HAVE TO BE SPACES? WOULD 'NULL' VALUES WORK?|||Originally posted by edwinjames
- HAVE YOU TRIED SETTING THE SETTING THE DEFAULT VALUES ON THE FIELDS?
-DO THEY HAVE TO BE SPACES? WOULD 'NULL' VALUES WORK?
1. Forms will not take blank spaces as it will truncate it for varchar2 fiedls .
2. All fields are required.
3. Assigning it from triggers have different problems of record locking.
Thursday, February 16, 2012
Blank fields in Excel file
I am trying to validate and import a Excel file into the database table using script component. The file contains some blank columns in the sheet. How can I handle the blank spaces while validating the file in the Script Component?
The code is as follows:
Dim excelcmd As OleDbCommand = New OleDbCommand("SELECT Item,TaxCode,ItemDescription FROM [Input$]WHERE LEN(Item)>=0 AND LEN(ItemDescription)>=0 AND LEN(TaxCode)>=0", excelConn)
Dim excelreader As OleDbDataReader = excelcmd.ExecuteReader()
Dim row As Integer = 0
While excelreader.Read()
NameValsBuffer.AddRow()
NameValsBuffer.ItemCode = CStr(IIf(excelreader.GetString(0).Length = 0, "#", excelreader.GetString(0)))
NameValsBuffer.TaxCode = CStr(IIf(excelreader.GetString(1).Length = 0, "#", excelreader.GetString(1)))
NameValsBuffer.ItemDescription = CStr(IIf(excelreader.GetString(2).Length = 0, "#", excelreader.GetString(2)))
NameValsBuffer.CompanyId = Me.Variables.CompanyId
NameValsBuffer.UserId = Me.Variables.UserId
End WhileThe thread title says "blank fields", while the text of the question references "blank columns", and lastly "blank spaces". Can you give a small pictorial representation of the problem? It sounds relatively easy to solve, but I'd like to make what the nature of the issue is first.|||Item ItemDescription TaxCode AAA123 Sample Item 1 XXXXXX BBB255 Sample Item 2 AAAAA CCC366 Sample Item 3 BBBBB XDDD489 Sample Item 4 CCCCC 5EEE Sample Item 5 DDDDDD 6FFF Sample Item 6 EEEEEE GGG Sample Item 7 FFFFFFF HHH Sample Item 8 GGGGG III Sample Item 9 HHHHHH JJJ Sample Item 10 IIIIIIIIIII KKK Sample Item 11 ZZZZZZZZ MMM
The value in the last row for the ItemDescription and TaxCode is null..so thats the problem I am facing when I am trying to validate and upload data.
|||First off, I'm not sure why you're using a script component, when an ADO.NET connection with the following connnection string will work fine:
The code is as follows:
Dim excelcmd As OleDbCommand = New OleDbCommand("SELECT Item,TaxCode,ItemDescription FROM [Input$]WHERE LEN(Item)>=0 AND LEN(ItemDescription)>=0 AND LEN(TaxCode)>=0", excelConn)
Dim excelreader As OleDbDataReader = excelcmd.ExecuteReader()
Dim row As Integer = 0
While excelreader.Read()
NameValsBuffer.AddRow()
NameValsBuffer.ItemCode = CStr(IIf(excelreader.GetString(0).Length = 0, "#", excelreader.GetString(0)))
NameValsBuffer.TaxCode = CStr(IIf(excelreader.GetString(1).Length = 0, "#", excelreader.GetString(1)))
NameValsBuffer.ItemDescription = CStr(IIf(excelreader.GetString(2).Length = 0, "#", excelreader.GetString(2)))
NameValsBuffer.CompanyId = Me.Variables.CompanyId
NameValsBuffer.UserId = Me.Variables.UserId
End WhileThe thread title says "blank fields", while the text of the question references "blank columns", and lastly "blank spaces". Can you give a small pictorial representation of the problem? It sounds relatively easy to solve, but I'd like to make what the nature of the issue is first.|||
The value in the last row for the ItemDescription and TaxCode is null..so thats the problem I am facing when I am trying to validate and upload data.
|||First off, I'm not sure why you're using a script component, when an ADO.NET connection with the following connnection string will work fine:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"
In your dataflow, rather than script source, use a DataReader source and set your select statement in the SqlCommand property (e.g. SELECT * FROM [sheet1$] WHERE ...) . At that point, you can do whatever you want in the pipeline, including using conditional splits and/or derived columns as appropriate to handle the NULL ItemDescription and TaxCode pipeline columns, and adding your static columns via a derived column transform.
However, if for whatever reason you need to use a script component, you can use the following CreateNewOutput rows override to handle null cells. "OrElse" is used because its a short-curcuit operator, and .Item is used because it returns an Object, which can hold either a String or a DBNull object. Note there is no "WHERE" clause either, since nulls are handled in the while loop.
Public Overrides Sub
CreateNewOutputRows()
Dim
excelcmd As OleDbCommand = New OleDbCommand("SELECT
Item,TaxCode,ItemDescription FROM [Sheet1$]", excelConn)
Dim
excelreader As OleDbDataReader =
excelcmd.ExecuteReader()
Dim row
As Integer = 0
While
excelreader.Read()
With
NameValsBuffer
.AddRow()
.ItemCode = CStr(IIf(IsDBNull(excelreader.Item(0)) OrElse excelreader.GetString(0).Length = 0, "#", excelreader.Item(0)))
.TaxCode = CStr(IIf(IsDBNull(excelreader.Item(1))
OrElse excelreader.GetString(1).Length = 0, "#", excelreader.Item(1)))
.ItemDescription = CStr(IIf(IsDBNull(excelreader.Item(2)) OrElse excelreader.GetString(2).Length = 0, "#", excelreader.Item(2)))
End
With
End While
End Sub
In conditional split the condition could be set as follows:
ISNULL(ItemDescription) || ISNULL(TaxCode)
HTH..
Blank fields in Excel file
I am trying to validate and import a Excel file into the database table using script component. The file contains some blank columns in the sheet. How can I handle the blank spaces while validating the file in the Script Component?
The code is as follows:
Dim excelcmd As OleDbCommand = New OleDbCommand("SELECT Item,TaxCode,ItemDescription FROM [Input$]WHERE LEN(Item)>=0 AND LEN(ItemDescription)>=0 AND LEN(TaxCode)>=0", excelConn)
Dim excelreader As OleDbDataReader = excelcmd.ExecuteReader()
Dim row As Integer = 0
While excelreader.Read()
NameValsBuffer.AddRow()
NameValsBuffer.ItemCode = CStr(IIf(excelreader.GetString(0).Length = 0, "#", excelreader.GetString(0)))
NameValsBuffer.TaxCode = CStr(IIf(excelreader.GetString(1).Length = 0, "#", excelreader.GetString(1)))
NameValsBuffer.ItemDescription = CStr(IIf(excelreader.GetString(2).Length = 0, "#", excelreader.GetString(2)))
NameValsBuffer.CompanyId = Me.Variables.CompanyId
NameValsBuffer.UserId = Me.Variables.UserId
End WhileThe thread title says "blank fields", while the text of the question references "blank columns", and lastly "blank spaces". Can you give a small pictorial representation of the problem? It sounds relatively easy to solve, but I'd like to make what the nature of the issue is first.|||Item ItemDescription TaxCode AAA123 Sample Item 1 XXXXXX BBB255 Sample Item 2 AAAAA CCC366 Sample Item 3 BBBBB XDDD489 Sample Item 4 CCCCC 5EEE Sample Item 5 DDDDDD 6FFF Sample Item 6 EEEEEE GGG Sample Item 7 FFFFFFF HHH Sample Item 8 GGGGG III Sample Item 9 HHHHHH JJJ Sample Item 10 IIIIIIIIIII KKK Sample Item 11 ZZZZZZZZ MMM
The value in the last row for the ItemDescription and TaxCode is null..so thats the problem I am facing when I am trying to validate and upload data.
|||First off, I'm not sure why you're using a script component, when an ADO.NET connection with the following connnection string will work fine:
The code is as follows:
Dim excelcmd As OleDbCommand = New OleDbCommand("SELECT Item,TaxCode,ItemDescription FROM [Input$]WHERE LEN(Item)>=0 AND LEN(ItemDescription)>=0 AND LEN(TaxCode)>=0", excelConn)
Dim excelreader As OleDbDataReader = excelcmd.ExecuteReader()
Dim row As Integer = 0
While excelreader.Read()
NameValsBuffer.AddRow()
NameValsBuffer.ItemCode = CStr(IIf(excelreader.GetString(0).Length = 0, "#", excelreader.GetString(0)))
NameValsBuffer.TaxCode = CStr(IIf(excelreader.GetString(1).Length = 0, "#", excelreader.GetString(1)))
NameValsBuffer.ItemDescription = CStr(IIf(excelreader.GetString(2).Length = 0, "#", excelreader.GetString(2)))
NameValsBuffer.CompanyId = Me.Variables.CompanyId
NameValsBuffer.UserId = Me.Variables.UserId
End WhileThe thread title says "blank fields", while the text of the question references "blank columns", and lastly "blank spaces". Can you give a small pictorial representation of the problem? It sounds relatively easy to solve, but I'd like to make what the nature of the issue is first.|||
The value in the last row for the ItemDescription and TaxCode is null..so thats the problem I am facing when I am trying to validate and upload data.
|||First off, I'm not sure why you're using a script component, when an ADO.NET connection with the following connnection string will work fine:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"
In your dataflow, rather than script source, use a DataReader source and set your select statement in the SqlCommand property (e.g. SELECT * FROM [sheet1$] WHERE ...) . At that point, you can do whatever you want in the pipeline, including using conditional splits and/or derived columns as appropriate to handle the NULL ItemDescription and TaxCode pipeline columns, and adding your static columns via a derived column transform.
However, if for whatever reason you need to use a script component, you can use the following CreateNewOutput rows override to handle null cells. "OrElse" is used because its a short-curcuit operator, and .Item is used because it returns an Object, which can hold either a String or a DBNull object. Note there is no "WHERE" clause either, since nulls are handled in the while loop.
Public Overrides Sub
CreateNewOutputRows()
Dim
excelcmd As OleDbCommand = New OleDbCommand("SELECT
Item,TaxCode,ItemDescription FROM [Sheet1$]", excelConn)
Dim
excelreader As OleDbDataReader =
excelcmd.ExecuteReader()
Dim row
As Integer = 0
While
excelreader.Read()
With
NameValsBuffer
.AddRow()
.ItemCode = CStr(IIf(IsDBNull(excelreader.Item(0)) OrElse excelreader.GetString(0).Length = 0, "#", excelreader.Item(0)))
.TaxCode = CStr(IIf(IsDBNull(excelreader.Item(1))
OrElse excelreader.GetString(1).Length = 0, "#", excelreader.Item(1)))
.ItemDescription = CStr(IIf(IsDBNull(excelreader.Item(2)) OrElse excelreader.GetString(2).Length = 0, "#", excelreader.Item(2)))
End
With
End While
End Sub
In conditional split the condition could be set as follows:
ISNULL(ItemDescription) || ISNULL(TaxCode)
HTH..
Tuesday, February 14, 2012
Biztalk Promoted Fields in SQL Schema
Now I promoted some fields in Biztalk which adds "comments" in an
<annotation> tag as shown below.
<xs:element name="Hipaa30TradingTestInclude">
<xs:annotation>
<xs:appinfo>
<b:properties>
<b:property name="ns0:__Name"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name
()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='Na
me' and namespace-uri()='']" />
<b:property name="ns0:City"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name
()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='Ci
ty' and namespace-uri()='']" />
<b:property name="ns0:State"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name
()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='St
ate' and namespace-uri()='']" />
<b:property name="ns0:Zip"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name
()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='Zi
p' and namespace-uri()='']" />
<b:property name="ns0:PrimaryContact"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name
()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='Pr
imaryContact' and namespace-uri()='']" />
</b:properties>
</xs:appinfo>
</xs:annotation>
I have five "promoted fields" and i got the following error five times.
Msg 102, Level 15, State 1, Line 49
Incorrect syntax near 'Hipaa30TradingTestInclude'.
Msg 132, Level 15, State 1, Line 49
The label 'http' has already been declared. Label names must be unique
within a query batch or stored procedure.
Msg 132, Level 15, State 1, Line 50
The label 'http' has already been declared. Label names must be unique
within a query batch or stored procedure.
Msg 132, Level 15, State 1, Line 50
Seems like the parser should ignore anything in the <annotation> tag?
Of course, I can manually remove it, but I'm trying to plan ahead for how to
maintain this.
Thanks again,
Neal Walters
http://Biztalk-Training.comIf you're using a SQL string literal to insert your schemas, you need to
escape the single quotes anywhere they occur in the string by using double
quotes.
Cheers,
Bob
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:ECD78F81-E1B2-42F3-8D3E-9D2987FB5031@.microsoft.com...
> Now I promoted some fields in Biztalk which adds "comments" in an
> <annotation> tag as shown below.
> <xs:element name="Hipaa30TradingTestInclude">
> <xs:annotation>
> <xs:appinfo>
> <b:properties>
> <b:property name="ns0:__Name"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-na
me()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='
Name'
> and namespace-uri()='']" />
> <b:property name="ns0:City"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-na
me()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='
City'
> and namespace-uri()='']" />
> <b:property name="ns0:State"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-na
me()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='
State'
> and namespace-uri()='']" />
> <b:property name="ns0:Zip"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-na
me()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='
Zip'
> and namespace-uri()='']" />
> <b:property name="ns0:PrimaryContact"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-na
me()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='
PrimaryContact'
> and namespace-uri()='']" />
> </b:properties>
> </xs:appinfo>
> </xs:annotation>
>
> I have five "promoted fields" and i got the following error five times.
> Msg 102, Level 15, State 1, Line 49
> Incorrect syntax near 'Hipaa30TradingTestInclude'.
> Msg 132, Level 15, State 1, Line 49
> The label 'http' has already been declared. Label names must be unique
> within a query batch or stored procedure.
> Msg 132, Level 15, State 1, Line 50
> The label 'http' has already been declared. Label names must be unique
> within a query batch or stored procedure.
> Msg 132, Level 15, State 1, Line 50
> Seems like the parser should ignore anything in the <annotation> tag?
> Of course, I can manually remove it, but I'm trying to plan ahead for how
> to
> maintain this.
>
> Thanks again,
> Neal Walters
> http://Biztalk-Training.com
>|||Also note that XML Schema collections will not preserve your annotations.
Put the schema also in your own table using the XML datatype if that is
important information.
Best regards
Michael
"Bob Beauchemin" <bobb_no_spam@.SQLskills.com> wrote in message
news:ewAdNfuMHHA.5064@.TK2MSFTNGP04.phx.gbl...
> If you're using a SQL string literal to insert your schemas, you need to
> escape the single quotes anywhere they occur in the string by using double
> quotes.
> Cheers,
> Bob
> "Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
> news:ECD78F81-E1B2-42F3-8D3E-9D2987FB5031@.microsoft.com...
>
<annotation> tag as shown below.
<xs:element name="Hipaa30TradingTestInclude">
<xs:annotation>
<xs:appinfo>
<b:properties>
<b:property name="ns0:__Name"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name
()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='Na
me' and namespace-uri()='']" />
<b:property name="ns0:City"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name
()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='Ci
ty' and namespace-uri()='']" />
<b:property name="ns0:State"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name
()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='St
ate' and namespace-uri()='']" />
<b:property name="ns0:Zip"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name
()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='Zi
p' and namespace-uri()='']" />
<b:property name="ns0:PrimaryContact"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name
()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='Pr
imaryContact' and namespace-uri()='']" />
</b:properties>
</xs:appinfo>
</xs:annotation>
I have five "promoted fields" and i got the following error five times.
Msg 102, Level 15, State 1, Line 49
Incorrect syntax near 'Hipaa30TradingTestInclude'.
Msg 132, Level 15, State 1, Line 49
The label 'http' has already been declared. Label names must be unique
within a query batch or stored procedure.
Msg 132, Level 15, State 1, Line 50
The label 'http' has already been declared. Label names must be unique
within a query batch or stored procedure.
Msg 132, Level 15, State 1, Line 50
Seems like the parser should ignore anything in the <annotation> tag?
Of course, I can manually remove it, but I'm trying to plan ahead for how to
maintain this.
Thanks again,
Neal Walters
http://Biztalk-Training.comIf you're using a SQL string literal to insert your schemas, you need to
escape the single quotes anywhere they occur in the string by using double
quotes.
Cheers,
Bob
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:ECD78F81-E1B2-42F3-8D3E-9D2987FB5031@.microsoft.com...
> Now I promoted some fields in Biztalk which adds "comments" in an
> <annotation> tag as shown below.
> <xs:element name="Hipaa30TradingTestInclude">
> <xs:annotation>
> <xs:appinfo>
> <b:properties>
> <b:property name="ns0:__Name"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-na
me()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='
Name'
> and namespace-uri()='']" />
> <b:property name="ns0:City"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-na
me()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='
City'
> and namespace-uri()='']" />
> <b:property name="ns0:State"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-na
me()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='
State'
> and namespace-uri()='']" />
> <b:property name="ns0:Zip"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-na
me()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='
Zip'
> and namespace-uri()='']" />
> <b:property name="ns0:PrimaryContact"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-na
me()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='
PrimaryContact'
> and namespace-uri()='']" />
> </b:properties>
> </xs:appinfo>
> </xs:annotation>
>
> I have five "promoted fields" and i got the following error five times.
> Msg 102, Level 15, State 1, Line 49
> Incorrect syntax near 'Hipaa30TradingTestInclude'.
> Msg 132, Level 15, State 1, Line 49
> The label 'http' has already been declared. Label names must be unique
> within a query batch or stored procedure.
> Msg 132, Level 15, State 1, Line 50
> The label 'http' has already been declared. Label names must be unique
> within a query batch or stored procedure.
> Msg 132, Level 15, State 1, Line 50
> Seems like the parser should ignore anything in the <annotation> tag?
> Of course, I can manually remove it, but I'm trying to plan ahead for how
> to
> maintain this.
>
> Thanks again,
> Neal Walters
> http://Biztalk-Training.com
>|||Also note that XML Schema collections will not preserve your annotations.
Put the schema also in your own table using the XML datatype if that is
important information.
Best regards
Michael
"Bob Beauchemin" <bobb_no_spam@.SQLskills.com> wrote in message
news:ewAdNfuMHHA.5064@.TK2MSFTNGP04.phx.gbl...
> If you're using a SQL string literal to insert your schemas, you need to
> escape the single quotes anywhere they occur in the string by using double
> quotes.
> Cheers,
> Bob
> "Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
> news:ECD78F81-E1B2-42F3-8D3E-9D2987FB5031@.microsoft.com...
>
Biztalk Promoted Fields in SQL Schema
Now I promoted some fields in Biztalk which adds "comments" in an
<annotation> tag as shown below.
<xs:element name="Hipaa30TradingTestInclude">
<xs:annotation>
<xs:appinfo>
<b:properties>
<b:property name="ns0:__Name"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='Name' and namespace-uri()='']" />
<b:property name="ns0:City"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='City' and namespace-uri()='']" />
<b:property name="ns0:State"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='State' and namespace-uri()='']" />
<b:property name="ns0:Zip"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='Zip' and namespace-uri()='']" />
<b:property name="ns0:PrimaryContact"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='PrimaryContact' and namespace-uri()='']" />
</b:properties>
</xs:appinfo>
</xs:annotation>
I have five "promoted fields" and i got the following error five times.
Msg 102, Level 15, State 1, Line 49
Incorrect syntax near 'Hipaa30TradingTestInclude'.
Msg 132, Level 15, State 1, Line 49
The label 'http' has already been declared. Label names must be unique
within a query batch or stored procedure.
Msg 132, Level 15, State 1, Line 50
The label 'http' has already been declared. Label names must be unique
within a query batch or stored procedure.
Msg 132, Level 15, State 1, Line 50
Seems like the parser should ignore anything in the <annotation> tag?
Of course, I can manually remove it, but I'm trying to plan ahead for how to
maintain this.
Thanks again,
Neal Walters
http://Biztalk-Training.com
If you're using a SQL string literal to insert your schemas, you need to
escape the single quotes anywhere they occur in the string by using double
quotes.
Cheers,
Bob
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:ECD78F81-E1B2-42F3-8D3E-9D2987FB5031@.microsoft.com...
> Now I promoted some fields in Biztalk which adds "comments" in an
> <annotation> tag as shown below.
> <xs:element name="Hipaa30TradingTestInclude">
> <xs:annotation>
> <xs:appinfo>
> <b:properties>
> <b:property name="ns0:__Name"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='Name'
> and namespace-uri()='']" />
> <b:property name="ns0:City"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='City'
> and namespace-uri()='']" />
> <b:property name="ns0:State"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='State'
> and namespace-uri()='']" />
> <b:property name="ns0:Zip"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='Zip'
> and namespace-uri()='']" />
> <b:property name="ns0:PrimaryContact"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='PrimaryContact'
> and namespace-uri()='']" />
> </b:properties>
> </xs:appinfo>
> </xs:annotation>
>
> I have five "promoted fields" and i got the following error five times.
> Msg 102, Level 15, State 1, Line 49
> Incorrect syntax near 'Hipaa30TradingTestInclude'.
> Msg 132, Level 15, State 1, Line 49
> The label 'http' has already been declared. Label names must be unique
> within a query batch or stored procedure.
> Msg 132, Level 15, State 1, Line 50
> The label 'http' has already been declared. Label names must be unique
> within a query batch or stored procedure.
> Msg 132, Level 15, State 1, Line 50
> Seems like the parser should ignore anything in the <annotation> tag?
> Of course, I can manually remove it, but I'm trying to plan ahead for how
> to
> maintain this.
>
> Thanks again,
> Neal Walters
> http://Biztalk-Training.com
>
|||Also note that XML Schema collections will not preserve your annotations.
Put the schema also in your own table using the XML datatype if that is
important information.
Best regards
Michael
"Bob Beauchemin" <bobb_no_spam@.SQLskills.com> wrote in message
news:ewAdNfuMHHA.5064@.TK2MSFTNGP04.phx.gbl...
> If you're using a SQL string literal to insert your schemas, you need to
> escape the single quotes anywhere they occur in the string by using double
> quotes.
> Cheers,
> Bob
> "Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
> news:ECD78F81-E1B2-42F3-8D3E-9D2987FB5031@.microsoft.com...
>
<annotation> tag as shown below.
<xs:element name="Hipaa30TradingTestInclude">
<xs:annotation>
<xs:appinfo>
<b:properties>
<b:property name="ns0:__Name"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='Name' and namespace-uri()='']" />
<b:property name="ns0:City"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='City' and namespace-uri()='']" />
<b:property name="ns0:State"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='State' and namespace-uri()='']" />
<b:property name="ns0:Zip"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='Zip' and namespace-uri()='']" />
<b:property name="ns0:PrimaryContact"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='PrimaryContact' and namespace-uri()='']" />
</b:properties>
</xs:appinfo>
</xs:annotation>
I have five "promoted fields" and i got the following error five times.
Msg 102, Level 15, State 1, Line 49
Incorrect syntax near 'Hipaa30TradingTestInclude'.
Msg 132, Level 15, State 1, Line 49
The label 'http' has already been declared. Label names must be unique
within a query batch or stored procedure.
Msg 132, Level 15, State 1, Line 50
The label 'http' has already been declared. Label names must be unique
within a query batch or stored procedure.
Msg 132, Level 15, State 1, Line 50
Seems like the parser should ignore anything in the <annotation> tag?
Of course, I can manually remove it, but I'm trying to plan ahead for how to
maintain this.
Thanks again,
Neal Walters
http://Biztalk-Training.com
If you're using a SQL string literal to insert your schemas, you need to
escape the single quotes anywhere they occur in the string by using double
quotes.
Cheers,
Bob
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:ECD78F81-E1B2-42F3-8D3E-9D2987FB5031@.microsoft.com...
> Now I promoted some fields in Biztalk which adds "comments" in an
> <annotation> tag as shown below.
> <xs:element name="Hipaa30TradingTestInclude">
> <xs:annotation>
> <xs:appinfo>
> <b:properties>
> <b:property name="ns0:__Name"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='Name'
> and namespace-uri()='']" />
> <b:property name="ns0:City"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='City'
> and namespace-uri()='']" />
> <b:property name="ns0:State"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='State'
> and namespace-uri()='']" />
> <b:property name="ns0:Zip"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='Zip'
> and namespace-uri()='']" />
> <b:property name="ns0:PrimaryContact"
> xpath="/*[local-name()='Hipaa30TradingTestInclude' and
> namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
> and
> namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='PrimaryContact'
> and namespace-uri()='']" />
> </b:properties>
> </xs:appinfo>
> </xs:annotation>
>
> I have five "promoted fields" and i got the following error five times.
> Msg 102, Level 15, State 1, Line 49
> Incorrect syntax near 'Hipaa30TradingTestInclude'.
> Msg 132, Level 15, State 1, Line 49
> The label 'http' has already been declared. Label names must be unique
> within a query batch or stored procedure.
> Msg 132, Level 15, State 1, Line 50
> The label 'http' has already been declared. Label names must be unique
> within a query batch or stored procedure.
> Msg 132, Level 15, State 1, Line 50
> Seems like the parser should ignore anything in the <annotation> tag?
> Of course, I can manually remove it, but I'm trying to plan ahead for how
> to
> maintain this.
>
> Thanks again,
> Neal Walters
> http://Biztalk-Training.com
>
|||Also note that XML Schema collections will not preserve your annotations.
Put the schema also in your own table using the XML datatype if that is
important information.
Best regards
Michael
"Bob Beauchemin" <bobb_no_spam@.SQLskills.com> wrote in message
news:ewAdNfuMHHA.5064@.TK2MSFTNGP04.phx.gbl...
> If you're using a SQL string literal to insert your schemas, you need to
> escape the single quotes anywhere they occur in the string by using double
> quotes.
> Cheers,
> Bob
> "Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
> news:ECD78F81-E1B2-42F3-8D3E-9D2987FB5031@.microsoft.com...
>
Subscribe to:
Posts (Atom)