I have an AHTML report with the code produced below. When we export this report to Excel, the ACROSS headings do not export. Is this how it is suppose to be? How can I get them to export in Excel?

TABLE FILE QSPOFSUM
SUM
COUNT1/I11C
BY WCCSTS AS 'Cost, Center'
BY QRSROM AS 'Whse'
BY CTSDES AS 'Warehouse, Name'
ACROSS QRZ3QSPF AS 'POF Codes'


Also, is there an option in Active reports (or maybe another format), where we can filter on the across columns like we could in Excel Pivot tables.

Thanks.

This message has been edited. Last edited by: Kerry,

quote:

When we export this report to Excel, the ACROSS headings do not export.

Sadly that's still the case in 7.7.03.

It sort of defies the purpose of having the ability of filtering and manipulating the results in the active window, but losing relevant information when they get exported to Excel.

TABLE FILE CAR
SUM DEALER_COST
    SALES
BY COUNTRY
ACROSS CAR
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT AHTML
END

When exported to Excel, values such as "ALPHA ROMEO", "AUDI", "BMW", etc. get removed from the results. Instead, the output now shows DEALER_COST, DEALER_COST [2], DEALER_COST [3], etc. which is rather meaningless to whoever will receive the results for analysis.

I would open a case with IBI.

Agreed. I think I read somehwere that it was fixed in one of the later version. Thanks for confirming it wasn't. I opened up a case about this with IBI and they have added this as a new feature request.