IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    Grouping data fields in report body
Go
New
Search
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Member
Posted
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
 
Posts: 25 | Registered: May 14, 2008Reply With QuoteEdit or Delete MessageReport This Post
Virtuoso
Posted Hide Post
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.5 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.5 on the same platform and databases,IE7

 
Posts: 1635 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteEdit or Delete MessageReport This Post
Virtuoso
Posted Hide Post
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.5 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.5 on the same platform and databases,IE7

 
Posts: 1635 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteEdit or Delete MessageReport This Post
Virtuoso
Posted Hide Post
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



WF Server: 7.1.6 on Z/OS and Linux, ReportCaster, Self-Service, MRE, Java
Data: DB2, DB2/UDB, Adabas, SQL Server Output: HTML,PDF,Excel2K
WF Client: Linux w/WebSphere, Servlet, CGI
 
Posts: 1306 | Location: Salt Lake City, Utah | Registered: February 02, 2007Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    Grouping data fields in report body

Copyright © 1996-2008 Information Builders, leaders in enterprise business intelligence.