I originally submitted this to the Crystal list but thought it might be more relevant here.
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 created the tables in Pervasive.SQL Control Centre) I can establish the link in Crystal but the data from the second table is not shown in the report.
I notice a Btrieve tab on the designer screen, should I input anything here?
I have to prepare the report using Business Vision and 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 pervasive 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
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 created the tables in Pervasive.SQL Control Centre) I can establish the link in Crystal but the data from the second table is not shown in the report.
I notice a Btrieve tab on the designer screen, should I input anything here?
I have to prepare the report using Business Vision and 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 pervasive 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