Focal Point
[SOLVED] ACROSS COLUMNS when column names have ampersands and spaces

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

August 15, 2011, 04:22 PM
jammer
[SOLVED] ACROSS COLUMNS when column names have ampersands and spaces
I know you can force columns to display with an ACROSS statement like this:

ACROSS BUSINESS COLUMNS 1 AND 2 AND 3 AND 4 AND 5

If my Acrross column values are as follows:

A&H Excess
A&H Pro Rata
Casualty Excess
Casualty Pro Rata
Esurance

How do I write the across taking into account that my column names have ampersands and spaces

It tried:
ACROSS BUSINESS COLUMNS A&|H Excess AND A|&H Pro Rata AND Casualty Excess AND Casualty Pro Rata AND Esurance

but it get errors

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


Webfocus 7.6.4
Windows 2003 Server, SQL Server 2005
Excel, HTML , JavaScript ,and PDF.
Reportcaster, BID, Tomcat
August 15, 2011, 06:02 PM
Dan Satchell
Try putting single quotes around your column names.


WebFOCUS 7.7.05
August 15, 2011, 09:34 PM
jammer
Thanks the SINGLE quotes worked. This was final way to format the across

ACROSS BUSINESS AS '' COLUMNS 'A&|H Excess' AND 'A&|H Pro Rata' AND 'Casualty Excess' AND 'Casualty Pro Rata' AND 'Esurance'


Webfocus 7.6.4
Windows 2003 Server, SQL Server 2005
Excel, HTML , JavaScript ,and PDF.
Reportcaster, BID, Tomcat