combining result set data

building reports desktopintelligence
1

Here is my problem:

I have two queries, query (1) returns one row of data. Query (2) returns > 1 row.

On my report I would like to replicated the data from query (1) with query (2).

For example:

query(1) result set: Year, Week, Distributor Number, Invoice quantity. (1998, 8, 0001,120)
query(2) result set: Year, Week, Forecast week, Distributor Number, forecast quantity.
(1998, 8, 10, 0001,125)
(1998, 8, 11, 0001,115)
(1998, 8, 12, 0001,100)

I would like to combine the data from both queries to obtain the following: (1998, 8, 10, 0001,125,120)
(1998, 8, 11, 0001,115,120)
(1998, 8, 12, 0001,100,120)

Dianna Anderson
TUSC - Coors Brewing Company

Listserv Archives (BOB member since 2002-06-25)

2

Dianna,

This is very simple. All you need to do is link your two queries. Go into your Data Manager. You will see your two queries on the right hand window. On the left side, click on the definitions tab and link by year, week, and dist number. create a third report with the two linked report (use data from old reports). Bring in the columns you want and you’re all set with your linked data sets. Hope this helps.

Listserv Archives (BOB member since 2002-06-25)