Trying to use two "linked" tables on the same report with different datasets

  • I have two tables.  The first table I am showing the customer's prices.  The second table is the customer's ship-tos.  I don't want to use subreports because of performance issues (the reports are accessed from other countries).  I have been trying to use a list (which has worked for me in the past).  I put both my tables in the list.  I assign the Customer dataset to the first table and the list.  I assign the ShipTo dataset to my second table.  However, if I try to create a sort, the field list displayed is from the Customer dataset.

    I have also tried using a table within a table.  I get the same problem.

    Am I missing something?  Is there another way to do this?

    Thanks for any help.

  • I found out what I am trying to do can not be done.  I have to use a subreport or include the data I need in my primary dataset.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply