Bar graphs are another type of report that can be created using dotnet Report Builder. To create a bar graph, click on the “Bar” button in the “Choose Report Type” section. The next step is to select the fields that will be in the report.
The fields that will populate the report can be found in the “Choose Data for Report” section. Click on the “Choose Section…” drop down to reveal the list of available tables in your database.
Depending on how your database is set up, different information will be stored in different tables. Users can choose fields from more than one section to populate their report. As with the other report types, the fields selected for the report will be summarized in the “Selected data for the Report” section as shown below. For bar graphs, the first field in the list of selected fields will be chosen for the x-axis of the report and all the other fields will be displayed on the y-axis. The y-axis fields need to be numeric to be displayed.
Running a Bar Graph Report
After clicking “Save & Run Report”, the bar graph will be displayed as shown below. The main information is displayed on the bar graph and a summary is displayed below it with the same drill down functionality available in the Summary Report.