barcode missing when printing from reporting services

I am using a barcode font 39 to generate barcodes in some reports. If I
reader the report and save it to a excel spreedsheet and print then the
report prints fine with the barcode.
If while I am in the browser I use the reporting services print engine the
barcode comes out as the numbers ie *12345* instead of the barcode font. The
numbers also come up in the preview of the printing.
I have installed the font on the local and reporting service computersI have just also found that if I export to Excel the barcode works but if I
export to PDF it doesn't.
"John230873" wrote:
> I am using a barcode font 39 to generate barcodes in some reports. If I
> reader the report and save it to a excel spreedsheet and print then the
> report prints fine with the barcode.
> If while I am in the browser I use the reporting services print engine the
> barcode comes out as the numbers ie *12345* instead of the barcode font. The
> numbers also come up in the preview of the printing.
> I have installed the font on the local and reporting service computers|||John,
I had the same problem. I wish Microsoft would release a fix to the problem
but I found a work-around by making the textbox (that holds the barcode in
the [rdl]) 3 times larger than the required size. This will of course mess
up your design.
Frank
"John230873" wrote:
> I have just also found that if I export to Excel the barcode works but if I
> export to PDF it doesn't.
> "John230873" wrote:
> > I am using a barcode font 39 to generate barcodes in some reports. If I
> > reader the report and save it to a excel spreedsheet and print then the
> > report prints fine with the barcode.
> >
> > If while I am in the browser I use the reporting services print engine the
> > barcode comes out as the numbers ie *12345* instead of the barcode font. The
> > numbers also come up in the preview of the printing.
> >
> > I have installed the font on the local and reporting service computers|||I am using a barcode and it is working perfectly. I had to find an assembly
for the solution which can be found here...
http://www.bizfonts.com/MicrosoftReportingServices/
HTH
"Frank" wrote:
> John,
> I had the same problem. I wish Microsoft would release a fix to the problem
> but I found a work-around by making the textbox (that holds the barcode in
> the [rdl]) 3 times larger than the required size. This will of course mess
> up your design.
> Frank
> "John230873" wrote:
> > I have just also found that if I export to Excel the barcode works but if I
> > export to PDF it doesn't.
> >
> > "John230873" wrote:
> >
> > > I am using a barcode font 39 to generate barcodes in some reports. If I
> > > reader the report and save it to a excel spreedsheet and print then the
> > > report prints fine with the barcode.
> > >
> > > If while I am in the browser I use the reporting services print engine the
> > > barcode comes out as the numbers ie *12345* instead of the barcode font. The
> > > numbers also come up in the preview of the printing.
> > >
> > > I have installed the font on the local and reporting service computers|||I need to generate a report with barcodes.
Are there any samples available that will show me how to do this?
Do I need to purchase a third-party component?
Thanks,
Scott
"DigitalVixen" wrote:
> I am using a barcode and it is working perfectly. I had to find an assembly
> for the solution which can be found here...
> http://www.bizfonts.com/MicrosoftReportingServices/
> HTH
> "Frank" wrote:
> > John,
> >
> > I had the same problem. I wish Microsoft would release a fix to the problem
> > but I found a work-around by making the textbox (that holds the barcode in
> > the [rdl]) 3 times larger than the required size. This will of course mess
> > up your design.
> >
> > Frank
> >
> > "John230873" wrote:
> >
> > > I have just also found that if I export to Excel the barcode works but if I
> > > export to PDF it doesn't.
> > >
> > > "John230873" wrote:
> > >
> > > > I am using a barcode font 39 to generate barcodes in some reports. If I
> > > > reader the report and save it to a excel spreedsheet and print then the
> > > > report prints fine with the barcode.
> > > >
> > > > If while I am in the browser I use the reporting services print engine the
> > > > barcode comes out as the numbers ie *12345* instead of the barcode font. The
> > > > numbers also come up in the preview of the printing.
> > > >
> > > > I have installed the font on the local and reporting service computers|||I too tried to use the assembly, but it did not fix the problem? Any
suggestions? I follwed the directions to a "T". Did you have to "tweak"
anything to get it to work for you?
"DigitalVixen" wrote:
> I am using a barcode and it is working perfectly. I had to find an assembly
> for the solution which can be found here...
> http://www.bizfonts.com/MicrosoftReportingServices/
> HTH
> "Frank" wrote:
> > John,
> >
> > I had the same problem. I wish Microsoft would release a fix to the problem
> > but I found a work-around by making the textbox (that holds the barcode in
> > the [rdl]) 3 times larger than the required size. This will of course mess
> > up your design.
> >
> > Frank
> >
> > "John230873" wrote:
> >
> > > I have just also found that if I export to Excel the barcode works but if I
> > > export to PDF it doesn't.
> > >
> > > "John230873" wrote:
> > >
> > > > I am using a barcode font 39 to generate barcodes in some reports. If I
> > > > reader the report and save it to a excel spreedsheet and print then the
> > > > report prints fine with the barcode.
> > > >
> > > > If while I am in the browser I use the reporting services print engine the
> > > > barcode comes out as the numbers ie *12345* instead of the barcode font. The
> > > > numbers also come up in the preview of the printing.
> > > >
> > > > I have installed the font on the local and reporting service computers|||This is the best barcode solution for Reporting Services.
All export file formats supported!!!
http://www.neodynamic.com/Products/BCRS/BarcodeRS.aspx?tabid=78&prodid=7
Cheers
"HeroTheCat" wrote:
> I too tried to use the assembly, but it did not fix the problem? Any
> suggestions? I follwed the directions to a "T". Did you have to "tweak"
> anything to get it to work for you?
> "DigitalVixen" wrote:
> > I am using a barcode and it is working perfectly. I had to find an assembly
> > for the solution which can be found here...
> >
> > http://www.bizfonts.com/MicrosoftReportingServices/
> >
> > HTH
> >
> > "Frank" wrote:
> >
> > > John,
> > >
> > > I had the same problem. I wish Microsoft would release a fix to the problem
> > > but I found a work-around by making the textbox (that holds the barcode in
> > > the [rdl]) 3 times larger than the required size. This will of course mess
> > > up your design.
> > >
> > > Frank
> > >
> > > "John230873" wrote:
> > >
> > > > I have just also found that if I export to Excel the barcode works but if I
> > > > export to PDF it doesn't.
> > > >
> > > > "John230873" wrote:
> > > >
> > > > > I am using a barcode font 39 to generate barcodes in some reports. If I
> > > > > reader the report and save it to a excel spreedsheet and print then the
> > > > > report prints fine with the barcode.
> > > > >
> > > > > If while I am in the browser I use the reporting services print engine the
> > > > > barcode comes out as the numbers ie *12345* instead of the barcode font. The
> > > > > numbers also come up in the preview of the printing.
> > > > >
> > > > > I have installed the font on the local and reporting service computers

