x Want to participate? Join the group to interact
Options
  • State Suggested Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 47 subscribers
  • Views 1470 views
  • Users 0 members are here
Browse Forums
Announcements
51
topics
34
replies
General Discussion
1k
topics
2k
replies
mwb

duplicate lines, crystal 10 bw version 2015

SUGGESTED
Posted By

I am trying to link the following tables and I am getting duplicate records so I am thinking that my links are wrong. Can any tell me what field to link to what table and what type of join?

the tables are arinvoice, arcustomer, icpart, icpartserialno, oeshipto, and apvendor.

  • 0

    A complete listing of Sage BusinessWorks tables and fields, including linked fields is available on the Sage BusinessWorks News Web site.

    1. From the Sage BusinessWorks Welcome screen, click Sage BusinessWorks News

    2. Select the Features sheets

    3. Select File Formats

    The information in the tables and fields can be used to create a Crystal Report or query the database from Excel.

    If you need additional  assistance with creating a Crystal Reports please contact Sage BusinessWorks at (800) 447-5700, select option 1 for Client Care. Ask for a list of Sage Business Partners in your area to assist with the Crystal Reports.

  • 0 in reply to Coleen Graber

    I am trying to see if these tables can be linked on primary table and if so what join, or do they have to be done by subreport, Everything I have tried keeps duplicating the lines which normally means you have wrong links and joins.

  • 0 in reply to mwb
    SUGGESTED

    mwb-  If you have any questions on linking tables, I would have you call our support team at 800-447-5700 to discuss your options.  Or I would have you contact Sage BusinessWorks at (800) 447-5700, select option 1 for Client Care. Ask for a list of Sage Business Partners in your area to assist with the Crystal Reports.

*Community Hub is the new name for Sage City