Glad that you find the site and book helpful. I'm thinking that your problem is that the database is most likely not normalized for the field you are linking to and you are getting a cartesian resultset. I cover this on page 416 of the new book, but basically it means that the Unit_ID field is probably linking multiple times to the other table you are joining with. This results in a report which suddenly has a huge page count and you see the same data repeated over and over. To fix this you need to analyze your data and make sure that the linking field only matches a single record in the other table. Sometimes this isn't possible when you are linking to a table of history transactions and you have a similar record for each date. In this is happenis to be your problem, you need to create a subquery that returns the distinct records of the last transaction (I cover this on page 433 of the book). But most likely, you just need to review your data and check that things are matching up one to one rather than one to many and throwing your data out of whack.

Oh, I thought you were referring to my 'CR Encyclopedia' book. Anyway, you get a cartesian product when the ID field appears more than once in the table. Does the table that has the price only have one record for each ID field? I've seen problems where a table like this might have multiple price records for each Unit Id b/c it wants to track the price history. Thus, you link to the Unit ID field and the next thing you know the report blows up in size and there is repeated data everywhere. I don't know if this is your situation or not.

No worries about the URL mix-up. Unfortunately, there are a lot of "Crystal Book" type websites out there right now. Let's just try to make this one the best! 

Re the catesian product problem, the most common way I use to get around that problem is to create a View in SQL which uses the SQL DISTINCT keyword to create a table without all the duplicates. Then I link to that View. Hopefully this is an option for your situation. (I have no idea what Prophet 21 is, - although it reminds of of the Alias TV show....)

Re the shipping/receving comparison,why is it filtering out items that don't have a price? Do you have a price criteria in the record selection filter? Are you joining the tables and there isn't a record in the corresponding price table? If so, then I would do a LEFT OUTER JOIN so that it still uses products even when there isn't a matching record in the Price table.

Oh - and buying a copy of the book is always appreciated, though certainly not a requirement to use the site.