Hi Experts
I am busy doing an inventory report in Crystal. I need to pull the stock on hand for all the items for each month (past 4 years, +-2500 items)
At the moment, i am taking inqty - outqty where date <= (beginning of each month)
My report is taking forever to process the info.
Is there any other way I can get the stock on hand at previous points in time? Or any tricks to help SQL process the data quicker?