SSRS: How do I know where a report item is on the report?

Standard

Have you ever got a SSRS message saying something like textbox107 refers to an invalid measure or measure used in gaugepanel7 is not valid, etc? The problem is how do you find that “Textbox107” report item on your SSRS report? After all, you might have lots of text boxes on your report.

Here’s how you can know where a report item is on the report:

Step 1: Go to view > Properties Window

Step 2: Open the report.

Step 3: if you select a report item then it’s going to show the properties of the report item in the properties pane.

SSRS Properties Window Report ItemStep 4: And you can select a report item by it’s name like textbox107 or gaugepanel11 for which you are seeing an error, that way you can find the location of the report item and troubleshoot it!

SSRS Properties Window Report Item list

 Conclusion:

I hope this tip helps you find the report item on your SSRS reports.

Advertisements

SQL Server Reporting Services: Why am I not seeing every axis label in a chart?

Standard

Problem:

SSRS chart didn’t show all axis labels. Here’s an example.

Note: it does NOT show all country names:

axis labels sql server reporting services

Solution:

So what do you do if you want to show all axis labels in the report and do not want to skip the axis labels? Here are the steps:

1. Go to the Chart Axis properties

2. Under Label, change the value of Label Interval from Auto to 1

ssrs chart aix label properties

3. Preview your report to see if you see ALL axis labels now:

axis label ssrs issue solved

Conclusion:

The above chart is NOT perfect. There are other things that can be done but the goal of the blog post has been achieved! We have changed the axis label property so that all axis labels now show up on charts.