FAQ: Reporter

building reports desktopintelligence
11

:?: How can I make a table from two data providers and only show data common to both?

:!: Once they are linked, each object of linked data providers contains ALL of the values from BOTH queries. If you want to isolate the display to show only records that are in both queries, you need to filter for non-null values from some other non-linked value.

For example, assume you have measure M1 from query 1, and measure M2 from query 2. Measures work the best, but detail object can be used also. You need to create a custom filter (not a pick list) using the following steps.

  1. Click on M1
  2. Click on Format + Filters from the menu. Do NOT use the filter toolbar button.
  3. Click on Add, and select M1
  4. Click Define, and enter the following expression:

= Not (IsNull())

Repeat for measure M2. Now you will only see rows that have entries from both queries.

Cindy Clayton :us: (BOB member since 2002-06-11)