09-27-2010 07:40 PM
I have a database where there is a field that is a Multi-select field for Territory covered by the company. I'd like to create a report that will be sorted and split out by the territory that a company covers. For example, a section (page) for Territory 1, another for Territory 2, and so on. So, if a company covers multiple territories, I want it to show up on multiple pages on the report. Is there any way to do this? I am using Act! 2010.
Thank you for any help you can provide.
09-29-2010 12:01 PM
If that is possible with Act! reports, you will likely need some scripting if you want to have it all in one pass. Otherwise, you could run it per territory. If there are more than a handfull of territories, that's not so good.
You could probably put together something with SQL in the SQL Dashoboard component in 2010.
Or, use the OLEDB reporting connection and use Crystal...