Community
Showing results for 
Search instead for 
Do you mean 
Reply

Page Report by Multi-Select Item

New Member
Posts: 1
Country: USA

Page Report by Multi-Select Item

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.

 

Mark

Bronze Super Contributor
Posts: 1,170
Country: USA

Re: Page Report by Multi-Select Item

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...

 

Other thoughts?