Report from dbf with two(2) sets of indexes

[tomsr]

We are trying to print a copy of a catalog for a customer from an inventory database. He has been manually putting changes into the database and then again into Corel from which he prints his catalog. He insists that it be the same as it is in Corel as he has been doing that way for some time.

Problem: Basically the catalog is divided into two parts, call them catorder 1 and catorder 2. When catorder is one the file has to be indexed as catorder,manufacturers name, category and this prints fine (using the same data grouping). When catorder is 2 the index (data grouping) has to be catorder,category (because more than one manufacturer's name prints UNDER the category). I have tried to do it by using two databases, but there doesn't seem to be anyway to append the second run of the report on to the bottom (last line - not the footer) of the first run.

I am using V6 but will upgrade to V8 if that handles the problem

 

[ramani]

HI

SELECT field1+field2 AS catOrder1, * FROM myTable ;
INTO CURSOR myCursor ;
UNION ALL SELECT field2+field1, * FROM myTable ;
ORDER BY whatever..

Now you have one cursor with the same table used twice and the order set. Now you can generate one report using this cursor.



ramani
(Subramanian.G)

http://winnersoft.coolfreepages.com/