Barcode doen't display when run from the Report Server

Hi All,
I have a barcode that I use on one of my reports. When I test it on locally, the barcode displays and exports to PDF fine. I have made use of the barcode code samples on this forum (thanks), that makes use of a barcode font (FREE3OF9.TTF) that results in the DLL assemlbly (ReportUtils.DLL) returning a byte.
I have done the following on my local machine:
- Installed the FREE3OF9.TTF font.
- copied the DLL on my local machine to :
C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer\ReportUtils.dll
- Added the following codegroup to rspreviewpolicy.config :
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="ReportUtils"
Description="Code group for my data processing extension">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer\ReportUtils.dll"/>
</CodeGroup>
and, done the following on the server machine:
- Installed the FREE3OF9.TTF font.
- copied the DLL on the report server to :
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin\ReportUtils.dll
- Added the following codegroup to rssrvpolicy.config :
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="ReportUtils"
Description="Code group for my data processing extension">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin\ReportUtils.dll"/>
</CodeGroup>
I deploy and execute the report on the server and an X appears where the barcode used to be when I tested it locally.
Has anyone got any suggestions ? pleeeeez.
Thanks
GrahamHi Graham,
Am also stuck in the barcodeless in pdf predicament. Have you a solution or work-around yet ? Pdf's on the server with barcodes in them look great but not exporting them from reporting services. Any suggestions appreciated. Steve.
"Reevesie" wrote:
> Hi All,
> I have a barcode that I use on one of my reports. When I test it on locally, the barcode displays and exports to PDF fine. I have made use of the barcode code samples on this forum (thanks), that makes use of a barcode font (FREE3OF9.TTF) that results in the DLL assemlbly (ReportUtils.DLL) returning a byte.
> I have done the following on my local machine:
> - Installed the FREE3OF9.TTF font.
> - copied the DLL on my local machine to :
> C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer\ReportUtils.dll
> - Added the following codegroup to rspreviewpolicy.config :
> <CodeGroup
> class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="ReportUtils"
> Description="Code group for my data processing extension">
> <IMembershipCondition
> class="UrlMembershipCondition"
> version="1"
> Url="C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer\ReportUtils.dll"/>
> </CodeGroup>
> and, done the following on the server machine:
> - Installed the FREE3OF9.TTF font.
> - copied the DLL on the report server to :
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin\ReportUtils.dll
> - Added the following codegroup to rssrvpolicy.config :
> <CodeGroup
> class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="ReportUtils"
> Description="Code group for my data processing extension">
> <IMembershipCondition
> class="UrlMembershipCondition"
> version="1"
> Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin\ReportUtils.dll"/>
> </CodeGroup>
> I deploy and execute the report on the server and an X appears where the barcode used to be when I tested it locally.
> Has anyone got any suggestions ? pleeeeez.
> Thanks
> Graham
>|||You need to embed font in the PDF file. Very easy to do that.
Take a look at http://www.morovia.com/support/|||I have been having exactly the same trouble. Has there been any progress on figuring out what is going wrong here?
Seth Ben-Ezra

Bar Chart Help

