Linking questions

Hi All,

I am writing a report that will eventually show our salespeoples’ hit/miss ratio for converting samples sent to a customer into real production orders. Currently, this is a two query report. The first query will return all part codes from sample orders that also have production orders, the second query returns only part codes from sample orders.

My problem is this: I need one column to show only the results from query 1, and another column to show only the results from query two. The kicker is that this is the same object from query 1 and query two “part code.” B.O. links these by default, which is not good for my purposes. I get the combined results for both queries. If I unlink the query, B.O. will not let me insert the second object.

Eventually what I want to do is compare query one and query two, if they match then return 1, if they don’t because the second column is null, then return 0. Then I can do a ratio of 1’s to 0’s and return and give management the info they want.

Any ideas appreciated.

thanks

jim


deliverator (BOB member since 2003-10-28)

Have a look here at the presentation called ‘Solving The Mystery Of Data Providers’ explains it all and how to solve the problem you are seeing.

http://www.bonymaug.com/reporter.htm


Rich :uk: (BOB member since 2002-10-04)