SQL Server Reporting Services: How to Add Tool Tips to charts?

Standard

Problem:

Consider a chart like the one shown below (Sales Amount VS. State region).  When a user moves their mouse over one the bars then you want them to show them the value (sales amount) of that bar as well as show them the category grouping values (State region)

SSRS Tool Tip

(The Visualization is just for demo purpose. It’s not presentation-ready)

Solution:

Here are the step by step instructions to set up Tool Tip based on the requirements:

1. You’ll have to open the series group properties to add the Tool Tip. There are a couple of ways to open the series property

1A Select the Chart. Right Click on any of the bar and select Series Properties

1B Select the Chart. Click on any of the bar. You should see chart data pane. you can click on down arrow button on the series to open series property:

SSRS Reporting SQL Series Properties

2. Once you’ve opened the Series Property, here’s what you’ll do.

Make sure you’re on Series Data tab. You can either select one the fields or write an expression.

To meet our requirement of showing State & Sales Amount, I am going to write an expression.

From Tool Tip. Click on Fx

3. I wrote an expression that meets the requirements I stated earlier.

Expression SSRS state and salesClick OK. Click OK on series property too. And return to design view

4. Preview the report. Move your mouse pointer over one of the bar chart, you should see a Tool Tip:

REPORTING TOOL TIP CHART

This makes the charts a little more easier to read. I hope this helped!

Advertisements

Thank this author by sharing the article on social media. If you have any questions or comments, please leave a reply below:

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s