Focal Point
Active Reports not displaying Across column Titles

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7161068191

October 19, 2006, 04:37 PM
Nick
Active Reports not displaying Across column Titles
I have a pretty simple fex that has this DEFINE:

Period/A12=DECODE TIME_PERIOD_SORT( 0 Error 1 Late 2 'This Week' 3 'Two Weeks' 4 'Three Weeks' 5 'Four Weeks' 6 'Five Weeks' 7 Future );

I then use this DEFINE as the Across column in my fex (Sum dollars due during that period). When I output into anything other than AHTML (Excel or HTML) I see the column title correctly, when I change the output to AHTML the ACROSS column headings are gone and all I see are the 'dropdowns' for filtering and sorting.

I have read the 'Considerations for Active Reports' technical memo and it stated "Change ACROSS fields to BY fields in the current version of AHTML." So does AHTML not support ACROSS Columns? How come it will display the data correctly but not display the column title? Anyone seen or resolved this problem?


Dev- WF 7.68 on Windows Server 2003: DB2, SQL Server 2K, SQL Server 2005, SQL Server Anaysis Services 2005.
Test- WF 7.67 on Windows Server 2003: DB2, SQL Server 2K, SQL Server 2005, SQL Server Anaysis Services 2005.
Prod - Dev- WF 7.65 on Windows Server 2003: DB2, SQL Server 2K, SQL Server 2005, SQL Server Anaysis Services 2005
October 20, 2006, 11:38 AM
jmdoyl1
Nick,

Support for Across is available in the 7.1.5 server if you can upgrade if you haven't already.

Jon


WebFOCUS 7.1.3 Windows Client AIX 5.2 Report Servers
October 26, 2006, 05:07 PM
Nick
Thanks for the info, I will look into version 7.1.5.


Dev- WF 7.68 on Windows Server 2003: DB2, SQL Server 2K, SQL Server 2005, SQL Server Anaysis Services 2005.
Test- WF 7.67 on Windows Server 2003: DB2, SQL Server 2K, SQL Server 2005, SQL Server Anaysis Services 2005.
Prod - Dev- WF 7.65 on Windows Server 2003: DB2, SQL Server 2K, SQL Server 2005, SQL Server Anaysis Services 2005