July 25, 2008, 04:18 PM
seadogGrouping 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?
July 25, 2008, 04:37 PM
FrankDutchSeal
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.
July 28, 2008, 01:39 PM
FrankDutchthanks 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.
July 28, 2008, 03:01 PM
Darin LeeWe 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.