3

In SSRS 2016 Mobile reports are a new option for Native mode report server. I have created several now and there appear to be consistencies between colors on different charts and graphs if the same columns are used in the setup of each element. However, I cannot find any way to consistently keep colors across slicer changes. Is there a work around, a setting a missed, a code behind, some way to ensure that when I change a parameter my chart legends do not suddenly swap colors?

enter image description here

This is with an "All" level setting on the parameters.

enter image description here

This is the new colors scheme after a parameter has been selected and the report updates with the new quantities. Totally unacceptable - this renders the report nearly worthless.

This behavior happens across reports and data sets for me. I would have tried to set an ordering as it appears to change based on quantity changes in each category, but there are no ordering settings for pie charts.

  • Interesting question, I have looked through it and could not find any option unfortunately. I have a feeling some features are simply missing for the mobile reports in order to get it released as soon as possible... – Magier Jul 29 '16 at 7:49
1

There is currently nothing in the Mobile Report editor itself that indicates a capacity to order parameters and most graphs have no ordering capabilities (a couple of the bar charts allow for value or label based chart arrangement - part of the reason I was thrown off here!).

However, one can accomplish sorting from the data sets used in the report. The use of a single data set may cause issues in the parameters... so a standard ORDER BY x, x... approach will only go so far. Using the same values and a different data set, one can accomplish sorting and maintain filtering abilities.

To illustrate, the following query in Mobile Reports gives an oddly sorted State list, since it is actually sorted, in expected SQL fashion, after warehouse and business center lists.

SELECT
     WarehouseID
    ,PostalCode
    ,City
    ,County
    ,State
    ,BusinessCenter
FROM ...
ORDER BY WarehouseID, BusinessCenter, State

The ordering above solves some parameter list sorting and fixes legend color displays in the report, but doesn't address the State parameter sorting. Another data set with the exact same values contained in State can be used for the parameter, which enables correctly sorted and still functional parameter lists.

SELECT DISTINCT
State
FROM DIM.Geography
ORDER BY State

This resolves consistency of legend location and coloring across the dashboard and solves parameter selection list sorting.

0

I changed the Data points sorting property to alphabetic descending to ensure the same colors when data changes

  • Maybe you could expand on this answer a bit? Maybe compare results you obtained with and without this setting change? Just as link only answers are discouraged here, answers with less than 20 words are a wee bit terse. – Vérace Jul 30 '16 at 3:38
  • This works for some chart and graph types but not others. Pie charts have no sort or ordering options. – Dave Aug 3 '16 at 23:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.