I have created charts inside a report using SQLDataSource to bind the data. I would like my bar graph to show negative entries in red and positive entries in green.
I have tried setting the "ConditionalFormatting" property as in link below but that doesn't do anything.
Also I found this thread, but my data is generated by datasource. How can I retrieve the ChartSeriesItem from the reportviewer?
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not IsPostBack Then
Dim report As New MyReports.NetIncomeByOffice
ReportViewer1.Report = report