[CLOSED] Report format

February 03, 2012, 11:37 AM

BI_Developer

Hi

I am new to WebFOCUS. I am trying to get a report in this format. Tried with OVER but could not get the exact thing. Can someone help me with this? For each BY Field format should be like this.


DataFromField1 (BY Field)   -------------> This set is for 1st unique BY field data

Field1   Field2   Field3   Field4
Data1    Data2    Data3    Data4



DataFromField1 (BY Field)   -------------> This set is for 2nd unique BY field data

Field1   Field2   Field3   Field4
Data1    Data2    Data3    Data4

.
.
.
.
.

Please let me know of any questions.

Thank u

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

February 03, 2012, 11:54 AM

Francis Mariani

Would a SUBHEAD be what you're looking for, along with a HEADALIGN:

TABLE FILE CAR
SUM
WHEELS AS ''
WIDTH AS ''
HEIGHT AS ''
BY COUNTRY NOPRINT
ON COUNTRY SUBHEAD
"<COUNTRY"
"WHEELS<+0>WIDTH<+0>HEIGHT"

ON TABLE SET STYLE *
TYPE=SUBHEAD, HEADALIGN=BODY, JUSTIFY=RIGHT, $
END

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

February 07, 2012, 10:24 AM

BI_Developer

Thanks Francis. I made some more changes for my req this works well for HTML and Excel but when it gets to PDF, all field titles in line 2 of subhead are printing without any gap..! I am looking into this. Can you suggest something on this?

quote:
Originally posted by Francis Mariani:
Would a SUBHEAD be what you're looking for, along with a HEADALIGN:
TABLE FILE CAR
SUM
WHEELS AS ''
WIDTH AS ''
HEIGHT AS ''
BY COUNTRY NOPRINT
ON COUNTRY SUBHEAD
"<COUNTRY"
"WHEELS<+0>WIDTH<+0>HEIGHT"

ON TABLE SET STYLE *
TYPE=SUBHEAD, HEADALIGN=BODY, JUSTIFY=RIGHT, $
END