Creating reports and dashboards | Stimulsoft community forum

Hello All !

im trying to get a clustered column graph to show negative values, it shows positive just fine, but all negative values do not show. Is there a property to show negative values? I have a series one with a positive value and one with a negative, only the positive shows up. See Below:
This is where i created the chart...

[left]Stimulsoft.Report.Chart.StiClusteredColumnArea Chart1_Area = new Stimulsoft.Report.Chart.StiClusteredColumnArea();
Chart1_Area.BorderColor = System.Drawing.Color.FromArgb(255, 88, 86, 75);
Chart1_Area.Brush = new Stimulsoft.Base.Drawing.StiGradientBrush(System.Drawing.Color.FromArgb(255, 255, 255, 255), System.Drawing.Color.FromArgb(255, 255, 255, 255), 90);
Chart1_Area.GridLinesHor = new Stimulsoft.Report.Chart.StiGridLinesHor(System.Drawing.Color.FromArgb(100, 88, 86, 75), Stimulsoft.Base.Drawing.StiPenStyle.Dot, true, System.Drawing.Color.FromArgb(100, 88, 86, 75), Stimulsoft.Base.Drawing.StiPenStyle.Dot, false, 0);
Chart1_Area.GridLinesHorRight = new Stimulsoft.Report.Chart.StiGridLinesHor(System.Drawing.Color.Silver, Stimulsoft.Base.Drawing.StiPenStyle.Dot, false, System.Drawing.Color.Gainsboro, Stimulsoft.Base.Drawing.StiPenStyle.Dot, false, 0);
Chart1_Area.GridLinesVert = new Stimulsoft.Report.Chart.StiGridLinesVert(System.Drawing.Color.FromArgb(100, 88, 86, 75), Stimulsoft.Base.Drawing.StiPenStyle.Dot, true, System.Drawing.Color.FromArgb(100, 88, 86, 75), Stimulsoft.Base.Drawing.StiPenStyle.Dot, false, 0);
Chart1_Area.InterlacingHor = new Stimulsoft.Report.Chart.StiInterlacingHor(new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(10, 138, 136, 125)), true);
Chart1_Area.InterlacingVert = new Stimulsoft.Report.Chart.StiInterlacingVert(new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(10, 138, 136, 125)), true);
Chart1_Area.XAxis = new Stimulsoft.Report.Chart.StiXBottomAxis(new Stimulsoft.Report.Chart.StiAxisLabels("", "", "", 0F, new System.Drawing.Font("Tahoma", 8F), true, Stimulsoft.Report.Chart.StiLabelsPlacement.OneLine, System.Drawing.Color.FromArgb(255, 88, 86, 75), 0F, Stimulsoft.Report.Chart.StiMarkerAlignment.Right), new Stimulsoft.Report.Chart.StiAxisRange(true, 0, 0), new Stimulsoft.Report.Chart.StiAxisTitle(new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Bold), "", System.Drawing.Color.FromArgb(255, 88, 86, 75), true, System.Drawing.StringAlignment.Center), new Stimulsoft.Report.Chart.StiAxisTicks(true, 5F, false, 2F, 4, 0), Stimulsoft.Report.Chart.StiArrowStyle.None, Stimulsoft.Base.Drawing.StiPenStyle.Solid, System.Drawing.Color.FromArgb(255, 88, 86, 75), 1F, true, 0F, true, Stimulsoft.Report.Chart.StiShowXAxis.Both);
Chart1_Area.XTopAxis = new Stimulsoft.Report.Chart.StiXTopAxis(new Stimulsoft.Report.Chart.StiAxisLabels("", "", "", 0F, new System.Drawing.Font("Tahoma", 8F), true, Stimulsoft.Report.Chart.StiLabelsPlacement.OneLine, System.Drawing.Color.FromArgb(255, 88, 86, 75), 0F, Stimulsoft.Report.Chart.StiMarkerAlignment.Right), new Stimulsoft.Report.Chart.StiAxisRange(true, 0, 0), new Stimulsoft.Report.Chart.StiAxisTitle(new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Bold), "", System.Drawing.Color.FromArgb(255, 88, 86, 75), true, System.Drawing.StringAlignment.Center), new Stimulsoft.Report.Chart.StiAxisTicks(true, 5F, false, 2F, 4, 0), Stimulsoft.Report.Chart.StiArrowStyle.None, Stimulsoft.Base.Drawing.StiPenStyle.Solid, System.Drawing.Color.FromArgb(255, 88, 86, 75), 1F, false, 0F, true);
Chart1_Area.YAxis = new Stimulsoft.Report.Chart.StiYLeftAxis(new Stimulsoft.Report.Chart.StiAxisLabels("", "", "", 0F, new System.Drawing.Font("Tahoma", 8F), true, Stimulsoft.Report.Chart.StiLabelsPlacement.OneLine, System.Drawing.Color.FromArgb(255, 88, 86, 75), 0F, Stimulsoft.Report.Chart.StiMarkerAlignment.Right), new Stimulsoft.Report.Chart.StiAxisRange(true, 0, 0), new Stimulsoft.Report.Chart.StiAxisTitle(new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Bold), "", System.Drawing.Color.FromArgb(255, 88, 86, 75), true, System.Drawing.StringAlignment.Center), new Stimulsoft.Report.Chart.StiAxisTicks(true, 5F, false, 2F, 4, 0), Stimulsoft.Report.Chart.StiArrowStyle.None, Stimulsoft.Base.Drawing.StiPenStyle.Solid, System.Drawing.Color.FromArgb(255, 88, 86, 75), 1F, true, 0F, true, Stimulsoft.Report.Chart.StiShowYAxis.Both);
Chart1_Area.YRightAxis = new Stimulsoft.Report.Chart.StiYRightAxis(new Stimulsoft.Report.Chart.StiAxisLabels("", "", "", 0F, new System.Drawing.Font("Tahoma", 8F), true, Stimulsoft.Report.Chart.StiLabelsPlacement.OneLine, System.Drawing.Color.FromArgb(255, 88, 86, 75), 0F, Stimulsoft.Report.Chart.StiMarkerAlignment.Right), new Stimulsoft.Report.Chart.StiAxisRange(true, 0, 0), new Stimulsoft.Report.Chart.StiAxisTitle(new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Bold), "", System.Drawing.Color.FromArgb(255, 88, 86, 75), true, System.Drawing.StringAlignment.Center), new Stimulsoft.Report.Chart.StiAxisTicks(true, 5F, false, 2F, 4, 0), Stimulsoft.Report.Chart.StiArrowStyle.None, Stimulsoft.Base.Drawing.StiPenStyle.Solid, System.Drawing.Color.FromArgb(255, 88, 86, 75), 1F, false, 0F, true);

