TBSupport
asked on
SSRS: Lookups Needed....Or, what is the remedy to eliminate the duplication?
Hello:
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!
TBSupport
POOR.docx
POOR.rdl
POOR-Subreport.rdl
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!
TBSupport
POOR.docx
POOR.rdl
POOR-Subreport.rdl
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ValentinoV
I noticed your main report has got two Row Groups: VendorID and VendorID1, both grouping on VendorID. I don't think this is the cause of your issue but in any case you should be able to remove one of them and still have a working matrix. (Select the "Delete group only" radio button when deleting the row group.)
ASKER
Thanks, PortletPaul! I'll try some of these things and let you know. I apologize, for not mentioning it earlier. But, on the main report, I'm only using the POOR_MATRIX datasets. I kept the other previously created ones "there", in case I need them. Thanks, for looking those over.
ValentinoV: I need that grouping, though. You have to have a group, in order to allow for drill-downs. That's why I have a subreport, in that matrix. :)
TBSupport
ValentinoV: I need that grouping, though. You have to have a group, in order to allow for drill-downs. That's why I have a subreport, in that matrix. :)
TBSupport
Ah, you're using drilldown, hadn't noticed it when I posted my comment. In that case you're right!
Thanks for the grading. Trust it's all working as needed now. Cheers, Paul.