SSRS Category data problem

Jason Shaw 21 Reputation points
2020-04-09T13:16:56.75+00:00

I am currently working on a dashboard report for engineers performance and seemed to have found some rather strange behaviour that I can not seem to fathom out. The report consists of a number of similar charts showing several different KPIs that the business relies on. I tried to highlight a selected category selected by the user but some charts work and some others fail. After searching around the data trying different things I found what the problem is but unsure what needs to be done to stop the problem.

Basic Report with no highlights works correctly, data sorted ok.
7236-noselect.jpg

Labels on first columns correct with data expected.

Selecting a person to highlight depending on values for AB

7265-abselect.jpg

Both charts have the correctly highlighted category and labels on axis are correct.

Selecting first category on the top chart (which is the one that works correctly).

7282-jsselect.jpg

Again both charts have a correctly highlighted category.

Choosing to highlight the first category in the bottom chart the following happens.

7155-chselect.jpg

The category label for the first column is incorrect it instead duplicates one off the other categories, but the data value is correct. This is only happening on the first column of some charts. By adding in a dummy row of data so that the data for CH is in column 2, the highlighting works see below.

7266-dummydata.jpg

Any ideas on what I need to do to sort the problem out. Adding the extra data is possible but looks untidy, I can blank out labels etc, but adding filter to chart creates the same problem.

Thank you

Jason

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,806 questions
0 comments
Accepted answer
  1. Leon Laude 85,646 Reputation points
    2020-04-09T13:18:07.3+00:00

    Hi,

    Q&A currently supports the products listed in right-hand pane (more to be added later on)

    You can reach the experts in the dedicated SQL Server Reporting Services forums over here:
    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlreportingservices

    (please don't forget to mark helpful replies as answer)

    Best regards,
    Leon

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jason Shaw 21 Reputation points
    2020-04-09T13:21:46.837+00:00

    Hi Leon

    Sorry about that. I tried there but could not get it to submit, tried to get account verified but not working yet but said this was a new link.
    I will wait for account to be verified and try again.

    Stay Safe
    Jason

    0 comments