Creating a Multivalue Field while grouping
I am creating a report where the data i am querying contains account's
which could have many categories..
Through a convoluted method of LEFT OUTER joins and UNIONS i was able to
bring all the categories on to the one account row
This took about 6 hours to complete..
It would be nice to create a query/report that just groups by account and
any categories are just rolled up into the one column. This could be just
a text string if need be.
What are some ways of achieveing the result?
Thanks Craig
No comments:
Post a Comment