I would like to display the series field at the start of a bar instead of
using a legend.
thanks in advanceI'm not sure I understand the question correctly. A chart of type "bar" is
actually drawn with horizontal bars and the labels of the categories are
shown as text along the y-axis. Isn't that exactly what you are looking for?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tango" <Tango@.discussions.microsoft.com> wrote in message
news:7D560240-EF6A-4568-91E4-A3A8EB4CE0A3@.microsoft.com...
> I would like to display the series field at the start of a bar instead of
> using a legend.
> thanks in advance|||id like to have no y axis shown 9due to space limitations) but the name from
the y axis at the left hand side in the bar itself. Hope this makes sense.
"Robert Bruckner [MSFT]" wrote:
> I'm not sure I understand the question correctly. A chart of type "bar" is
> actually drawn with horizontal bars and the labels of the categories are
> shown as text along the y-axis. Isn't that exactly what you are looking for?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tango" <Tango@.discussions.microsoft.com> wrote in message
> news:7D560240-EF6A-4568-91E4-A3A8EB4CE0A3@.microsoft.com...
> > I would like to display the series field at the start of a bar instead of
> > using a legend.
> >
> > thanks in advance
>
>|||You could set the category label expressions to a blank: =" "
Then, use datapoint labels to show descriptions on the datapoint bars inside
the chart.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tango" <Tango@.discussions.microsoft.com> wrote in message
news:06EE7101-A06C-457C-B615-41FD45E7563F@.microsoft.com...
> id like to have no y axis shown 9due to space limitations) but the name
from
> the y axis at the left hand side in the bar itself. Hope this makes sense.
> "Robert Bruckner [MSFT]" wrote:
> > I'm not sure I understand the question correctly. A chart of type "bar"
is
> > actually drawn with horizontal bars and the labels of the categories are
> > shown as text along the y-axis. Isn't that exactly what you are looking
for?
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Tango" <Tango@.discussions.microsoft.com> wrote in message
> > news:7D560240-EF6A-4568-91E4-A3A8EB4CE0A3@.microsoft.com...
> > > I would like to display the series field at the start of a bar instead
of
> > > using a legend.
> > >
> > > thanks in advance
> >
> >
> >|||Thanks Robert,
i cant work out how to use a datapoint label.
"Robert Bruckner [MSFT]" wrote:
> You could set the category label expressions to a blank: =" "
> Then, use datapoint labels to show descriptions on the datapoint bars inside
> the chart.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tango" <Tango@.discussions.microsoft.com> wrote in message
> news:06EE7101-A06C-457C-B615-41FD45E7563F@.microsoft.com...
> > id like to have no y axis shown 9due to space limitations) but the name
> from
> > the y axis at the left hand side in the bar itself. Hope this makes sense.
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> > > I'm not sure I understand the question correctly. A chart of type "bar"
> is
> > > actually drawn with horizontal bars and the labels of the categories are
> > > shown as text along the y-axis. Isn't that exactly what you are looking
> for?
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Tango" <Tango@.discussions.microsoft.com> wrote in message
> > > news:7D560240-EF6A-4568-91E4-A3A8EB4CE0A3@.microsoft.com...
> > > > I would like to display the series field at the start of a bar instead
> of
> > > > using a legend.
> > > >
> > > > thanks in advance
> > >
> > >
> > >
>
>|||You will find a sample report at the bottom of this posting.
In particular investigate
* the category grouping label expression
* the datapoint label expression of the "UnitsInStock" series
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tango" <Tango@.discussions.microsoft.com> wrote in message
news:04DAD287-5566-487C-903B-4F5DD719DF21@.microsoft.com...
> Thanks Robert,
> i cant work out how to use a datapoint label.
>
> "Robert Bruckner [MSFT]" wrote:
> > You could set the category label expressions to a blank: =" "
> > Then, use datapoint labels to show descriptions on the datapoint bars
inside
> > the chart.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Tango" <Tango@.discussions.microsoft.com> wrote in message
> > news:06EE7101-A06C-457C-B615-41FD45E7563F@.microsoft.com...
> > > id like to have no y axis shown 9due to space limitations) but the
name
> > from
> > > the y axis at the left hand side in the bar itself. Hope this makes
sense.
> > >
> > > "Robert Bruckner [MSFT]" wrote:
> > >
> > > > I'm not sure I understand the question correctly. A chart of type
"bar"
> > is
> > > > actually drawn with horizontal bars and the labels of the categories
are
> > > > shown as text along the y-axis. Isn't that exactly what you are
looking
> > for?
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > > "Tango" <Tango@.discussions.microsoft.com> wrote in message
> > > > news:7D560240-EF6A-4568-91E4-A3A8EB4CE0A3@.microsoft.com...
> > > > > I would like to display the series field at the start of a bar
instead
> > of
> > > > > using a legend.
> > > > >
> > > > > thanks in advance
> > > >
=========================================================
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Chart Name="chart1">
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Legend>
<Visible>true</Visible>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Position>BottomCenter</Position>
</Legend>
<Palette>Default</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!UnitsInStock.Value)</Value>
</DataValue>
</DataValues>
<DataLabel>
<Value>=First(Fields!ProductName.Value)</Value>
<Visible>true</Visible>
</DataLabel>
<Marker>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!UnitsOnOrder.Value)</Value>
</DataValue>
</DataValues>
<DataLabel />
<Marker />
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<CategoryAxis>
<Axis>
<Title />
<MajorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Visible>true</Visible>
</Axis>
</CategoryAxis>
<DataSetName>DataSet1</DataSetName>
<PointWidth>0</PointWidth>
<Type>Bar</Type>
<Top>1in</Top>
<Title />
<Width>5.5in</Width>
<CategoryGroupings>
<CategoryGrouping>
<DynamicCategories>
<Grouping Name="chart1_CategoryGroup1">
<GroupExpressions>
<GroupExpression>=Fields!ProductName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Label>=" "</Label>
</DynamicCategories>
</CategoryGrouping>
</CategoryGroupings>
<Height>3in</Height>
<SeriesGroupings>
<SeriesGrouping>
<StaticSeries>
<StaticMember>
<Label>Units In Stock</Label>
</StaticMember>
<StaticMember>
<Label>Units On Order</Label>
</StaticMember>
</StaticSeries>
</SeriesGrouping>
</SeriesGroupings>
<Subtype>Plain</Subtype>
<PlotArea>
<Style>
<BackgroundColor>LightGrey</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</PlotArea>
<Left>0.625in</Left>
<ValueAxis>
<Axis>
<Title />
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Margin>true</Margin>
<Visible>true</Visible>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
</Chart>
</ReportItems>
<Style />
<Height>4.5in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="Northwind">
<rd:DataSourceID>f6248fbe-a9a8-40b9-8084-1f56b066026d</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>data source=.;initial
catalog=Northwind</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
</DataSource>
</DataSources>
<Width>6.5in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="ProductID">
<DataField>ProductID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ProductName">
<DataField>ProductName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="SupplierID">
<DataField>SupplierID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="CategoryID">
<DataField>CategoryID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="QuantityPerUnit">
<DataField>QuantityPerUnit</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="UnitPrice">
<DataField>UnitPrice</DataField>
<rd:TypeName>System.Decimal</rd:TypeName>
</Field>
<Field Name="UnitsInStock">
<DataField>UnitsInStock</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="UnitsOnOrder">
<DataField>UnitsOnOrder</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="ReorderLevel">
<DataField>ReorderLevel</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="Discontinued">
<DataField>Discontinued</DataField>
<rd:TypeName>System.Boolean</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>Northwind</DataSourceName>
<CommandText>select top 6 * from products</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>205aa2a3-8ec1-473c-a700-2270ed171aac</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>

Bar and line chart on same graph

Hi,
Is it possible to have a Bar chart and a Line chart on the same graph? I
have a series that I would like to display as a Bar chart and anther series
as line chart. is it possible?
thanks,In the Report Designer, go to the Chart Properties dialog. Click on the Data
tab, select the data point you want to make a line, click 'Edit..'. In the
chart value dialog, click on the Appearance tab and select 'Plot Data as
Line'.
"Prash" wrote:
> Hi,
> Is it possible to have a Bar chart and a Line chart on the same graph? I
> have a series that I would like to display as a Bar chart and anther series
> as line chart. is it possible?
> thanks,

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