Hi
I have an object ‘ITEM’ that is in 2 queries. 2 queries merged on ITEM.
First query returns ITEM count is 10000 and second query returns ITEM count is 9000
in the report how can i dispay the missed ITEMS.
i am using webi xir2 and sql server 2008
i would appreciate your help.
screeid (BOB member since 2007-04-18)
Can you change the queries around? If so you could create a combined query. Where query one of the combined query is what returns the 10,000 items and query two of the combined query is the query that returns 9,000 items. Then use a minus operator for the combined query. This will return the records in Query 1 not in Query 2.
jbarnes794 
(BOB member since 2008-06-13)