Hi,
I'm trying to hold data using ACROSS COUNTRY and uisng COLUMNS command to sort but when I print the hold data I'm getting extra character appended. Below is my code

 TABLE FILE CAR
SUM
SALES
BY CAR AS ''
ACROSS COUNTRY AS '' COLUMNS 'ITALY' AND 'ENGLAND' AND 'FRANCE' AND 'W GERMANY' AND 'JAPAN'
ON TABLE HOLD AS H_TEMP1 FORMAT FOCUS
END

TABLE FILE H_TEMP1
PRINT
*
END

Result come with SAL appended to country:

SALITALY SALENGLAND SALFRANCE SALW GERMANY SALJAPAN

How do I avoid SAL infront of country.

This message has been edited. Last edited by: WF World,

WF World,

This is the expected default results for holding report data when using an ACROSS.

Use the ASNAMES syntax

ON TABLE SET ASNAMES ON

OR

SET ASNAMES = {ON|OFF|MIXED|FOCUS|FLIP}

ON
Uppercases the literal specified in an AS phrase and propagates it as the field name in the HOLD Master File. Creates names for ACROSS fields that consist of the AS name value concatenated to the beginning of the ACROSS field value and controls the way ACROSS fields are named in HOLD files of any format.


Happy Holidays.

Thank your for participating in the Focal Point Forum,
Tamra Colangelo
Focal Point Moderator
Information Builders

quote:

concatenated to the beginning of the ACROSS field value and controls the way ACROSS fields are named

Hi Tamra,
Thanks for your response on this request.
I've already tried using SET ASNAMES=ON before but it didn't work for me.

 
SET ASNAMES=ON

TABLE FILE CAR
SUM
SALES
BY CAR AS ''
ACROSS COUNTRY AS '' COLUMNS 'ITALY' AND 'ENGLAND' AND 'FRANCE' AND 'W GERMANY' AND 'JAPAN'
ON TABLE HOLD AS H_TEMP1 FORMAT FOCUS
END

TABLE FILE H_TEMP1
PRINT
*
END

quote:

I've already tried using SET ASNAMES=ON before but it didn't work for me.

You need to read what Tamra wrote in full as she is saying that this is expected behaviour (as well as being documented - she included the quote from the documentation).

T

quote:

SALITALY SALENGLAND SALFRANCE SALW GERMANY SALJAPAN

it worked...

Thanks Tamra for your help

  
SET ASNAMES=ON

TABLE FILE CAR
SUM
SALES AS ''
BY CAR AS ''
ACROSS COUNTRY AS '' COLUMNS 'ITALY' AND 'ENGLAND' AND 'FRANCE' AND 'W GERMANY' AND 'JAPAN'
ON TABLE HOLD AS H_TEMP1
END

TABLE FILE H_TEMP1
PRINT
*
ON TABLE PCHOLD FORMAT PDF
END

May be an easier way but here is a fast way

TABLE FILE H_TEMP1
PRINT
E01
E02 AS 'ITALY'
E03 AS 'ENDGLAND'
E04 AS 'FRANCE'
E05 AS 'W GERMANY'
E06 AS 'JAPAN'
END

Hi Hinds,
Thanks for the reply.
My across value changes dinamically. I'll read it in a variable and then provide it as below

ACROSS COUNTRY AS '' COLUMNS &COLVAL11

Now its working fine.

I really appriciate your help on this. Thanks

Hi WF World,

If your question has been answered, please add [SOLVED] or [CLOSED] to the title of your first post.