Attached is the screenshot of my matrix SSRS report. There is duplication of vendor IDs. The reason that this is happening is because I had to use a UNION ALL statement for my main report. Some of the vendors come from one "area" of the UNION ALL statement, while the others come from other "areas" of the statement.
Conversely, although my subreport has a UNION ALL statement, it is only pulling from one "area".
OK. The long and the short of it is that, when I say "area", I mean "database". It's a long story.
In any case, someone once mentioned to me the possibility of using something in SSRS called "lookups" or "lookup values" or something.
In any case, I need to get rid of these duplicate vendors. Otherwise, I guess I'll just have to tell the client that we can only pull from one, umm, "area". :)
Thanks! Much appreciated!