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.
Step 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!
I hope this tip helps you find the report item on your SSRS reports.
SSRS chart didn’t show all axis labels. Here’s an example.
Note: it does NOT show all country names:
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
3. Preview your report to see if you see ALL axis labels now:
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.