I have a small issue while using ACROSS
Let me Illustrate that with an eg:
Please see the following code

TABLE FILE CAR
SUM
CNT.SEATS AS 'StatusCnt'
BY MODEL AS 'Business'
BY CAR AS 'Company'
ACROSS COUNTRY AS ''
ON TABLE SET PAGE-NUM OFF
ON TABLE SET PAGE NOLEAD
END

And this code produces an o/p something like this

ENGLAND FRANCE ITALY JAPAN W GERMANY
Business Company
100 LS 2 DOOR AUTO AUDI 0 0 0 0 1
2000 4 DOOR BERLINA ALFA ROMEO 0 0 1 0 0
2000 GT VELOCE ALFA ROMEO 0 0 1 0 0

But I want that extra space which is in between the line1 and line2 of the o/p to be removed, i mean the o/p shld look something like this :


Business Company ENGLAND FRANCE ITALY JAPAN W GERMANY
100 LS 2 DOOR AUTO AUDI 0 0 0 0 1
2000 4 DOOR BERLINA ALFA ROMEO 0 0 1 0 0
2000 GT VELOCE ALFA ROMEO 0 0 1 0 0

All the column names should be in the same line and i want to know how this can be done, i know this problem is because of using ACROSS.

Please suggest me a way to resolve this problem. Thanks

Try this:

SET ASNAMES=ON
-RUN
TABLE FILE CAR
SUM
CNT.SEATS AS 'StatusCnt'
BY MODEL AS 'Business'
BY CAR AS 'Company'
ACROSS COUNTRY AS ''
ON TABLE SET PAGE-NUM OFF
ON TABLE SET PAGE NOLEAD
ON TABLE HOLD AS MYFILE FORMAT ALPHA
END
-RUN
TABLE FILE MYFILE
PRINT *
END  

Thanks a ton tewy that worked...
And could you please lemme knw why you used
1) RUN before both the table requests, does this have anything to do with the performance??
2) FORMAT ALPHA, how does that influence the format of the o/p??

saggy,

Don't look a gift horse in the mouth!

You can look up the use of FORMAT ALPHA - and all the other formats - in manuals.

You can also find out why -RUN is used, and that is, to execute the current contents of the parsed stack.

T

1) In this particular instance, you don't need the -RUN. It is normally used to execute the focstack prior to running another Dialogue Manager command that would need the results of the previous FOCUS command.

2) In this particular instance, the format is irrelevant and the output will be the same. However, those of us who create a lot of hold files with WebFOCUS find that FORMAT ALPHA tends to be more flexible than the default format BINARY.

Just to answer;

1) Habit! I find when reading the code -RUN statements break it up to make it easier to read (personal preferance). Plus in older versions of WebFOCUS when I used to (on occasion) watch the output of SET ECHO=ALL in the command window whilst waiting for a result, -RUN made it put the number of lines of output etc under each table request, without the -RUN you just got all your code, followed by all the results. Made error trapping easier.

2) Using SET ASNAMES=ON and FORMAT ALPHA changes the fieldname of your STATUSCNT to STATUSCNT and the relevant country.

Hi tewy please examine the following code

I had problems retaining the column totals in the alpha hold file.
To over come this i calculated the totals just before printing the contents but the totals came up in two lines
sm thing like this

Total
138,134 4 1 4 2 7

so could you please help me out on this..and i want the final o/p to be out in excel , so do we have any approaches on getting the totals in excel??Please suggest. TIA

SET ASNAMES=ON
-RUN
TABLE FILE CAR
SUM
CNT.SEATS AS ''
BY DEALER_COST AS 'Business'
BY CAR AS 'Company'
ACROSS COUNTRY AS ''
ON TABLE SET PAGE-NUM OFF
ON TABLE SET PAGE NOLEAD
ON TABLE HOLD AS MYFILE FORMAT ALPHA
END
-RUN
TABLE FILE MYFILE
PRINT *
ON TABLE COLUMN-TOTAL AS 'Total'
END

Your problem is because the first column in your print is a numeric column for which WebFOCUS will provide a total, if the column were alpha you'd be able to have the word TOTAL and the total values on the same line.

Rearrange your columns so there is an alpha field as your first sort field.

Here's a way, but there's a tradeoff -- You get TOTAL and the total values on a single line, at the cost of indenting the entire report a bit.

DEFINE FILE CAR
NADA/A1=;
END
TABLE FILE CAR
SUM
CNT.SEATS AS ''
BY NADA AS ''
BY DEALER_COST
BY CAR
ACROSS COUNTRY AS ''
ON TABLE SUMMARIZE
END

This message has been edited. Last edited by: j.gross,

DEFINE FILE CAR
V_SC/A100 = MODEL || COUNTRY;
V_AC/A100 = IF V_SC EQ 'M1' THEN 'King' ELSE IF V_SC EQ 'M2' THEN 'Queen' ELSE IF V_SC EQ 'M3' THEN 'Jose' ELSE IF V_SC EQ 'M4' THEN 'Alpha' ELSE 'Beta';
Model/A100 = MODEL;
Country/A100 = COUNTRY;
END

TABLE FILE CAR
SUM
CNT.V_SC AS ''
BY Model
BY Country
ACROSS V_AC AS ''
ON TABLE HOLD AS MYFILE FORMAT ALPHA
END

TABLE FILE MYFILE
PRINT
*
ON TABLE COLUMN-TOTAL AS 'Total'
END

Try this this stil din help me out of the problem my first by is a alpha nw.