0

I am using SSRS 2008 R2 and have the following map.

Map in SSRS

In my opinion, it looks very ugly with all of the zip codes showing for each area so what I would like to do is only show the zip code when the area has more than 10% of the total number of people in it. I was reading here (Troubleshooting Reports) so I don't know if this is possible. A coworker was telling me that for Charts/Graphs in SSRS there is a #PERCENT that would allow me to do something like:

 Visibility Expression: =#PERCENT > 10

but I couldn't get it to work. Any help would be appreciated!

K. Fenster
  • 91
  • 3
  • 15

1 Answers1

1

I actually did something extremely similar once. I ended up just setting the label expression using a couple of aggregate functions:

=IIF(SUM(Fields!Quantity.Value)/SUM(Fields!Quantity.Value, "DataSet1")>0.10,Fields!ZIP.Value,"")

Worked fairly well.

jonrsharpe
  • 115,751
  • 26
  • 228
  • 437
bitnine
  • 1,752
  • 1
  • 17
  • 20
  • So I think this may work for me.. I think I might have to change what my query is pulling, but thanks for the ideas! – K. Fenster Aug 15 '16 at 21:26