I'm new to WebFocus so I may create my report the hard way but all of my field in my report are custom calculation.

TABLE FILE ECHBILL
SUM
BLANK AS ' '
COMPUTE BLANK2/A6 = 'Number'; AS ' '
COMPUTE BLANK3/A25 = '%'; AS ' ' OVER

Name1NEWAPR AS 'Approvals Heritage Name1 New Billing'
COMPUTE PName1NEWAPR/D7.2 = IF TOTALAPR GT 0
THEN (Name1NEWAPR/TOTALAPR * 100) ELSE 0; AS ' ' OVER
BLANK AS ' ' OVER

Name1OLDAPR AS 'Approvals Heritage Name1 Existing Customers'
COMPUTE PName1OLDAPR/D7.2 = IF TOTALAPR GT 0
THEN Name1OLDAPR/TOTALAPR * 100 ELSE 0; AS ' ' OVER
BLANK AS ' ' OVER

Name2NEWAPR AS 'Approvals Heritage Name2 New Billing'
COMPUTE PName2NEWAPR/D7.2 = IF TOTALAPR GT 0
THEN Name2NEWAPR/TOTALAPR * 100 ELSE 0; AS ' ' OVER
BLANK AS ' ' OVER

Name2OLDAPR AS 'Approvals heritage Name2 Existing Customers'
COMPUTE PName2OLDAPR/D7.2 = IF TOTALAPR GT 0
THEN Name2OLDAPR/TOTALAPR * 100 ELSE 0; AS ' ' OVER
BLANK AS ' ' OVER

TOTALAPR AS 'Total Approvals' OVER
BLANK AS ' ' OVER
BLANK AS ' ' OVER
BLANK AS ' '

COMPUTE BLANK2/A6 = 'Number' ; AS ' '
COMPUTE BLANK3/A25 = '%' ; AS ' ' OVER
Name1NEWDCL AS 'Declines Heritage Name1 New Billing'
COMPUTE PName1NEWDCL/D7.2 = IF TOTALDCL GT 0
THEN (Name1NEWDCL/TOTALDCL * 100) ELSE 0; AS ' ' OVER
BLANK AS ' ' OVER

Name1OLDDCL AS 'Declines Heritage Name1 Existing Customers'
COMPUTE PName1OLDDCL/D7.2 = IF TOTALDCL GT 0
THEN (Name1OLDDCL/TOTALDCL * 100) ELSE 0; AS ' ' OVER
BLANK AS ' ' OVER

Name2NEWDCL AS 'Declines Heritage Name2 New Billing'
COMPUTE PName2NEWDCL/D7.2 = IF TOTALDCL GT 0
THEN (Name2NEWDCL/TOTALDCL * 100) ELSE 0; AS ' ' OVER
BLANK AS ' ' OVER

Name2OLDDCL AS 'Declines Heritage Name2 Existing Customers'
COMPUTE PName2OLDDCL/D7.2 = IF TOTALDCL GT 0
THEN (Name2OLDDCL/TOTALDCL * 100) ELSE 0; AS ' ' OVER
BLANK AS ' ' OVER
TOTALDCL AS 'Total Declines' OVER
BLANK AS ' ' OVER
BLANK AS ' ' OVER
COMPUTE BLANK3/A25 = 'Top Five Decline Codes:' ; AS ' '
COMPUTE BLANK4/A7 = 'Number:' ; AS ' '
COMPUTE BALNK5/A1 = '%' ; AS ' '

what i'm trying to do that is print top five declines codes. all of them have to be on the same report just my top list is printed at the end of the report.

I'm using WebFocus 4.3.6 and simple PRINT is not working.

any ideas?

how do you put two outputs into same Excel report?

It's not an option in 4.3.6 that I'm aware, but if you ever upgrade, you can do a compound report and it can create separate sheets in the work book.