[SOLVED] Merging files causing a problem

 
DEFINE FILE CAR
CAR_DETAILS/A100 = COUNTRY|' '|CAR|' '|MODEL|' '|BODYTYPE;
END
TABLE FILE CAR
PRINT
CAR_DETAILS
BY MODEL
ON TABLE HOLD AS MAIN1 FORMAT FOCUS
END
-RUN
DEFINE FILE MAIN1
CAR_NAM/A100 = 'HEADING';
END
TABLE FILE MAIN1
PRINT
CAR_NAM
-*HEAD1
BY MODEL
WHERE RECORDLIMIT EQ 1
ON TABLE HOLD AS HOLD1 FORMAT FOCUS
END
-RUN

TABLE FILE MAIN1
PRINT
CAR_DETAILS
BY MODEL
ON TABLE HOLD AS HOLD2 FORMAT FOCUS
END
DEFINE FILE MAIN1
TRAIL1/A100 = 'TRAILER';
END
TABLE FILE MAIN1
PRINT
TRAIL1
BY MODEL
WHERE RECORDLIMIT EQ 1
ON TABLE HOLD AS HOLD3 FORMAT FOCUS
END
-RUN
TABLE FILE HOLD1
PRINT
CAR_NAM 
BY MODEL
ON TABLE HOLD AS FINALHOLD FORMAT FOCUS
MORE
FILE HOLD2
MORE
FILE HOLD3
END
-RUN

TABLE FILE FINALHOLD
PRINT
CAR_NAM AS ''
BY MODEL NOPRINT
END
-RUN

there are a few constraints.
1) I have to merge the three files is for header, main report and trailer. I created separate hold files for them and merged them.
2) I want the header and trailer (mentioned as above) to be repeated as the sort field changes ie if for this example my model changes from SUV to MPV then the header and trailer should be repeated.
now the problem i am facing here is that I am getting the header and trailer after the value changes for the first time itself and then the header and trailer don't get repeated

.

thanks in advance

Sid

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

_________________________________________________________________

WF Server: 7.1.4 on Unix and Win2K3 server, ReportCaster, Self-Service, MRE, Java
Data: Teradata, Oracle, SQL Server Output: HTML,PDF,EXL2K, WP
WF Client: 7.1.4 on Windows 2K3 w/Tomcat

Posts: 27 | Registered: August 12, 2009

GinnyJakes

Expert

posted

Hide Post

If you are using MORE, make all the column names in ALL of the hold files the same name, either CAR_NAM or CAR_DETAILS, whichever. It might be helpful if you looked up the syntax and restrictions for this command.

Then create two extra sort fields for each model, one that gets incremented when the model changes, and a second inner one with lets say is a 9 in it for the trailer and a zero for the header, and you can choose whatever you want for the detail records. You would sort the final result by SORT1, SORT2, MODEL.

You rule the data; don't let it rule you.

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006

sidney_jec

Member

posted

Hide Post

the solution was pretty simple..
i had screwed up big time..
i removed the "where recordlimit.." and got the desired output..

Thanks a lot anyways..

Posts: 27 | Registered: August 12, 2009

Ignored post by sidney_jec posted

Show Post

Please Wait. Your request is being processed...

Read-Only Topic

Focal Point

Focal Point Forums

WebFOCUS/FOCUS Forum on Focal Point

[SOLVED] Merging files causing a problem

Focal Point | Privacy Statement | Terms of Service