Stimulsoft.Report.Chart.StiLegend Chart1_Legend = new Stimulsoft.Report.Chart.StiLegend();
Chart1_Legend.BorderColor = System.Drawing.Color.FromArgb(255, 95, 72, 29);
Chart1_Legend.LabelsColor = System.Drawing.Color.FromArgb(255, 95, 72, 29);
Chart1_Legend.MarkerSize = new System.Drawing.Size(10, 10);
Chart1_Legend.TitleColor = System.Drawing.Color.FromArgb(255, 95, 72, 29);
Chart1_Legend.Brush = new Stimulsoft.Base.Drawing.StiGradientBrush(System.Drawing.Color.FromArgb(255, 255, 255, 255), System.Drawing.Color.FromArgb(255, 255, 242, 199), 90);
Chart1_Legend.Font = new System.Drawing.Font("Tahoma", 10F, FontStyle.Bold);
Chart1_Legend.TitleFont = new System.Drawing.Font("Tahoma", 14F, System.Drawing.FontStyle.Bold);
Chart1_Legend.Columns = oDt.Columns.Count; // dtChartData.Rows.Count;
Chart1_Legend.VertAlignment = Stimulsoft.Report.Chart.StiLegendVertAlignment.Top;
Chart1_Legend.HorAlignment = Stimulsoft.Report.Chart.StiLegendHorAlignment.Right;

