×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Creating a Btieve File

Creating a Btieve File

Creating a Btieve File

(OP)
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

RE: Creating a Btieve File

First off, the .mkd and .btr, file extenstion are not indications of file incompatability.  

If I understand what you are trying to do, then, it sounds like the problem is in your join.  Have both tables been added to the crystal report?  Have you verified the join that Crystal created?

Personally I have never tried to use Crystal for what you are using it for.  I have written something to create a temporary table then launched crystal and printed from that table.  Personally I think its a shortcomming of Crystal to not allow the report to specifiy a varying number of copies of each page, but thats just my 2 cents.

RE: Creating a Btieve File

GO the the Pervasive SQL control center and open up the database you wish to add this table to.  Open up tables and click on Action, then New Table.  The process is very straight forward.

Please let me know if you have any questions.

Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

RE: Creating a Btieve File

(OP)
Thanks for the help, over the last 6 weeks I created about 12 files of different sizes and Decimal & Integer and Text types etc to test and none linked in Crystal. Today they all linked and I don't know what has changed!
Just glad it works

DGILLZ
Sometime ago you e-mailed me a file called X Number of Labels.mdb and a Crystal report to
mike@accsys.ca.
I have had a lot of problems with that address and could not open the files.
If it is not too much trouble if you could try again to
mikepienaar@mail.com
I would appreciate it.
I will respect your confidentiality request

Many thanks once again


RE: Creating a Btieve File

(OP)
I have just discovered why it works!

I did it through ODBC, if you access the files directly through Database Files it does NOT work. I thought it was just my machine on version 8 but a freind with ver 8.5 cannot get the files to link either.

Maybe somebody else could try it?

Mike99

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close