Bar Chart with wrong text

Stimulsoft Reports.JS discussion
Post Reply
hugo
Posts: 359
Joined: Fri Mar 08, 2013 10:46 am

Bar Chart with wrong text

Post by hugo »

Hi,

Stimulsoft Reports FX shows vertical bar chars with formated amount values however the same report in Stimulsoft Reports JS show this way: ToString(#,##0.00)
Top
Lech Kulikowski
Posts: 6237
Joined: Tue Mar 20, 2018 5:34 am

Re: Bar Chart with wrong text

Post by Lech Kulikowski »

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.
Top
hugo
Posts: 359
Joined: Fri Mar 08, 2013 10:46 am

Re: Bar Chart with wrong text

Post by hugo »

The report schema:

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.02" application="StiReport" type="Flex">
<Dictionary isKey="true" type="Dictionary" Ref="1">
<Databases count="0" isList="true"/>
<DataSources count="1" isList="true">
<DynamicTable isKey="true" type="DataTableSource" Ref="2">
<Alias>DynamicTable</Alias>
<Columns count="10" isList="true">
<value>Type,System.Int32</value>
<value>Year,System.Int32</value>
<value>Month,System.Int32</value>
<value>YearMonth,System.String</value>
<value>Balance,System.Decimal</value>
<value>BuildingCode,System.String</value>
<value>BuildingDescription,System.String</value>
<value>BuildingAddress,System.String</value>
<value>BuildingPlace,System.String</value>
<value>BuildingZipCode,System.String</value>
</Columns>
<Dictionary isRef="1"/>
<Name>DynamicTable</Name>
<NameInSource>DynamicTable</NameInSource>
</DynamicTable>
</DataSources>
<Relations count="0" isList="true"/>
<Report isRef="0"/>
<Variables count="21" isList="true">
<value>,CompanyName,CompanyName,System.String,,False,False</value>
<value>,CompanyLogo,CompanyLogo,System.String,,False,False</value>
<value>,CompanyAdministratorShortName,CompanyAdministratorShortName,System.String,,False,False</value>
<value>,CompanySignature,CompanySignature,System.String,,False,False</value>
<value>,CompanyAvatar,CompanyAvatar,System.String,,False,False</value>
<value>,CompanyAddress,CompanyAddress,System.String,,False,False</value>
<value>,CompanyCounty,CompanyCounty,System.String,,False,False</value>
<value>,CompanyPlace,CompanyPlace,System.String,,False,False</value>
<value>,CompanyZipCode,CompanyZipCode,System.String,,False,False</value>
<value>,CompanyPhone,CompanyPhone,System.String,,False,False</value>
<value>,CompanyFAX,CompanyFAX,System.String,,False,False</value>
<value>,CompanyEMail,CompanyEMail,System.String,,False,False</value>
<value>,CompanyWebSite,CompanyWebSite,System.String,,False,False</value>
<value>,CompanyYears,CompanyYears,System.Int32,,False,False</value>
<value>,CompanyReportFooterExtraInfo,CompanyReportFooterExtraInfo,System.String,,False,False</value>
<value>,ReportBeginMonth,ReportBeginMonth,System.String,,False,False</value>
<value>,ReportEndMonth,ReportEndMonth,System.String,,False,False</value>
<value>,ReportBeginDay,ReportBeginDay,System.String,,False,False</value>
<value>,ReportEndDay,ReportEndDay,System.String,,False,False</value>
<value>,ReportBeginYear,ReportBeginYear,System.Int32,,False,False</value>
<value>,ReportEndYear,ReportEndYear,System.Int32,,False,False</value>
</Variables>
</Dictionary>
<EngineVersion>EngineV2</EngineVersion>
<GlobalizationStrings count="0" isList="true"/>
<MetaTags count="0" isList="true"/>
<Pages count="1" isList="true">
<Page1 isKey="true" type="Page" Ref="3">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<Components count="16" isList="true">
<Text3 isKey="true" type="Text" Ref="4">
<Brush>Transparent</Brush>
<ClientRectangle>0,28.1,20,0.61</ClientRectangle>
<Conditions count="0" isList="true"/>
<Font>Arial,8</Font>
<Guid>da409a172c85c6b23db7d4e37aa52e27</Guid>
<HorAlignment>Center</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text3</Name>
<Page isRef="3"/>
<Parent isRef="3"/>
<Text>{CompanyAddress} | {CompanyZipCode} | {CompanyPhone} | {CompanyFAX} | {CompanyEMail} | {CompanyWebSite} {CompanyReportFooterExtraInfo}</Text>
<TextBrush>[0:0:92]</TextBrush>
<Type>Expression</Type>
<VertAlignment>Center</VertAlignment>
</Text3>
<Chart1 isKey="true" type="Stimulsoft.Report.Chart.StiChart" Ref="5">
<Area isKey="true" type="Stimulsoft.Report.Chart.StiClusteredColumnArea" Ref="6">
<BorderColor>171, 172, 173</BorderColor>
<Brush>[255:255:255]</Brush>
<Chart isRef="5"/>
<GridLinesHor isKey="true" type="Stimulsoft.Report.Chart.StiGridLinesHor" Ref="7">
<Area isRef="6"/>
<Color>100, 105, 105, 105</Color>
<MinorColor>100, 105, 105, 105</MinorColor>
</GridLinesHor>
<GridLinesHorRight isKey="true" type="Stimulsoft.Report.Chart.StiGridLinesHor" Ref="8">
<Area isRef="6"/>
<Color>Silver</Color>
<MinorColor>Gainsboro</MinorColor>
<Visible>False</Visible>
</GridLinesHorRight>
<GridLinesVert isKey="true" type="Stimulsoft.Report.Chart.StiGridLinesVert" Ref="9">
<Area isRef="6"/>
<Color>100, 105, 105, 105</Color>
<MinorColor>100, 105, 105, 105</MinorColor>
</GridLinesVert>
<InterlacingHor isKey="true" type="Stimulsoft.Report.Chart.StiInterlacingHor" Ref="10">
<Area isRef="6"/>
<InterlacedBrush>[10:155:155:155]</InterlacedBrush>
</InterlacingHor>
<InterlacingVert isKey="true" type="Stimulsoft.Report.Chart.StiInterlacingVert" Ref="11">
<Area isRef="6"/>
<InterlacedBrush>[10:155:155:155]</InterlacedBrush>
</InterlacingVert>
<XAxis isKey="true" type="Stimulsoft.Report.Chart.StiXBottomAxis" Ref="12">
<Area isRef="6"/>
<DateTimeStep isKey="true" type="Stimulsoft.Report.Chart.StiAxisDateTimeStep" Ref="13"/>
<Interaction isKey="true" type="Stimulsoft.Report.Chart.StiAxisInteraction" Ref="14"/>
<Labels isKey="true" type="Stimulsoft.Report.Chart.StiAxisLabels" Ref="15">
<Color>140, 140, 140</Color>
<Font>Tahoma,8</Font>
</Labels>
<LineColor>140, 140, 140</LineColor>
<Range isKey="true" type="Stimulsoft.Report.Chart.StiAxisRange" Ref="16"/>
<Ticks isKey="true" type="Stimulsoft.Report.Chart.StiAxisTicks" Ref="17"/>
<Title isKey="true" type="Stimulsoft.Report.Chart.StiAxisTitle" Ref="18">
<Color>140, 140, 140</Color>
<Direction>LeftToRight</Direction>
<Font>Tahoma,12,Bold</Font>
</Title>
</XAxis>
<XTopAxis isKey="true" type="Stimulsoft.Report.Chart.StiXTopAxis" Ref="19">
<Area isRef="6"/>
<Interaction isKey="true" type="Stimulsoft.Report.Chart.StiAxisInteraction" Ref="20"/>
<Labels isKey="true" type="Stimulsoft.Report.Chart.StiAxisLabels" Ref="21">
<Color>140, 140, 140</Color>
<Font>Tahoma,8</Font>
</Labels>
<LineColor>140, 140, 140</LineColor>
<Ticks isKey="true" type="Stimulsoft.Report.Chart.StiAxisTicks" Ref="22"/>
<Title isKey="true" type="Stimulsoft.Report.Chart.StiAxisTitle" Ref="23">
<Color>140, 140, 140</Color>
<Direction>LeftToRight</Direction>
<Font>Tahoma,12,Bold</Font>
</Title>
</XTopAxis>
<YAxis isKey="true" type="Stimulsoft.Report.Chart.StiYLeftAxis" Ref="24">
<Area isRef="6"/>
<Interaction isKey="true" type="Stimulsoft.Report.Chart.StiAxisInteraction" Ref="25"/>
<Labels isKey="true" type="Stimulsoft.Report.Chart.StiAxisLabels" Ref="26">
<Color>140, 140, 140</Color>
<Font>Tahoma,8</Font>
</Labels>
<LineColor>140, 140, 140</LineColor>
<Range isKey="true" type="Stimulsoft.Report.Chart.StiAxisRange" Ref="27"/>
<Ticks isKey="true" type="Stimulsoft.Report.Chart.StiAxisTicks" Ref="28"/>
<Title isKey="true" type="Stimulsoft.Report.Chart.StiAxisTitle" Ref="29">
<Color>140, 140, 140</Color>
<Direction>BottomToTop</Direction>
<Font>Tahoma,12,Bold</Font>
</Title>
</YAxis>
<YRightAxis isKey="true" type="Stimulsoft.Report.Chart.StiYRightAxis" Ref="30">
<Area isRef="6"/>
<Interaction isKey="true" type="Stimulsoft.Report.Chart.StiAxisInteraction" Ref="31"/>
<Labels isKey="true" type="Stimulsoft.Report.Chart.StiAxisLabels" Ref="32">
<Color>140, 140, 140</Color>
<Font>Tahoma,8</Font>
<TextAlignment>Left</TextAlignment>
</Labels>
<LineColor>140, 140, 140</LineColor>
<Range isKey="true" type="Stimulsoft.Report.Chart.StiAxisRange" Ref="33"/>
<Ticks isKey="true" type="Stimulsoft.Report.Chart.StiAxisTicks" Ref="34"/>
<Title isKey="true" type="Stimulsoft.Report.Chart.StiAxisTitle" Ref="35">
<Color>140, 140, 140</Color>
<Direction>TopToBottom</Direction>
<Font>Tahoma,12,Bold</Font>
</Title>
</YRightAxis>
</Area>
<Brush>[255:255:255]</Brush>
<ClientRectangle>0.8,7.8,18.4,5.4</ClientRectangle>
<Conditions count="0" isList="true"/>
<ConstantLines count="0" isList="true"/>
<CustomStyleName/>
<DataSourceName>DynamicTable</DataSourceName>
<Filters count="1" isList="true">
<value>Type,EqualTo,_x0031_,,Numeric</value>
</Filters>
<Legend isKey="true" type="Stimulsoft.Report.Chart.StiLegend" Ref="36">
<BorderColor>225, 225, 225</BorderColor>
<Brush>[255:255:255]</Brush>
<Chart isRef="5"/>
<Font>Arial,8</Font>
<LabelsColor>140, 140, 140</LabelsColor>
<MarkerSize>10, 10</MarkerSize>
<TitleColor>105, 105, 105</TitleColor>
<TitleFont>Arial,14,Bold</TitleFont>
</Legend>
<Name>Chart1</Name>
<Page isRef="3"/>
<Parent isRef="3"/>
<Series count="1" isList="true">
<Item34 isKey="true" type="Stimulsoft.Report.Chart.StiClusteredColumnSeries" Ref="37">
<ArgumentDataColumn>DynamicTable.YearMonth</ArgumentDataColumn>
<BorderColor>255, 255, 255</BorderColor>
<Brush>[112:173:71]</Brush>
<BrushNegative>Firebrick</BrushNegative>
<Chart isRef="5"/>
<Conditions count="0" isList="true"/>
<Filters count="0" isList="true"/>
<SeriesLabels isKey="true" type="Stimulsoft.Report.Chart.StiCenterAxisLabels" Ref="38">
<BorderColor>Transparent</BorderColor>
<Brush>Transparent</Brush>
<Chart isRef="5"/>
<Font>Arial,7</Font>
<LabelColor>51, 71, 91</LabelColor>
<MarkerSize>8, 6</MarkerSize>
<ValueTypeSeparator>-</ValueTypeSeparator>
</SeriesLabels>
<ShowInLegend>False</ShowInLegend>
<Title>Séries 1</Title>
<TopN isKey="true" type="Stimulsoft.Report.Chart.StiSeriesTopN" Ref="39"/>
<TrendLine isKey="true" type="Stimulsoft.Report.Chart.StiTrendLineNone" Ref="40">
<LineColor>Black</LineColor>
<LineStyle>0</LineStyle>
<ShowShadow>True</ShowShadow>
</TrendLine>
<ValueDataColumn>DynamicTable.Balance</ValueDataColumn>
</Item34>
</Series>
<SeriesLabels isKey="true" type="Stimulsoft.Report.Chart.StiCenterAxisLabels" Ref="41">
<Angle>270</Angle>
<BorderColor>Transparent</BorderColor>
<Brush>Transparent</Brush>
<Chart isRef="5"/>
<Font>Arial,7,Bold</Font>
<Format>ToString("#,##0.00")</Format>
<LabelColor>51, 71, 91</LabelColor>
<MarkerSize>8, 6</MarkerSize>
<TextAfter>€</TextAfter>
<ValueTypeSeparator>-</ValueTypeSeparator>
</SeriesLabels>
<SeriesLabelsConditions count="0" isList="true"/>
<Sort count="0" isList="true"/>
<Strips count="0" isList="true"/>
<Style isKey="true" type="Stimulsoft.Report.Chart.StiStyle25" Ref="42"/>
<Table isKey="true" type="Stimulsoft.Report.Chart.StiChartTable" Ref="43">
<Font>Tahoma,8</Font>
<GridLineColor>225, 225, 225</GridLineColor>
<Header isKey="true" type="Stimulsoft.Report.Chart.StiChartTableHeader" Ref="44">
<Brush>White</Brush>
<Font>Arial,8</Font>
<TextColor>DarkGray</TextColor>
</Header>
<TextColor>140, 140, 140</TextColor>
</Table>
<Title isKey="true" type="Stimulsoft.Report.Chart.StiChartTitle" Ref="45">
<Brush>[140:140:140]</Brush>
<Font>Tahoma,12,Bold</Font>
</Title>
</Chart1>
<Chart3 isKey="true" type="Stimulsoft.Report.Chart.StiChart" Ref="46">
<Area isKey="true" type="Stimulsoft.Report.Chart.StiClusteredColumnArea" Ref="47">
<BorderColor>171, 172, 173</BorderColor>
<Brush>White</Brush>
<Chart isRef="46"/>
<GridLinesHor isKey="true" type="Stimulsoft.Report.Chart.StiGridLinesHor" Ref="48">
<Area isRef="47"/>
<Color>100, 105, 105, 105</Color>
<MinorColor>100, 105, 105, 105</MinorColor>
</GridLinesHor>
<GridLinesHorRight isKey="true" type="Stimulsoft.Report.Chart.StiGridLinesHor" Ref="49">
<Area isRef="47"/>
<Color>Silver</Color>
<MinorColor>Gainsboro</MinorColor>
<Visible>False</Visible>
</GridLinesHorRight>
<GridLinesVert isKey="true" type="Stimulsoft.Report.Chart.StiGridLinesVert" Ref="50">
<Area isRef="47"/>
<Color>100, 105, 105, 105</Color>
<MinorColor>100, 105, 105, 105</MinorColor>
</GridLinesVert>
<InterlacingHor isKey="true" type="Stimulsoft.Report.Chart.StiInterlacingHor" Ref="51">
<Area isRef="47"/>
<InterlacedBrush>[10:155:155:155]</InterlacedBrush>
</InterlacingHor>
<InterlacingVert isKey="true" type="Stimulsoft.Report.Chart.StiInterlacingVert" Ref="52">
<Area isRef="47"/>
<InterlacedBrush>[10:155:155:155]</InterlacedBrush>
</InterlacingVert>
<XAxis isKey="true" type="Stimulsoft.Report.Chart.StiXBottomAxis" Ref="53">
<Area isRef="47"/>
<DateTimeStep isKey="true" type="Stimulsoft.Report.Chart.StiAxisDateTimeStep" Ref="54"/>
<Interaction isKey="true" type="Stimulsoft.Report.Chart.StiAxisInteraction" Ref="55"/>
<Labels isKey="true" type="Stimulsoft.Report.Chart.StiAxisLabels" Ref="56">
<Color>140, 140, 140</Color>
<Font>Tahoma,8</Font>
</Labels>
<LineColor>140, 140, 140</LineColor>
<Range isKey="true" type="Stimulsoft.Report.Chart.StiAxisRange" Ref="57"/>
<Ticks isKey="true" type="Stimulsoft.Report.Chart.StiAxisTicks" Ref="58"/>
<Title isKey="true" type="Stimulsoft.Report.Chart.StiAxisTitle" Ref="59">
<Color>140, 140, 140</Color>
<Direction>LeftToRight</Direction>
<Font>Tahoma,12,Bold</Font>
</Title>
</XAxis>
<XTopAxis isKey="true" type="Stimulsoft.Report.Chart.StiXTopAxis" Ref="60">
<Area isRef="47"/>
<Interaction isKey="true" type="Stimulsoft.Report.Chart.StiAxisInteraction" Ref="61"/>
<Labels isKey="true" type="Stimulsoft.Report.Chart.StiAxisLabels" Ref="62">
<Color>140, 140, 140</Color>
<Font>Tahoma,8</Font>
</Labels>
<LineColor>140, 140, 140</LineColor>
<Ticks isKey="true" type="Stimulsoft.Report.Chart.StiAxisTicks" Ref="63"/>
<Title isKey="true" type="Stimulsoft.Report.Chart.StiAxisTitle" Ref="64">
<Color>140, 140, 140</Color>
<Direction>LeftToRight</Direction>
<Font>Tahoma,12,Bold</Font>
</Title>
</XTopAxis>
<YAxis isKey="true" type="Stimulsoft.Report.Chart.StiYLeftAxis" Ref="65">
<Area isRef="47"/>
<Interaction isKey="true" type="Stimulsoft.Report.Chart.StiAxisInteraction" Ref="66"/>
<Labels isKey="true" type="Stimulsoft.Report.Chart.StiAxisLabels" Ref="67">
<Color>140, 140, 140</Color>
<Font>Tahoma,8</Font>
</Labels>
<LineColor>140, 140, 140</LineColor>
<Range isKey="true" type="Stimulsoft.Report.Chart.StiAxisRange" Ref="68"/>
<Ticks isKey="true" type="Stimulsoft.Report.Chart.StiAxisTicks" Ref="69"/>
<Title isKey="true" type="Stimulsoft.Report.Chart.StiAxisTitle" Ref="70">
<Color>140, 140, 140</Color>
<Direction>BottomToTop</Direction>
<Font>Tahoma,12,Bold</Font>
</Title>
</YAxis>
<YRightAxis isKey="true" type="Stimulsoft.Report.Chart.StiYRightAxis" Ref="71">
<Area isRef="47"/>
<Interaction isKey="true" type="Stimulsoft.Report.Chart.StiAxisInteraction" Ref="72"/>
<Labels isKey="true" type="Stimulsoft.Report.Chart.StiAxisLabels" Ref="73">
<Color>140, 140, 140</Color>
<Font>Tahoma,8</Font>
<TextAlignment>Left</TextAlignment>
</Labels>
<LineColor>140, 140, 140</LineColor>
<Range isKey="true" type="Stimulsoft.Report.Chart.StiAxisRange" Ref="74"/>
<Ticks isKey="true" type="Stimulsoft.Report.Chart.StiAxisTicks" Ref="75"/>
<Title isKey="true" type="Stimulsoft.Report.Chart.StiAxisTitle" Ref="76">
<Color>140, 140, 140</Color>
<Direction>TopToBottom</Direction>
<Font>Tahoma,12,Bold</Font>
</Title>
</YRightAxis>
</Area>
<Brush>[255:255:255]</Brush>
<ClientRectangle>0.8,14.8,18.4,5.4</ClientRectangle>
<Conditions count="0" isList="true"/>
<ConstantLines count="0" isList="true"/>
<CustomStyleName/>
<DataSourceName>DynamicTable</DataSourceName>
<Filters count="1" isList="true">
<value>Type,EqualTo,_x0032_,,Numeric</value>
</Filters>
<Guid>bb58e8289d286c03d2375275bd9de3a1</Guid>
<Legend isKey="true" type="Stimulsoft.Report.Chart.StiLegend" Ref="77">
<BorderColor>225, 225, 225</BorderColor>
<Brush>[255:255:255]</Brush>
<Chart isRef="46"/>
<Font>Arial,8</Font>
<LabelsColor>140, 140, 140</LabelsColor>
<MarkerSize>10, 10</MarkerSize>
<TitleColor>105, 105, 105</TitleColor>
<TitleFont>Arial,14,Bold</TitleFont>
</Legend>
<Name>Chart3</Name>
<Page isRef="3"/>
<Parent isRef="3"/>
<Series count="1" isList="true">
<Item74 isKey="true" type="Stimulsoft.Report.Chart.StiClusteredColumnSeries" Ref="78">
<ArgumentDataColumn>DynamicTable.YearMonth</ArgumentDataColumn>
<BorderColor>255, 255, 255</BorderColor>
<Brush>[46:198:200]</Brush>
<BrushNegative>Firebrick</BrushNegative>
<Chart isRef="46"/>
<Conditions count="0" isList="true"/>
<Filters count="0" isList="true"/>
<SeriesLabels isKey="true" type="Stimulsoft.Report.Chart.StiCenterAxisLabels" Ref="79">
<BorderColor>Transparent</BorderColor>
<Brush>Transparent</Brush>
<Chart isRef="46"/>
<Font>Arial,7</Font>
<LabelColor>51, 71, 91</LabelColor>
<MarkerSize>8, 6</MarkerSize>
<ValueTypeSeparator>-</ValueTypeSeparator>
</SeriesLabels>
<ShowInLegend>False</ShowInLegend>
<Title>Fornecedores</Title>
<TopN isKey="true" type="Stimulsoft.Report.Chart.StiSeriesTopN" Ref="80"/>
<TrendLine isKey="true" type="Stimulsoft.Report.Chart.StiTrendLineNone" Ref="81">
<LineColor>Black</LineColor>
<LineStyle>0</LineStyle>
<ShowShadow>True</ShowShadow>
</TrendLine>
<ValueDataColumn>DynamicTable.Balance</ValueDataColumn>
</Item74>
</Series>
<SeriesLabels isKey="true" type="Stimulsoft.Report.Chart.StiCenterAxisLabels" Ref="82">
<Angle>270</Angle>
<BorderColor>Transparent</BorderColor>
<Brush>Transparent</Brush>
<Chart isRef="46"/>
<Font>Arial,7,Bold</Font>
<Format>ToString("#,##0.00")</Format>
<LabelColor>51, 71, 91</LabelColor>
<MarkerSize>8, 6</MarkerSize>
<TextAfter>€</TextAfter>
<ValueTypeSeparator>-</ValueTypeSeparator>
</SeriesLabels>
<SeriesLabelsConditions count="0" isList="true"/>
<Sort count="0" isList="true"/>
<Strips count="0" isList="true"/>
<Style isKey="true" type="Stimulsoft.Report.Chart.StiStyle26" Ref="83"/>
<Table isKey="true" type="Stimulsoft.Report.Chart.StiChartTable" Ref="84">
<Font>Tahoma,8</Font>
<GridLineColor>225, 225, 225</GridLineColor>
<Header isKey="true" type="Stimulsoft.Report.Chart.StiChartTableHeader" Ref="85">
<Brush>White</Brush>
<Font>Arial,8</Font>
<TextColor>DarkGray</TextColor>
</Header>
<TextColor>140, 140, 140</TextColor>
</Table>
<Title isKey="true" type="Stimulsoft.Report.Chart.StiChartTitle" Ref="86">
<Brush>[140:140:140]</Brush>
<Font>Tahoma,12,Bold</Font>
</Title>
</Chart3>
<Chart4 isKey="true" type="Stimulsoft.Report.Chart.StiChart" Ref="87">
<AllowApplyStyle>False</AllowApplyStyle>
<Area isKey="true" type="Stimulsoft.Report.Chart.StiClusteredColumnArea" Ref="88">
<BorderColor>171, 172, 173</BorderColor>
<Brush>[255:255:255]</Brush>
<Chart isRef="87"/>
<GridLinesHor isKey="true" type="Stimulsoft.Report.Chart.StiGridLinesHor" Ref="89">
<Area isRef="88"/>
<Color>100, 105, 105, 105</Color>
<MinorColor>100, 105, 105, 105</MinorColor>
</GridLinesHor>
<GridLinesHorRight isKey="true" type="Stimulsoft.Report.Chart.StiGridLinesHor" Ref="90">
<Area isRef="88"/>
<Color>Silver</Color>
<MinorColor>Gainsboro</MinorColor>
<Visible>False</Visible>
</GridLinesHorRight>
<GridLinesVert isKey="true" type="Stimulsoft.Report.Chart.StiGridLinesVert" Ref="91">
<Area isRef="88"/>
<Color>100, 105, 105, 105</Color>
<MinorColor>100, 105, 105, 105</MinorColor>
</GridLinesVert>
<InterlacingHor isKey="true" type="Stimulsoft.Report.Chart.StiInterlacingHor" Ref="92">
<Area isRef="88"/>
<InterlacedBrush>[10:155:155:155]</InterlacedBrush>
</InterlacingHor>
<InterlacingVert isKey="true" type="Stimulsoft.Report.Chart.StiInterlacingVert" Ref="93">
<Area isRef="88"/>
<InterlacedBrush>[10:155:155:155]</InterlacedBrush>
</InterlacingVert>
<XAxis isKey="true" type="Stimulsoft.Report.Chart.StiXBottomAxis" Ref="94">
<Area isRef="88"/>
<DateTimeStep isKey="true" type="Stimulsoft.Report.Chart.StiAxisDateTimeStep" Ref="95"/>
<Interaction isKey="true" type="Stimulsoft.Report.Chart.StiAxisInteraction" Ref="96"/>
<Labels isKey="true" type="Stimulsoft.Report.Chart.StiAxisLabels" Ref="97">
<Color>140, 140, 140</Color>
<Font>Tahoma,8</Font>
</Labels>
<LineColor>140, 140, 140</LineColor>
<Range isKey="true" type="Stimulsoft.Report.Chart.StiAxisRange" Ref="98"/>
<Ticks isKey="true" type="Stimulsoft.Report.Chart.StiAxisTicks" Ref="99"/>
<Title isKey="true" type="Stimulsoft.Report.Chart.StiAxisTitle" Ref="100">
<Color>140, 140, 140</Color>
<Direction>LeftToRight</Direction>
<Font>Tahoma,12,Bold</Font>
</Title>
</XAxis>
<XTopAxis isKey="true" type="Stimulsoft.Report.Chart.StiXTopAxis" Ref="101">
<Area isRef="88"/>
<Interaction isKey="true" type="Stimulsoft.Report.Chart.StiAxisInteraction" Ref="102"/>
<Labels isKey="true" type="Stimulsoft.Report.Chart.StiAxisLabels" Ref="103">
<Color>140, 140, 140</Color>
<Font>Tahoma,8</Font>
</Labels>
<LineColor>140, 140, 140</LineColor>
<Ticks isKey="true" type="Stimulsoft.Report.Chart.StiAxisTicks" Ref="104"/>
<Title isKey="true" type="Stimulsoft.Report.Chart.StiAxisTitle" Ref="105">
<Color>140, 140, 140</Color>
<Direction>LeftToRight</Direction>
<Font>Tahoma,12,Bold</Font>
</Title>
</XTopAxis>
<YAxis isKey="true" type="Stimulsoft.Report.Chart.StiYLeftAxis" Ref="106">
<Area isRef="88"/>
<Interaction isKey="true" type="Stimulsoft.Report.Chart.StiAxisInteraction" Ref="107"/>
<Labels isKey="true" type="Stimulsoft.Report.Chart.StiAxisLabels" Ref="108">
<Color>140, 140, 140</Color>
<Font>Tahoma,8</Font>
</Labels>
<LineColor>140, 140, 140</LineColor>
<Range isKey="true" type="Stimulsoft.Report.Chart.StiAxisRange" Ref="109"/>
<Ticks isKey="true" type="Stimulsoft.Report.Chart.StiAxisTicks" Ref="110"/>
<Title isKey="true" type="Stimulsoft.Report.Chart.StiAxisTitle" Ref="111">
<Color>140, 140, 140</Color>
<Direction>BottomToTop</Direction>
<Font>Tahoma,12,Bold</Font>
</Title>
</YAxis>
<YRightAxis isKey="true" type="Stimulsoft.Report.Chart.StiYRightAxis" Ref="112">
<Area isRef="88"/>
<Interaction isKey="true" type="Stimulsoft.Report.Chart.StiAxisInteraction" Ref="113"/>
<Labels isKey="true" type="Stimulsoft.Report.Chart.StiAxisLabels" Ref="114">
<Color>140, 140, 140</Color>
<Font>Tahoma,8</Font>
<TextAlignment>Left</TextAlignment>
</Labels>
<LineColor>140, 140, 140</LineColor>
<Range isKey="true" type="Stimulsoft.Report.Chart.StiAxisRange" Ref="115"/>
<Ticks isKey="true" type="Stimulsoft.Report.Chart.StiAxisTicks" Ref="116"/>
<Title isKey="true" type="Stimulsoft.Report.Chart.StiAxisTitle" Ref="117">
<Color>140, 140, 140</Color>
<Direction>TopToBottom</Direction>
<Font>Tahoma,12,Bold</Font>
</Title>
</YRightAxis>
</Area>
<Brush>[255:255:255]</Brush>
<ClientRectangle>0.8,21.6,18.4,5.4</ClientRectangle>
<Conditions count="0" isList="true"/>
<ConstantLines count="0" isList="true"/>
<CustomStyleName/>
<DataSourceName>DynamicTable</DataSourceName>
<Filters count="1" isList="true">
<value>Type,EqualTo,_x0033_,,Numeric</value>
</Filters>
<Guid>9ddf5b148f5d428951ff52760789b056</Guid>
<Legend isKey="true" type="Stimulsoft.Report.Chart.StiLegend" Ref="118">
<BorderColor>105, 105, 105</BorderColor>
<Brush>[255:255:255]</Brush>
<Chart isRef="87"/>
<Font>Arial,8</Font>
<LabelsColor>140, 140, 140</LabelsColor>
<MarkerSize>10, 10</MarkerSize>
<TitleColor>105, 105, 105</TitleColor>
<TitleFont>Arial,14,Bold</TitleFont>
</Legend>
<Name>Chart4</Name>
<Page isRef="3"/>
<Parent isRef="3"/>
<Series count="1" isList="true">
<Item114 isKey="true" type="Stimulsoft.Report.Chart.StiClusteredColumnSeries" Ref="119">
<ArgumentDataColumn>DynamicTable.YearMonth</ArgumentDataColumn>
<BorderColor>255, 255, 255</BorderColor>
<Brush>[237:125:49]</Brush>
<BrushNegative>Firebrick</BrushNegative>
<Chart isRef="87"/>
<Conditions count="0" isList="true"/>
<Filters count="0" isList="true"/>
<SeriesLabels isKey="true" type="Stimulsoft.Report.Chart.StiCenterAxisLabels" Ref="120">
<BorderColor>140, 140, 140</BorderColor>
<Brush>[255:255:255]</Brush>
<Chart isRef="87"/>
<Font>Arial,7</Font>
<LabelColor>90, 90, 90</LabelColor>
<MarkerSize>8, 6</MarkerSize>
<ValueTypeSeparator>-</ValueTypeSeparator>
</SeriesLabels>
<ShowInLegend>False</ShowInLegend>
<Title>Bancos</Title>
<TopN isKey="true" type="Stimulsoft.Report.Chart.StiSeriesTopN" Ref="121"/>
<TrendLine isKey="true" type="Stimulsoft.Report.Chart.StiTrendLineNone" Ref="122">
<LineColor>Black</LineColor>
<LineStyle>0</LineStyle>
<ShowShadow>True</ShowShadow>
</TrendLine>
<ValueDataColumn>DynamicTable.Balance</ValueDataColumn>
</Item114>
</Series>
<SeriesLabels isKey="true" type="Stimulsoft.Report.Chart.StiCenterAxisLabels" Ref="123">
<Angle>270</Angle>
<BorderColor>Transparent</BorderColor>
<Brush>EmptyBrush</Brush>
<Chart isRef="87"/>
<Font>Arial,7,Bold</Font>
<Format>ToString("#,##0.00")</Format>
<LabelColor>51, 71, 91</LabelColor>
<MarkerSize>8, 6</MarkerSize>
<TextAfter>€</TextAfter>
<ValueTypeSeparator>-</ValueTypeSeparator>
</SeriesLabels>
<SeriesLabelsConditions count="0" isList="true"/>
<Sort count="0" isList="true"/>
<Strips count="0" isList="true"/>
<Style isKey="true" type="Stimulsoft.Report.Chart.StiStyle24" Ref="124"/>
<Table isKey="true" type="Stimulsoft.Report.Chart.StiChartTable" Ref="125">
<Font>Tahoma,8</Font>
<GridLineColor>105, 105, 105</GridLineColor>
<Header isKey="true" type="Stimulsoft.Report.Chart.StiChartTableHeader" Ref="126">
<Brush>White</Brush>
<Font>Arial,8</Font>
<TextColor>DarkGray</TextColor>
</Header>
<TextColor>140, 140, 140</TextColor>
</Table>
<Title isKey="true" type="Stimulsoft.Report.Chart.StiChartTitle" Ref="127">
<Brush>[140:140:140]</Brush>
<Font>Tahoma,12,Bold</Font>
</Title>
</Chart4>
<Text4 isKey="true" type="Text" Ref="128">
<Brush>Transparent</Brush>
<ClientRectangle>0.8,14.2,18.4,0.6</ClientRectangle>
<Conditions count="0" isList="true"/>
<Font>Arial,10</Font>
<Guid>357185cdcd79c8399eb252a60acc9268</Guid>
<HorAlignment>Center</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text4</Name>
<Page isRef="3"/>
<Parent isRef="3"/>
<Text>Dívidas a Fornecedores</Text>
<TextBrush>Black</TextBrush>
<Type>Expression</Type>
<VertAlignment>Center</VertAlignment>
</Text4>
<Text5 isKey="true" type="Text" Ref="129">
<Brush>Transparent</Brush>
<ClientRectangle>0.8,21,18.4,0.6</ClientRectangle>
<Conditions count="0" isList="true"/>
<Font>Arial,10</Font>
<Guid>aaf1209f7b6bebf5b95e52a6ac02c0ba</Guid>
<HorAlignment>Center</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text5</Name>
<Page isRef="3"/>
<Parent isRef="3"/>
<Text>Saldo Bancário</Text>
<TextBrush>Black</TextBrush>
<Type>Expression</Type>
<VertAlignment>Center</VertAlignment>
</Text5>
<Text1 isKey="true" type="Text" Ref="130">
<Brush>Transparent</Brush>
<ClientRectangle>0.8,7.2,18.4,0.6</ClientRectangle>
<Conditions count="0" isList="true"/>
<Font>Arial,10</Font>
<HorAlignment>Center</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text1</Name>
<Page isRef="3"/>
<Parent isRef="3"/>
<Text>Dívidas de Condóminos</Text>
<TextBrush>Black</TextBrush>
<TextFormat isKey="true" type="CurrencyFormat" Ref="131">
<GroupSeparator></GroupSeparator>
<NegativePattern>1</NegativePattern>
<PositivePattern>1</PositivePattern>
<Symbol>€</Symbol>
</TextFormat>
<Type>Expression</Type>
<VertAlignment>Center</VertAlignment>
</Text1>
<Text10 isKey="true" type="Text" Ref="132">
<Brush>Transparent</Brush>
<ClientRectangle>4.4,4.6,11.6,0.6</ClientRectangle>
<Conditions count="0" isList="true"/>
<Font>Arial,14,Bold</Font>
<HorAlignment>Center</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text10</Name>
<Page isRef="3"/>
<Parent isRef="3"/>
<Text>Gráfico da evolução económica do condomínio</Text>
<TextBrush>Black</TextBrush>
<Type>Expression</Type>
<VertAlignment>Center</VertAlignment>
</Text10>
<Text11 isKey="true" type="Text" Ref="133">
<Brush>Transparent</Brush>
<ClientRectangle>12.8,6.4,6.4,0.4</ClientRectangle>
<Conditions count="0" isList="true"/>
<Font>Arial,10,Bold</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text11</Name>
<Page isRef="3"/>
<Parent isRef="3"/>
<Text>De {ReportBeginMonth} {ReportBeginYear} a {ReportEndMonth} {ReportEndYear}</Text>
<TextBrush>Black</TextBrush>
<Type>Expression</Type>
<VertAlignment>Center</VertAlignment>
</Text11>
<Text2 isKey="true" type="Text" Ref="134">
<Brush>Transparent</Brush>
<ClientRectangle>11.8,1.6,1.6,0.4</ClientRectangle>
<Conditions count="0" isList="true"/>
<Font>Arial,10,Bold</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text2</Name>
<Page isRef="3"/>
<Parent isRef="3"/>
<Text>{DynamicTable.BuildingCode}</Text>
<TextBrush>Black</TextBrush>
<VertAlignment>Center</VertAlignment>
</Text2>
<Text9 isKey="true" type="Text" Ref="135">
<Brush>Transparent</Brush>
<ClientRectangle>13.6,2.8,6.2,0.4</ClientRectangle>
<Conditions count="0" isList="true"/>
<Font>Arial,10</Font>
<Margins>0,0,0,0</Margins>
<Name>Text9</Name>
<Page isRef="3"/>
<Parent isRef="3"/>
<Text>{DynamicTable.BuildingZipCode}</Text>
<TextBrush>Black</TextBrush>
</Text9>
<Text8 isKey="true" type="Text" Ref="136">
<Brush>Transparent</Brush>
<ClientRectangle>13.6,2.4,6.2,0.4</ClientRectangle>
<Conditions count="0" isList="true"/>
<Font>Arial,10</Font>
<Margins>0,0,0,0</Margins>
<Name>Text8</Name>
<Page isRef="3"/>
<Parent isRef="3"/>
<Text>{DynamicTable.BuildingPlace}</Text>
<TextBrush>Black</TextBrush>
</Text8>
<Text7 isKey="true" type="Text" Ref="137">
<Brush>Transparent</Brush>
<ClientRectangle>13.6,2,6.2,0.4</ClientRectangle>
<Conditions count="0" isList="true"/>
<Font>Arial,10</Font>
<Margins>0,0,0,0</Margins>
<Name>Text7</Name>
<Page isRef="3"/>
<Parent isRef="3"/>
<Text>{DynamicTable.BuildingAddress}</Text>
<TextBrush>Black</TextBrush>
</Text7>
<Text6 isKey="true" type="Text" Ref="138">
<Brush>Transparent</Brush>
<ClientRectangle>13.6,1.6,6.2,0.4</ClientRectangle>
<Conditions count="0" isList="true"/>
<Font>Arial,10</Font>
<Margins>0,0,0,0</Margins>
<Name>Text6</Name>
<Page isRef="3"/>
<Parent isRef="3"/>
<Text>{DynamicTable.BuildingDescription}</Text>
<TextBrush>Black</TextBrush>
<VertAlignment>Center</VertAlignment>
</Text6>
<Image1 isKey="true" type="Image" Ref="139">
<Brush>Transparent</Brush>
<ClientRectangle>-0.4,-0.4,6.4,4</ClientRectangle>
<Conditions count="0" isList="true"/>
<DataColumn isNull="true"/>
<Guid>d0fd1764910851b83b908876516c9d1c</Guid>
<ImageData>{CompanyLogo}</ImageData>
<Name>Image1</Name>
<Page isRef="3"/>
<Parent isRef="3"/>
</Image1>
<HeaderBand1 isKey="true" type="HeaderBand" Ref="140">
<Brush>Transparent</Brush>
<ClientRectangle>0,0.4,20,1</ClientRectangle>
<Components count="0" isList="true"/>
<Conditions count="0" isList="true"/>
<Name>HeaderBand1</Name>
<Page isRef="3"/>
<Parent isRef="3"/>
</HeaderBand1>
</Components>
<Conditions count="0" isList="true"/>
<Guid>abbcf258df40d7adb7df4505e8b79cc2</Guid>
<Margins>0.5,0.5,0.5,0.5</Margins>
<Name>Page1</Name>
<PageHeight>29.7</PageHeight>
<PageWidth>21</PageWidth>
<PaperSize>A4</PaperSize>
<Report isRef="0"/>
<Watermark isKey="true" type="Stimulsoft.Report.Components.StiWatermark" Ref="141">
<Font>Arial,46</Font>
<ImageBytes/>
<TextBrush>[50:0:0:0]</TextBrush>
</Watermark>
</Page1>
</Pages>
<PrinterSettings isKey="true" type="Stimulsoft.Report.Print.StiPrinterSettings" Ref="142"/>
<ReportAlias>Report</ReportAlias>
<ReportChanged>10/24/2022 01:10:08 AM</ReportChanged>
<ReportCreated>12/30/2013 07:40:51 PM</ReportCreated>
<ReportFile>/Volumes/Data/Template.mrt</ReportFile>
<ReportGuid>d18b8ba6034c72ccc4620752ef480be2</ReportGuid>
<ReportName>Report</ReportName>
<ReportUnit>Centimeters</ReportUnit>
<ReportVersion>2018.2.1</ReportVersion>
<ScriptLanguage>CSharp</ScriptLanguage>
<Styles count="0" isList="true"/>
</StiSerializer>

A piece of the data:
[
{
‘Type’: 1
‘BuildingCode’: ‘002’
‘BuildinDescription’ ‘Teste 1’
‘BuildingPlace’: ‘Teste 1’
‘BuildingZipCode’ : ‘Teste 1’,
‘Year’: 2022,
‘Month’: 7,
YearMonth: ‘Jul de 2022’,
Balance: 23750.16
},
{
‘Type’: 1
‘BuildingCode’: ‘002’
‘BuildinDescription’ ‘Teste 2’
‘BuildingPlace’: ‘Teste 2’
‘BuildingZipCode’ : ‘Teste 2’,
‘Year’: 2022,
‘Month’: 8,
YearMonth: ‘Ago de 2022’,
Balance: 24991.3
}
]
Top
Max Shamanov
Posts: 786
Joined: Tue Sep 07, 2021 10:11 am

Re: Bar Chart with wrong text

Post by Max Shamanov »

Hello,

The following expression should be used for labels
#,##0.00
Please check the attached image.

Thank you.
Attachments
Designer_bBkSTiAvQq.png
Designer_bBkSTiAvQq.png (193.32 KiB) Viewed 812 times
Top
hugo
Posts: 359
Joined: Fri Mar 08, 2013 10:46 am

Re: Bar Chart with wrong text

Post by hugo »

Thank you very much (problem solved).
The problem was that in the old editor (Flex version), I don't see that option, so I replaced in a simpler editor.
It's not a big issue because I don't have may reports with charts and in a few moths we will work only with the JS version.
Top
Max Shamanov
Posts: 786
Joined: Tue Sep 07, 2021 10:11 am

Re: Bar Chart with wrong text

Post by Max Shamanov »

Hello,

You are welcome!
Top
Post Reply

Return to “Stimulsoft Reports.JS”