bar and line graph on same chart ?

Hi
Is it possible to have bar and line graphs on the same chart in Crystal?
I know this can be done in Excel fairly easily...bump.....

Baffled

I have a table called lab_results_import, and one of the fields is called
qualifier_id. The table was empty, I imported 1 Excel spreadsheet with 150
0
records. 134 of these records have an empty cell in the Excel spreadsheet i
n
the qualifier_id column. The ss imports fine, but I am baffled by this quer
y
that I am running on the table. The query is
SELECT *, qualifier_id
FROM lab_results_import
WHERE (qualifier_id = '')
which returns 134 records, BUT
SELECT *, qualifier_id
FROM lab_results_import
WHERE (qualifier_id = ' ')
also returns 134 records, and regardless of how many spaces are in my
(qualifier_id = '') where clause, the query returns 134 records.
Anybody know what is going on, and/or how to search for a field containing a
certain number of spaces.
Thanks a lot.
ArcherWhat data type is this column (qualifier_id)? Is it nullable?
ML|||>> Anybody know what is going on, and/or how to search for a field
It is a known behavior where the trailing blanks of are being trimmed off
for comparison. The workaround is to use a character which is not in your
column like '~' or '*' like:
SELECT *
FROM tbl
WHERE '~' + col + '~' = '~' + SPACE( 10 ) + '~' ;
Note that such padding in general, will avoid the usage of any existing
indexes in the column, though.
Anith|||Try,
select
c1, datalength(c1)
from
(
select cast(space(0) as varchar(25))
union all
select space(1)
union all
select space(2)
union all
select space(3)
union all
select space(4)
) as t1(c1)
where
'.' + c1 + '.' = '.' + space(3) + '.'
-- or
select
c1, datalength(c1)
from
(
select cast(space(0) as varchar(25))
union all
select space(1)
union all
select space(2)
union all
select space(3)
union all
select space(4)
) as t1(c1)
where
c1 = ' ' and datalength(c1) = 3
go
Joe Celko explained one time why sql server seems to ignore trailing spaces
when comparing varchar data type, but I could not find it.
AMB
"bagman3rd" wrote:

> I have a table called lab_results_import, and one of the fields is called
> qualifier_id. The table was empty, I imported 1 Excel spreadsheet with 1
500
> records. 134 of these records have an empty cell in the Excel spreadsheet
in
> the qualifier_id column. The ss imports fine, but I am baffled by this qu
ery
> that I am running on the table. The query is
> SELECT *, qualifier_id
> FROM lab_results_import
> WHERE (qualifier_id = '')
>
> which returns 134 records, BUT
> SELECT *, qualifier_id
> FROM lab_results_import
> WHERE (qualifier_id = ' ')
> also returns 134 records, and regardless of how many spaces are in my
> (qualifier_id = '') where clause, the query returns 134 records.
> Anybody know what is going on, and/or how to search for a field containing
a
> certain number of spaces.
> Thanks a lot.
> Archer|||varchar(10)
and nulls are allowed. I actually want the cells to be null and I am trying
to avoid having cells with emtpy spaces.
A
"ML" wrote:

