ARCHIVED: How do I create a data bar chart in SSRS?

This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.

To create a data bar chart in your SSRS folder:

From the SSRS folder, click Report Library.
In the ribbon, click Documents. From the New Document drop-down menu, select Report Builder Report. Keep New Report highlighted, and select Blank Report.
Select the Insert tab, and click the Data Bar icon. The cursor will turn into a small data bar icon with a plus sign.
Click inside the report frame and drag the cursor along the frame; this will create a rectangle that is blue inside.
Select the type of chart you want, and click OK.
Enter a descriptive name for the dataset, and select the Use a dataset embedded in my report radio button.
For the data source, click New.
With General highlighted on the left-hand side, enter a descriptive name for the data source.
If not already selected, select the Use a connection embedded in my report radio button.
From the "Select connection type:" drop-down menu, choose Microsoft SQL Server Analysis Services.
Click Build to construct the connection string.
Enter the server name for the server where the data source is located.
From the "Connect to a database:" drop-down list, select the database. Click OK.
Highlight Credentials on the left-hand side, and make sure that Use current Windows user is selected.
Click OK to save the data source connection. This will return you to the dataset properties.
Click Query Designer....
Click the ellipsis (...) button in the left-hand corner and select the cube. Click OK.
Drag and drop the measures and dimensions you want onto the empty frame. After you have completed the dataset, click OK.
Click OK to save the dataset.
Click the data bar (blue rectangle). A "Chart Data" window will appear.
In the Report Data pane on the left, open the dataset that was created above, and drag and drop the fields onto the parts of the "Chart Data" window. Measures go into the [Sigma] Values pane; dimensions go into the Category groups and Series groups.
Right-click the chart and choose Show Data Labels; right-click the chart and choose Convert to Full Chart.
Right-click the X axis title and choose Axis Title Properties. Enter an appropriate axis title, and then click OK. Repeat this for the Y axis.
Right-click the legend and choose Show Legend Title. Right-click the legend title box, choose Legend Title Properties, and change the title as appropriate. You can also change the alignment, if desired. Click OK.
Right-click the chart title and choose Title Properties. Enter an appropriate title, and then click OK.
Click in the text box above the chart to add a report title. You can also position the table differently inside the report frame, if desired.
To test the chart, in the ribbon, click Run. To return to the report layout, click Design.
To save the chart, click the floppy disk icon in the left-hand corner of the screen and open the Report Library directory. Enter a name for the table/matrix and click Save.