Focal Point
Grouping data fields in report body

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6841099292

July 25, 2008, 04:18 PM
seadog
Grouping data fields in report body
Is there a mechanism for grouping field values from a record within a report body? Under my current scenario I can only display columns moving across left to right. I am looking to create a section with data elements from a record in a group configuration?


WebFOCUS 7.6.4
Windows
July 25, 2008, 04:37 PM
FrankDutch
Seal

Can you give an example of what you are trying to do.
Is it a free form report like a letter with address fields in the header?
If so, yes it is possible.
Did you get some training, do you have some manuals or did you download some PDF files?

Try to paint your report, create a screen shot, post it somewhere on the Internet (tinypic.com) and show it here in your answer.

I hope (and think) we can help you.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

July 28, 2008, 01:39 PM
FrankDutch
thanks for the send example.

I post it here to give everybody the possibility to think and help.







You will get several answers I think

TABLE FILE ADRESSES
PRINT ADDRESS NOPRINT
BY RELATIONID NOPRINT
ON RELATIONID SUBHEAD
"<RELATIONAME <ADDRESS <AGE <GENDER"
"<CITY <SS# <POSITION <DEPT "
<STATE <ZIP <FACILITY <SENIORITY"
HEADING
"This is the report header"
FOOTING
"<page"
END


You have to add some style codes and grid codes to position all the fields on the exact place and to give them bold, italic or other styles.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

July 28, 2008, 03:01 PM
Darin Lee
We use a report for claims that looks very similar that would basically be

TABLE FILE ADDRESS
PRINT
ADDRESS AS ''
AGE AS ''
GENDER AS ''
HIREDATE AS '' OVER
CITY AS ''
SSN AS ''
POSITION AS ''
DEPT AS '' OVER
STATE AS ''
FACILITY AS ''
SENIORITY AS ''
SUPERVISOR AS ''
BY NAME
END

You would probably also need to include in a stylesheet some POSITION= statements (TYPE=REPORT,COLUMN=ADDRESS,POSITION=1.5,$) etc. to get columns where you want them.

A little longer than Frank's but also gets you what you need.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat