Hello Everyone,

I have searched the forum but still not getting what I need.

I want to display like 10 webfocus reports in one tab and 10 reports in other tab. The e.g. I have shared below is showing 2 on each tab but it isn't working can someone tell me what am I missing.

 

TABLE FILE CAR
PRINT *
WHERE RECORDLIMIT EQ 1
ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Report1', $
ENDSTYLE
END
-RUN

TABLE FILE CAR
PRINT *
WHERE RECORDLIMIT EQ 2
ON TABLE PCHOLD FORMAT EXL2K CLOSE
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Report1', $
ENDSTYLE
END
-RUN


TABLE FILE CAR
PRINT *
WHERE RECORDLIMIT EQ 3
ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Report2', $
ENDSTYLE
END
-RUN
TABLE FILE CAR
PRINT *
WHERE RECORDLIMIT EQ 4
ON TABLE PCHOLD FORMAT EXL2K CLOSE
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Report2', $
ENDSTYLE
END
-RUN  

 

Thanks is advance.
Gaurav Tyagi

This message has been edited. Last edited by: <Kathryn Henning>,

Your first report (tab) should be a straught-up table request, like you've done.

The second tab should be like this example...
http://forums.informationbuild...371018331#3371018331

Tom

Hello Tom,

Thanks for your response.

Can you please make some changes in the code I have pasted. I don't get exactly what I need to do to make it work. Loops will run same reports again but I have all different reports.

Thanks & regards,
Gaurav Tyagi

You need to understand how a compound report works.

You only have one OPEN and one CLOSE statement.

With EXL2K, and TABLE FILE where the previous compound command does not have a NOBREAK will be moved to a new TAB.

Play around with your sample, and remove that extra CLOSE and OPEN

Waz - Thanks I got it right with your advice.

Toms - It cxan be achieved without using loops.

Thanks Guys