I am trying to build a report through composite data window and my child data windows have different retrieval arguments (one is bounded by date whereas the other one is a list of all items). What I need to do is display the pieces of the item available based on date ordered (0-30 days, 31-60 days, etc.). Right now I am not seeing the item count for all my items ( only the ones that are ordered in the time frame - retrieval argument - are displayed). I am wondering if I can join these two child data windows so that I can show the relevant line on the composite.
Right Now these are the entries on my database for last 30 days:
This is result of composite right now (which is incorrect as 40 pieces corresponds to Item E):
|Item||Pieces ordered within last 30 days|
I am looking to display something like this:
Please guide me on what is the best way to approach my problem.