We have recently updated the above-mentioned Service Pack to our Job Cost module. It seems that after the update, the Job Status reports (under Analysis Reports) that we "print" to Excel contained a bunch of extra columns in between our actual data. The report that I used to generate to Excel contained data in Columns A to L, which is correct as the data only spans from Columns A to L. However, our reports are now spanning from Columns A to AW. A lot of blank columns have been added it and cells are also merged, making it difficult for us to extract the data we need from the right columns and cells.

Did something in the update cause this? Any suggestions?

Hello Michael:

All of the Adagio 9.2 versions now use the latest version of Crystal Reports (the version used in previous versions was close to 15 years old). One of the great things about this new version is that, when you export to Excel, the resulting worksheet looks almost identical to the original report. But the bad thing is that Crystal achieves that by inserting columns which can make working with the file more difficult.

Do you own GridView? That will create a well formatted Excel file.

Thank you Bruce for the explanation! No, we don't own GridView. We will just use some workarounds for the time being.

Hello Michael,

Try one of the data only formats to or CSV to see if that gets you the data you need.

Also, what are you doing with the exported information? And have you reviewed the Export templates to see if they will export the information you need?

Hi Andrew,

We are now using the CSV format and with some tweaking, we are getting the data we need. It was just so much more convenient before to export directly to Excel (all formatted). :-)

We are using the exported information to build our monthly Progress Draw reports.

As to your question about reviewing Export templates, yes, we have tried them and CSV seems to be the better format for what we need.