Here are a couple of details about what happens when you use the option to Export to Word for an IQA query:
- Just like with the Word Integration system, aka Letters system, the export format iMIS uses is that the data is in a Word table. You know what the maximum number of columns is in a Word table? Answer: 63 columns. Yep, I ran into that limit.
- Unlike in the Letters system, when you export from IQA, the export process strips out the carriage returns of fields such as CsContact.FullAddress. It strips it out of calculated fields too. This really bites because then if you've bothered to create Address Formats for your international addresses, you can't get them out in the Word format. ASI tells me having it behave consistently with the Word Integration method would be a Request for Enhancement. Argh!
The export to Excel (.xls) behaves the same way--stripping out the carriage returns--but luckily ASI is not consistent and the export to .csv does not strip out the carriage returns. Hooray!
So exporting into .csv solves both the number of column limitations and the stripping of the carriage returns.
A foolish consistency is the hobgoblin of little minds, adored by
little statesmen and philosophers and divines. --Ralph Waldo Emerson
Comments