Sub-Reports

[iliasbasha]

I am from Crystal background. In Crystal there is sub-reports feature. Can someone tell me if WebFOCUS supports sub-reports? If not, then are there any workarounds Thanks.

 

[iliasbasha]

Please post solution for the following.

I have two tables Project_Access and Project_Linking.

Project_Access

Employee1 ProjectA
ProjectD
ProjectG

Employee2 ProjectF
ProjectG
ProjectH


Project_Linking

Employee1 ProjectC
ProjectD
ProjectE
ProjectF
ProjectG
ProjectH

Employee2 ProjectC
ProjectD
ProjectE
ProjectF


I am trying to generate report that looks like the following


Employee Name Access Link
Employee1 ProjectA ProjectC
ProjectD ProjectD
ProjectG ProjectE
ProjectF
ProjectG
ProjectH
Employee2 ProjectF ProjectC
ProjectG ProjectD
ProjectH ProjectE
ProjectF

 

[WFGuru]

A MATCH FILE will do exactly that. Try this.

MATCH FILE PROJECT_ACCESS
PRINT ACCESS
BY EMP
RUN
FILE PROJECT_LINK
PRINT LINK
BY EMP
AFTER MATCH HOLD OLD-AND-NEW
END
TABLE FILE HOLD
PRINT ACCESS LINK BY EMP
END