Can anyone tell me how I can export all of my committee list to excel format? or how to create committee search option in ad-hoc so that I can do export company with committee ad-hoc search option. I need to have excel format so I can create mail merge with the list.
Thanks,
How to export Committee to excel format
Your best solution for this and more is IQA
On November 28th, 2008 Kevin Blouin says:
Your best solution for this would be building an IQA (Intelligent Query Architect) query. IQA is available by enabling iMIS.NET on any iMIS version 10.3 or higher. iMIS15 comes already .NET enabled. Version 10.6 and higher has IQA integrated directly into the Customers, Events, and Orders modules.
10.6 with iMIS.NET enabled is also the pre-requisite version needed before upgrading a 10.x version database to iMIS15. Even if you plan on holding off on migrating to iMIS15, your best option would be to enable .NET now and begin working with the new IQA feature. It has a direct export to Excel feature and none of the limitations that the Omnis-based Ad Hoc query tool has. You can combine information and selection filters from different modules (like Committees and Customers) to get any results you want.
-K
Kevin Blouin - enSYNC Corp.
Committees to Excel
Hi
I had the same problem, to resolve it, create a Crystal Report, from where you export it to Excel
Just make sure, there was an issue with one of the fields that displays wrong.
Email me (jacov@saica.co.za) and I will send you the Crystal report