Hai all

I am new to WebFOCUS. I am working on how to get data displayed like this. Can some one help me please?

Column1 Column2 Column3
data1 data2 data3

Column4 data4
Column5 data5
Column6 data6

This pattern should repeat for each record.
I am trying to use over but getting correct only partially..

And I need subtotals of column4, 5 and 6 by column2..I am getting wring values here..?!!

Please let me know of any questions.

Thanks

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

Take a look at FML -- Financial Modeling Language. It allows you to put anything you want wherever you want. A bit more work involved, but you'll get what you're looking for.

Also, consider putting all of it in the heading section or subheading section of the report and using "spot markers" to place the text (both column names and the data results) in any configuration you like. Look up "Spot Marker" in your help file and it will take you to a couple of pretty solid places to get started.

J.

are the column4 and 5 and 6 multi values?
or only single values
if it is single you can put it in the header or footer or in the subfoot
the same with the totals

They could be in the body of the report.

J.

Thanks for your replies. bcz of changes we had 2 reports.
Is there anyway to have subtotals on unique values of that columns??

Example output:

  

V1   V2  V3  V4   SUM1  SUM2 SUM3
A    B   C   G    10    20   30
A    B   E   F    10    20   30
ST                20    40   60

Subtotal of 3 sum fields on V1 gives 20 40 60 as V3 has different values. but it should give only unique values for each V2..!!
TABLE FILE T1
SUM
SUM1
SUM2
SUM3
BY V1
BY V2
BY V3
END

But I need output to look as above but sub total should show 10 20 30 only.?!
V1   V2  V3  V4   SUM1  SUM2 SUM3
A    B   C   G    10    20   30
A    B   E   F    10    20   30
ST                10    20   30

tried using RECAP but dint get it.
any suggestions?

Thanks

Try BY V2 SUB-TOTAL. That will give you a subtotal for V1 and V2.