Can I Create a Graph Legend without the Graph?

[jenschmidt]

Happy Friday!

I currently have a very simple graph on my report which shows a legend. The graph is showing once for each group header 1 (there are only 2 groups in the report). It is displaying on change of CITY and is showing a value of the distinctcount of a formula {@INT_PAT_ID (MD)}. Formula is as follows:

if isnull({TABLE.INT_PAT_ID})
then "0"
else
if {TABLE.PRODUCTION_CAT}<>"MD"
then "0"
else
{TABLE.INT_PAT_ID}

I'm doing a topN (N=10) sort by DistinctCount of the formula and including others and ties. The legend displays the top cities with a percentage. For example:

Sun Prairie 54.3%
Madison 8.0%
Marshall 6.3%
DeForest 3.9%
Columbus 3.4%
Cottage Grove 3.0%
Rio 2.9%
De Forest 2.1%
Poynette 1.4%
Waterloo 1.2%
Others 13.1%

Total: 100.0%

I have figured out how to show the cities - by inserting a summary at the GH1 level which is "Nth most frequent" and set N as 1, then a second summary where N is 2 etc. The issue with this is, depending on how the report is run (what time period, what doctor, etc) the number of summaries I would need would be different to accommodate things like ties etc. I also haven't figured out how to do the percentage.

Any ideas or suggestions?
Thanks!

jennifer.giemza@uwmf.wisc.edu