March 21, 2017 at 8:23 am
I am working on a report and am running into the following issue:
When first running the report, I select the teams I want to see. This creates a bar chart showing the selected teams' performance. So far so good. What I want to happen is when I click on a certain team's bars, a second chart should open up, showing the team members' performance.
I created the report using this link.
What is happening is when I click on the first chart, the team members chart is not visible. While troubleshooting, I made the second chart visible all the time and its parameter visible. If I enter a team name into the second chart's parameter on the initial run, it works correctly. However, if I click on a bar in the first chart, the report drills through and the first chart renders correctly, but the second chart is not visible. The second chart's parameter seems to be populating correctly though.
Although the drill through functions on the first run, after I drill through by clicking the first chart's bar, the drill through functionality stops working. After the drill through, the first chart still shows correctly, but the second chart is not visible and the report will not drill through again if I try clicking on the first chart's bars.
I am using SSRS 2008r2 and IE 11. I am building the report using Report Builder found on the report server's web page.
What am I doing wrong?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply