×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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!
  • Students Click Here

*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

Jobs

Pawcom, Crystal Reports and Access

Pawcom, Crystal Reports and Access

Pawcom, Crystal Reports and Access

(OP)

I am trying to create a report from a separate MS Access database and Pawcom in crystal reports 8.5.

The field I'm trying to link is a PO number.

I've been trying to use the Purchase Order Journal Header table, PONumber field in Pawcom, which is a text field, and the POnumber field in the other database, which is unfortunately a number field.

I've been trying to do this by making a formula in the main report that changes the data type and length of the PO number field in one database to match the one in the other database and linking the subreport field to the main report formula, but it's not working. I've tried with either table in the main report, neither way is working.

The PO number field in the MS Access database is indexed, the field in pawcom is not.  The PO number is the only thing that uniquely matches the two records.  What else should I try?

Thank you

RE: Pawcom, Crystal Reports and Access

Write a formula that converts the number field to string, or vice versa, then use a subreport in crystal linked on the formula field.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
www.trianglepartners.com

RE: Pawcom, Crystal Reports and Access

(OP)

Thank you.  That is what I was doing, but for some reason it wasn't working.  I rewrote it from the begining and it's working now, I'm not sure why.  I must have had something wierd in the original attempt that was messing it up.

Thanx again.

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