At the moment i'm trying to fix this problem.

 

I have created 2 lists, both on different reports. One list contains all our parts with actual stock (LIST X). The other list contains all our parts which are sold last year. (List Y)

 

Now what I want to accomplish is the following: I want a list (LIST Z) which show LIST X - LIST Y.

 

For example:

 

Part A

Part B

Part C

Part D

 

(group) Part A

         (DETAIL) Part A - date sold

         (DETAIL) Part A - date sold

         (DETAIL) Part A - date sold

(group) Part C

         (DETAIL) Part C - date sold

 

Part B

Part D

 

There is only one catch. LIST Y is a list with groups. Now I'm trying to do something with subreport but I have not found a solution yet.

 

Does somebody have an idea?

 

Thanks.

 

 

No not really subtract.

And yes I would like them both in one report. (nut neccasary)

 

But the most important thing is that LIST Z shows me all parts which LIST X shows. EXCEPT the parts that LIST Y generates!

 

Not sure what you mean with view and sp?

 

However I am trying to do something called Vlookup in Excel.

 

Hope you understand what i mean