R&D:

Is this by design or it is a glitch that we cannot export to Excel the Detail Listing using Home and Source option?

Hi Patricia,

This was intentionally done. From what I found, the ExcelDirect process does not have the sub-report resources available to calculate the Opening Balances in home and source currencies across the various possible currencies that could have been posted to the account. And perhaps other totals or sub-totals as well. The Crystal Report process has a different way to get this with sub-reports, which is why the printed report works.

I was told there is no intention to try and change the ExcelDirect process to make this available, based on the complexity of the situation. If you want a list of details in Excel, it looks like you'll need GridView or some other process.

Thank you for the explanation. Have a great weekend!