Multiple Copies Of Same Report

[mike99]

I'm back again
I have to develop a report that prints labels for goods to be shipped and the quantity of labels to be produced must be determined by the quantity sold as detailed on the invoice.
I have set up two tables in Access as a "proof of concept" where I link a "Quantity Ordered" field in table 1 to a list of numbers as follows in table 2.
1
2
2
3
3
3
etc
In Access this works fine and I get the duplicate records I require.
When I set up similar tables using Pervasive I can establish the link but the data from the second table is not shown in the report.
I have to prepare the report using Btrieve and when I link a pervasive table to the Btrieve file I can establish the link but there is no data in the report. I defined the pevasive table as Decimal, Precision 9 and Scale 3
The Pervasive tables end in .mkd and the Btrieve tables in Business Vision end in .btr, would this indicate an incompatability.
Any help or hints would be appreciated.
Mike99

 

[dgillz]

Mike,

I have done this report or something similiar a number of times using Macola, another Pervasive based software, and MS Access. You need to make sure that the "to" field is indexed, and that you are linking from your Pervasive database to your Access Database.

Check that out and let me know if you have any questions.
Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[mike99]

Thanks

I am linking from Pervasive to Access and I get a message in Crystal when I establish the link that "fields may not link successfully due to different type". The field is indexed.

Hope this helps