Barcodes in PDF

Hi there
I am creating a report with MS SQL reporting services 2000 that includes a
barcode. It 's for a kind of ticket creation.
So, I am using the Code 3of9 font to create my barcodes. So for example
*01511051* is the text, but font type is code 3àf9, giving the barcode in
display
When exporting to HTML, there is no issue, barcode is displayed fine, as
well as in the preview of visual studio. But as soon as I export it to PDF,
the barcode is gone.
Is there anyone that has some experience in this? How can I resolve this?
Weird thing is that when creating the same report in Crystal Reports and
exporting to PDF, it does render the barcode. But Crystal reports is not an
option, it has to be done in reporting services 2000
kind regards
NicoNico,
What happens if u just use standard font?
Does it display it in the PDF?
If it does, perhaps its a Adobe font issue...(I dont know about this,
but perhaps the font needs to be added into it?)
If it doesn't even show the plain (*01511051*), then it may be a
different problem, but Im almost sure its a Abode font issue.
Also,
Choose Start > Settings > Control Panel.
Double-click the Fonts icon, check if that font is located there.
regards,
Stas K.|||Hi
It does not display anything at all when exporting to PDF format. It's just
a blank area on the pdf, whereas in the HTML output, the barcode is
displayed properly
"Sorcerdon" <sorcerdon@.gmail.com> wrote in message
news:1144856853.406170.30120@.g10g2000cwb.googlegroups.com...
> Nico,
> What happens if u just use standard font?
> Does it display it in the PDF?
> If it does, perhaps its a Adobe font issue...(I dont know about this,
> but perhaps the font needs to be added into it?)
> If it doesn't even show the plain (*01511051*), then it may be a
> different problem, but Im almost sure its a Abode font issue.
> Also,
> Choose Start > Settings > Control Panel.
> Double-click the Fonts icon, check if that font is located there.
> regards,
> Stas K.
>|||Hello!
We (TEC-IT) offer a barcode software component named TBarCode OCX which is
available as ActiveX control and as DLL. Download the trial version from
http://www.tec-it.com
If you have troubles embedding the component into your reports please
contact us via email (support@.tec-it.com)
Hope this helps!
Guenter
"NDE" wrote:
> Hi
> It does not display anything at all when exporting to PDF format. It's just
> a blank area on the pdf, whereas in the HTML output, the barcode is
> displayed properly
> "Sorcerdon" <sorcerdon@.gmail.com> wrote in message
> news:1144856853.406170.30120@.g10g2000cwb.googlegroups.com...
> > Nico,
> >
> > What happens if u just use standard font?
> > Does it display it in the PDF?
> > If it does, perhaps its a Adobe font issue...(I dont know about this,
> > but perhaps the font needs to be added into it?)
> > If it doesn't even show the plain (*01511051*), then it may be a
> > different problem, but Im almost sure its a Abode font issue.
> >
> > Also,
> > Choose Start > Settings > Control Panel.
> > Double-click the Fonts icon, check if that font is located there.
> >
> > regards,
> > Stas K.
> >
>
>

Baffled trying to display a parameter label

I have two parameters: year and month. The Month parameter includes All, 1, 2, ect..

I tried to display the parameter slected with the following expression:

=IIf(Parameters!DateShippedMonth.Label="All",Parameters!DateShippedMonth.Label,

MonthName(Parameters!DateShippedMonth.Label)) & ", " & Parameters!DateShippedYear.Label

I want it to either display the label (All) or the name of the month. I get an error when All is the parameter selected but not when any month is selected. If I removed the MonthName() function, I don't get an error but I also don't get the month name.

Any ideas?

What error are you getting?

The MonthName takes an integer as MonthNumber. If you are using the parameter label, then I would assume that you are trying to pass a string to the MonthName function.

If you are indeed displaying a number 1,2, 3 etc in the month parameter, then try a CInt function around the label.

BobP

|||I tried both with and without CInt() in the MonthName function. If the parameter selected is a month I don't get an error, which is strange as I SHOULD get an error when I'm NOT using the CInt(). I only get an incorrect input string was not correct format when I add the MonthName function. If I run MonthName alone I get the error on the "All" parameter which is why I tried to pull out the "All" parameter with the IIf|||

It looks like it is validating the MonthName function on it's own, outside the context of the IIF.

So I did this to get it to work:

=IIf(Parameters!DateShippedMonth.Label="All",Parameters!DateShippedMonth.Label,

MonthName(iif(Parameters!DateShippedMonth.Label="All",1,Parameters!DateShippedMonth.Label))) & ", " & Parameters!DateShippedYear.Label

BobP

|||

Thanks. I'll try that. I already wrote some custom code to resolve the problem but this looks easier. Although I think I have to use custom code to translate a fiscal period of, say 4, which is really July of the previous year.

Thanks again!

|||

If you are reporting off of a Data Mart/Data Warehouse, your dimDate dimension should take care of that.

Other wise you can use the TSQL function DateName:

Quarter = DateName(q,@.CurDate)

BobP

|||I'm doing mdx queries from a cube and my dimDate month is in integers. If I change it to month names they don't sort correctly.

Baffled trying to display a parameter label

I have two parameters: year and month. The Month parameter includes All, 1, 2, ect..

I tried to display the parameter slected with the following expression:

=IIf(Parameters!DateShippedMonth.Label="All",Parameters!DateShippedMonth.Label,

MonthName(Parameters!DateShippedMonth.Label)) & ", " & Parameters!DateShippedYear.Label

I want it to either display the label (All) or the name of the month. I get an error when All is the parameter selected but not when any month is selected. If I removed the MonthName() function, I don't get an error but I also don't get the month name.

Any ideas?

What error are you getting?

The MonthName takes an integer as MonthNumber. If you are using the parameter label, then I would assume that you are trying to pass a string to the MonthName function.

If you are indeed displaying a number 1,2, 3 etc in the month parameter, then try a CInt function around the label.

BobP

|||I tried both with and without CInt() in the MonthName function. If the parameter selected is a month I don't get an error, which is strange as I SHOULD get an error when I'm NOT using the CInt(). I only get an incorrect input string was not correct format when I add the MonthName function. If I run MonthName alone I get the error on the "All" parameter which is why I tried to pull out the "All" parameter with the IIf|||

It looks like it is validating the MonthName function on it's own, outside the context of the IIF.

So I did this to get it to work:

=IIf(Parameters!DateShippedMonth.Label="All",Parameters!DateShippedMonth.Label,

MonthName(iif(Parameters!DateShippedMonth.Label="All",1,Parameters!DateShippedMonth.Label))) & ", " & Parameters!DateShippedYear.Label

BobP

|||

Thanks. I'll try that. I already wrote some custom code to resolve the problem but this looks easier. Although I think I have to use custom code to translate a fiscal period of, say 4, which is really July of the previous year.

Thanks again!

|||

If you are reporting off of a Data Mart/Data Warehouse, your dimDate dimension should take care of that.

Other wise you can use the TSQL function DateName:

Quarter = DateName(q,@.CurDate)

BobP

|||I'm doing mdx queries from a cube and my dimDate month is in integers. If I change it to month names they don't sort correctly.sql