Hello,

I am getting a strange thing happening when I export a custom Inquiry from Adagio to Excel. First, when I setup my inquiry and click on print then print preview, I get what I want. Big Screenshot here: http://i.imgur.com/PlI1vzL.png



So for the most part that preview is what I want to be exported to Excel. However, when I go to print this to a file (or export to Excel however you would like to call it), it puts multiple pieces of data into the same cell, making any kind of sorting or organizing impossible. Big Screenshot here: http://i.imgur.com/oXAb9Kn.png



You will notice how data such as the headers in rows 12, 13, and 14 are all in ONE CELL. Another example of this would be for example the highlighted cell B-16. That cell contains two separate pieces of data, the item number and the item description. Not only do they share the cell; they are also not aligned with each other meaning as you scroll down column B the item descriptions are spaced differently due to item numbers having varying lengths.

You will also notice that the Excel version doesn't have any MTD data the print preview had! It doesn't have any of those columns at all. You notice how the labels exist for each month but none of the actual data for those months exists in the spreadsheet anywhere.

And finally at the very bottom of the print preview which I didn't include in the screenshot because I didn't want there to be too many screencaps, there is a sum of all the months and how much money that customer spent with us that month, but that doesn't exist in the Excel export either.

So my question is, how do I get the data I got in the print preview into Excel. Should I even be using Sales Analysis? Is this something that should be done in GridView? Could anyone help me out with this or should I just contact our Adagio expert? Any help would be greatly appreciated.

Thanks