Hi,

I am using the following code in focus to generate a report.

TABLE FILE HOLD
SUM CTRY AS 'COUNTRY'
PRLIST AS 'PRICELIST'
PLI AS 'ITEM'
BY KEY NOPRINT
PRINT AMT AS 'AMOUNT'
TYP AS 'TYPE'
QTY AS 'QUANTITY'
ACROSS TARIFF
BY KEY NOPRINT
END

When I generate the report, for a particular KEY, various rows are displayed based on TARIFF (columns pertaining to only one TARIFF contains data at a time and others are blank). My requirement is to display a single row for the a particular KEY and various TARIFF (along with respective AMOUNT, TYPE and AUANTITY) to be displayed in the same row.

Shrikant

please update your signature in your profile.
how to do that is explaned here

It is for us information about your platform and version.

Did you do any course to learn the language?
Do you use the Developer Studio?

TABLE FILE HOLD
PRINT CTRY AS 'COUNTRY'
PRLIST AS 'PRICELIST'
PLI AS 'ITEM'
BY KEY 
SUM AMT AS 'AMOUNT'
TYP AS 'TYPE'
QTY AS 'QUANTITY'
BY KEY 
ACROSS TARIFF
END

I think this will give the proper result, if I have understand your question well.

Thanks for your response Frank.

I have neither done any course to learn Focus language nor use the Developer Studio.

I have used the modified code, but still the output is same. I am geting mutiple rows for unique KEY, with one set of columns (AMOUNT, TYPE, QUANTITY) having data in each row, others being empty.

If you post an example of what you want I might better understand your problem

put the example in between these code (use the these red helpfull button to do so, or type

[CODE]

[/CODE]
and put the example in it.

then you will get something like

key1    4444   555   6666
        2233    63   5635
key3    5555    77   8654

I am getting output like:

                       TARIFF
                       1                    2                    3
COUNTRY PRICELIST ITEM AMOUNT TYPE QUANTITY AMOUNT TYPE QUANTITY AMOUNT TYPE QUANTITY
-------------------------------------------------------------------------------------
ZZ      1         IT1  100    L    23        
                                            200    M    45 
                                                                 150    N    50
ZZ      1         IT2  134    L    10 
                                                                 30     M    15   

and I want it like:

                       TARIFF
                       1                    2                    3
COUNTRY PRICELIST ITEM AMOUNT TYPE QUANTITY AMOUNT TYPE QUANTITY AMOUNT TYPE QUANTITY
-------------------------------------------------------------------------------------
ZZ      1         IT1  100    L    23       200    M    45       150    N    50
ZZ      1         IT2  134    L    10                            30     M    15
                                                                    

The difference is in the command SUM or PRINT

Your first example is the result of PRINT

So if you change that into SUM it must give the proper result.

Thank you very much Frank. Using SUM as both the verbs solved the problem.

I am having one more query, is it possible to get such kind of output as mentioned below if input file permits:

                       TARIFF
                       1                    2                    3
COUNTRY PRICELIST ITEM AMOUNT TYPE QUANTITY AMOUNT TYPE QUANTITY AMOUNT TYPE QUANTITY
-------------------------------------------------------------------------------------
ZZ      1         IT1  100    L    23       200    M    45       150    N    50
                       400    V    91
ZZ      1         IT2  134    L    10                            30     M    15
                                                                 205    Z    20                                                             

Yes

If you add the row

BY TYPE NOPRINT


So that would be

TABLE FILE HOLD
PRINT CTRY AS 'COUNTRY'
PRLIST AS 'PRICELIST'
PLI AS 'ITEM'
BY KEY 
BY TYPE NOPRINT
SUM AMT AS 'AMOUNT'
TYP AS 'TYPE'
QTY AS 'QUANTITY'
BY KEY 
BY TYPE NOPRINT
ACROSS TARIFF
END

That line should be there 2 times!

Thank you very much Frank.

Its all working fine now and the report is coming fine.

Thankyou once again.