//Stimulsoft.Report.Chart.StiTwoColumnsPieLabels Chart1_SeriesLabels = new Stimulsoft.Report.Chart.StiTwoColumnsPieLabels();
//Stimulsoft.Report.Chart.StiOutsidePieLabels Chart1_SeriesLabels = new Stimulsoft.Report.Chart.StiOutsidePieLabels();
Stimulsoft.Report.Chart.StiNoneLabels Chart1_SeriesLabels = new Stimulsoft.Report.Chart.StiNoneLabels();
Chart1_SeriesLabels.BorderColor = System.Drawing.Color.FromArgb(255, 105, 105, 105);
Chart1_SeriesLabels.LabelColor = System.Drawing.Color.FromArgb(255, 105, 105, 105);
Chart1_SeriesLabels.LegendValueType = Stimulsoft.Report.Chart.StiSeriesLabelsValueType.ArgumentValue;
Chart1_SeriesLabels.MarkerSize = new System.Drawing.Size(8, 6);
Chart1_SeriesLabels.ValueType = Stimulsoft.Report.Chart.StiSeriesLabelsValueType.Argument;
Chart1_SeriesLabels.ValueTypeSeparator = "-";
Chart1_SeriesLabels.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.White);
Chart1_SeriesLabels.Font = new System.Drawing.Font("Tahoma", 10F, FontStyle.Bold);

Chart1.Area = Chart1_Area;
Chart1.Legend = Chart1_Legend;
Chart1.Page = page;
Chart1.Parent = reportBand;
Chart1.SeriesLabels = Chart1_SeriesLabels;
Chart1_Area.Chart = Chart1;
Chart1_Legend.Chart = Chart1;

Chart1_SeriesLabels.Chart = Chart1;
Chart1.Title.Text = sReportTitle;
Chart1.Title.Visible = true;
Chart1.Title.Font = new System.Drawing.Font("Tahoma", 16F, FontStyle.Bold);
//Chart1.Series.Clear();
//Chart1.Series.AddRange(new Stimulsoft.Report.Chart.StiSeries[] {
// SeriesData});

Chart1.Series.Clear();
for (int i = 1; i < oDt.Columns.Count; i++)
{
Stimulsoft.Report.Chart.StiCenterAxisLabels SeriesData_SeriesLabels = new Stimulsoft.Report.Chart.StiCenterAxisLabels();
SeriesData_SeriesLabels.BorderColor = System.Drawing.Color.Black;
SeriesData_SeriesLabels.LabelColor = System.Drawing.Color.Black;
SeriesData_SeriesLabels.LegendValueType = Stimulsoft.Report.Chart.StiSeriesLabelsValueType.ArgumentValue;
SeriesData_SeriesLabels.MarkerSize = new System.Drawing.Size(8, 6);
SeriesData_SeriesLabels.ValueType = Stimulsoft.Report.Chart.StiSeriesLabelsValueType.ArgumentValue;
SeriesData_SeriesLabels.ValueTypeSeparator = "-";
SeriesData_SeriesLabels.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.White);
SeriesData_SeriesLabels.Font = new System.Drawing.Font("Tahoma", 10F, FontStyle.Bold);
SeriesData_SeriesLabels.Chart = Chart1;

Stimulsoft.Report.Chart.StiClusteredColumnSeries SeriesData = new Stimulsoft.Report.Chart.StiClusteredColumnSeries();
SeriesData.ArgumentDataColumn = oDt.TableName + ".argumentdata";
SeriesData.Title = new StiTitleExpression(oDt.Columns.Caption);
SeriesData.SortBy = Stimulsoft.Report.Chart.StiSeriesSortType.Argument;
SeriesData.BorderColor = System.Drawing.Color.FromArgb(255, 155, 155, 155);
SeriesData.ValueDataColumn = oDt.TableName + ".valuedata_" + i.ToString();
SeriesData.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.White);

SeriesData.Chart = Chart1;
SeriesData.SeriesLabels = SeriesData_SeriesLabels;

Chart1.Series.Add(SeriesData);
}

reportBand.Components.Add(Chart1);[/left]

Hello.

Which version of Stimulsoft Reports.Net do you use?

Thank you.

runtime version: v2.0.50727
version: 2010.1.700.0

sorry about the delay response

Hello.

frisco434 wrote:runtime version: v2.0.50727
version: 2010.1.700.0

sorry about the delay response

Please, send us your project with data to reproduce your issue.

Also try to check our latest prerelease build. We made some improvements.

Thank you