> What data type is this column (qualifier_id)? Is it nullable?
>
> ML

bad excel performance / capacity question

a web application that i have recently deployed uses reporting services and exports data to excel reports with drill down options

i have reports that are being generated up to 5 MB and are not usable in excel (i.e. scrolling freezes, slow opening times, large file size)

the reason for this is the detail displayed for each record

each record has a drop down of approximatley 4-6 rows of detail

a report with 3000 lines will have those 4-6 rows of detail for each record

shouldn't excel be able to handle this?

the reports also take a long time to generate and i have had timeout issues, i was able to set the webservice that generates the reports to have no timeout to resolve this problem, my bigger concern is why excel performs so slowly and why the file size is so large

previously we ran these reports out of access, and instead of having the reporting services format, we displayed detail information across as columns and there was no performance issue with the same amount of data

the problems seems to be with out excel handles the (+) signs

Hi,

I also have this problem and it is a big problem according to my customers - I've contacted Microsoft via an incident.

The MS's answer was : the SSRS Excel renderer is the problem and it shall be solved in the next SQL Server version (completely rewritten). Not earlier, and there is no possibility to fix it now.

The only workaround I've found:

1. the main point is to open the exported excel file for the 1.time (you have simply to wait until it opens) and then copy-paste as values the whole sheet. save the file after this, the next time you open it you will see performance improvement.

2. maybe you can split the report into smaller parts - this means less data but more reports

3. you can modify the renderer by setting OMIT_FORMULAS to true in the renderer's config file (there will be no formulas exported, all is exported as values)

The only what really helps is the point 1.

Not only the (+) sign is the problem. I have a report exporting 7000 of rows in 20 columns and there is a problem too.

Hope this helps, if someone has more ideas please let me know, I would also appreciate it.

Jan

|||I would guess that you have a significant number of merged cells in your generated report, due to alignment issues in the RDL. Excel has known issues when loading a spreadsheet with many merge cells. The Excel Export in RS uses merged cells to maintain the layout defined in RDL, and if you have many rows, this can result in large numbers of merged cells.

Check out Chris's blog entry on merging cells and how to reduce them:
http://blogs.msdn.com/chrisbal/archive/2006/07/08/659545.aspx
|||

interesting...thanks for the answer

but there are no merged columns in my problematic excel file...and how is it possible that after copy-paste as values of the whole sheet becomes the opening and working with the excel file non-problematic...?

bad excel performance / capacity question

a web application that i have recently deployed uses reporting services and exports data to excel reports with drill down options

i have reports that are being generated up to 5 MB and are not usable in excel (i.e. scrolling freezes, slow opening times, large file size)

the reason for this is the detail displayed for each record

each record has a drop down of approximatley 4-6 rows of detail

a report with 3000 lines will have those 4-6 rows of detail for each record

shouldn't excel be able to handle this?

the reports also take a long time to generate and i have had timeout issues, i was able to set the webservice that generates the reports to have no timeout to resolve this problem, my bigger concern is why excel performs so slowly and why the file size is so large

previously we ran these reports out of access, and instead of having the reporting services format, we displayed detail information across as columns and there was no performance issue with the same amount of data

the problems seems to be with out excel handles the (+) signs

Hi,

I also have this problem and it is a big problem according to my customers - I've contacted Microsoft via an incident.

The MS's answer was : the SSRS Excel renderer is the problem and it shall be solved in the next SQL Server version (completely rewritten). Not earlier, and there is no possibility to fix it now.

The only workaround I've found:

1. the main point is to open the exported excel file for the 1.time (you have simply to wait until it opens) and then copy-paste as values the whole sheet. save the file after this, the next time you open it you will see performance improvement.

2. maybe you can split the report into smaller parts - this means less data but more reports

3. you can modify the renderer by setting OMIT_FORMULAS to true in the renderer's config file (there will be no formulas exported, all is exported as values)

The only what really helps is the point 1.

Not only the (+) sign is the problem. I have a report exporting 7000 of rows in 20 columns and there is a problem too.

Hope this helps, if someone has more ideas please let me know, I would also appreciate it.

Jan

|||I would guess that you have a significant number of merged cells in your generated report, due to alignment issues in the RDL. Excel has known issues when loading a spreadsheet with many merge cells. The Excel Export in RS uses merged cells to maintain the layout defined in RDL, and if you have many rows, this can result in large numbers of merged cells.

Check out Chris's blog entry on merging cells and how to reduce them:
http://blogs.msdn.com/chrisbal/archive/2006/07/08/659545.aspx|||

interesting...thanks for the answer

but there are no merged columns in my problematic excel file...and how is it possible that after copy-paste as values of the whole sheet becomes the opening and working with the excel file non-problematic...?