We are using Dundas Maps together with Reporting Services 2008. Now we have come across a problem which we are not able to solve ourselves.
We produce a map showing each countries “ReportingFormat”. The SQL in the background has the “order by ReportFormat” clause.
The values available in “ReportFormat” are shown in the legend. So far everything looks fine and the values within the legend are ordered correctly (E2B, Intdis, Not specified). See the picture
We therefore deploy the report and open it up in Internet Explorer but now the order of the legend has changed and is shown as (Intdis, Not specified, E2B). See the picture
We have tried to set the sorting also within the map (not only within the SQL) but the same problem remained although we are not sure we set that sorting correctly . We are not sure that we found
the series collection where we could set the sort order. It is all a bit confusing when working with the maps.
As a final solution we tried to change the available values in “ReportFormat” but then the order was even more confusing. See table below;
Available values (ReportFormat)
Order in legend in Visual studio preview
Order in legend in Internet
View Complete Post