question

JasonShaw-1760 avatar image
0 Votes"
JasonShaw-1760 asked ·

SSRS Category data problem

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-supported
noselect.jpg (68.0 KiB)
abselect.jpg (70.7 KiB)
jsselect.jpg (72.5 KiB)
chselect.jpg (72.5 KiB)
dummydata.jpg (69.8 KiB)
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LeonLaude avatar image
0 Votes"
LeonLaude answered ·

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


· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JasonShaw-1760 avatar image
0 Votes"
JasonShaw-1760 answered ·

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

· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.