problem with crystal....
i need help in the following situation. when i go to create a report i go to select expert, then click on category and select say copper fittings. boom i get a list of all my copper fittings. my design sheet is set up so that it shows the item number, description, quantity on hand, and quantity sold. now when i go to select expert again and choose say date transfer of an item...put in my dates( 1/1/2009-1/3/2009)... boom the list refreshes and this list is now shorter than my original list and it shows me the items that have transfered during that period of time as well as the quantity... well my question is what happened to all the other items that were in the list before??? i understand that they are no longer there because they did not transfer during that period of time, so it doesnt show them... well i still want those items to show up with the rest that did transfer... so that way i can see what transferred and what dint all in one list... i keep trying different things but keep running into the same problem... does anyone know of a solution for this???
thanks...appreciate any help