2 reports in one excel sheet

Hi,
I want something like
TABLE FILE CAR
PRINT
COUNTRY
ON TABLE PCHOLD FORMAT EXL2K
END
TABLE FILE CAR
PRINT
MODEL
ON TABLE PCHOLD FORMAT EXL2K
END

Only the 1st one comes in the excel sheet.
How do i show both reports in the same ecel sheet?

Posts: 109 | Registered: January 31, 2006

Tony A

Expert

posted

Hide Post

Karanth,

There was a recent posting that described how to do this by J.G. (I think). Try the Find function to locate it.

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Show Post

Kamesh

Master

posted

Hide Post

As Tony Said, you can find the recent post about this posted by JG OR you can get this by using the code below,

TABLE FILE CAR
PRINT
COUNTRY
ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK
END

TABLE FILE CAR
PRINT
MODEL
ON TABLE PCHOLD FORMAT EXL2K CLOSE
END

WFConsultant

WF 8105M on Win7/Tomcat

Posts: 780 | Location: Florida | Registered: January 09, 2005

Ignored post by Kamesh posted

Show Post

Tony A

Expert

posted

Hide Post

Quite right Kamesh, however I was thinking more along the lines of two reports - two worksheets (or "tabs").

This code will provide seperate worksheets using BYTOC -

DEFINE FILE CAR
 BREAK1/A20 = 'COUNTRY';
 BREAK2/A20 = 'CAR';
 BREAK3/A20 = 'MODEL';
END
MATCH FILE CAR
PRINT COUNTRY
   BY BREAK1 AS BREAK 
RUN
FILE CAR
PRINT CAR
   BY BREAK2 AS BREAK 
RUN
FILE CAR
PRINT MODEL
   BY BREAK3 AS BREAK 
AFTER MATCH HOLD OLD-OR-NEW
END
TABLE FILE HOLD
PRINT COMPUTE DATAFIELD/A30 = IF BREAK EQ 'COUNTRY' THEN COUNTRY
                         ELSE IF BREAK EQ 'CAR' THEN CAR ELSE MODEL;
   BY BREAK
ON TABLE PCHOLD FORMAT EXL2K BYTOC
END