Hi All,

I want to know how to code in the procedure to make the reports generated as tabs in Excel.

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

Depending on whether you want to created tabs for different reports or for breaks in data, search for BYTOC or COMPOUND.

See syntax for compound, this has worked for me in the past:

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

hope this helps.

This is much simpler:

SET COMPOUND=BYTOC
TABLE FILE CAR
SUM SALES 
BY COUNTRY
BY CAR
ON TABLE PCHOLD FORMAT EXL2K
END

quote:

SET COMPOUND=BYTOC
TABLE FILE CAR
SUM SALES 
BY COUNTRY
BY CAR
ON TABLE PCHOLD FORMAT EXL2K
END

It is simple but it will generate 100 tabs if the By field has 100 values in it.

Yes.

How many tabs are you expecting?

Also, my requirement is not from a single table, I want the tabs based on the field names of different tables, but used in the same report.
ex:
---
table A
---------
Field 1 | Field 2 | Field 3


Table B
---------
Field 4 | Field 5 | Field 6


Table C
---------
Field A | Field B


I want four excel tabs named,
1. Field 2
2. Field 4
3. Field 6
4. Field B

Then use a concatenated key to do the sort.

quote:

Originally posted by GinnyJakes:
Then use a concatenated key to do the sort.

how to do that, can u explain with an example

Your are not giving me much to go on. Are you joining the tables? Now that I look at your previous post, what you probably need to do, and this is a stab in the dark because I can't see your code, is to create a TABLE request for each view and use a define to create a generic sort field based on the value from that table. So for instance, table A would look something like this:

DEFINE FILE TABLEA
SORTFLD1/Ann=FIELD2;
END
TABLE FILE TABLEA
PRINT ...
BY SORTFLD1
...
ON TABLE HOLD AS HOLDA FORMAT ALPHA
END

Do something like this for each view. Then create your final output:

SET COMPOUND=BYTOC
TABLE FILE HOLDA
PRINT ...
BY SORTFLD1
ON TABLE PCHOLD FORMAT EXL2K
MORE
FILE HOLDB
MORE
FILE HOLDC
END

Please experiment with this shell to get it to do what you want. FYI, the MORE syntax concatentates the 3 hold files together assuming like fieldnames and formats. Look up either the MORE command or Universal Concatenation.