Group by only one transaction type
Hi all
I want to group on one transaction type by year but include the other transactions with the same ItemNumber irrespective of what year they were in. For example:
Year ItemCode TransactionType TransactionYear
2009
Item1 PPS 2009
Item1 WMV 2010
Item1 MVW 2010
Make sense ?
Essentially I want to build an Item Consumption history starting from the first purchase (PPS)
Bit stuck.
Any ideas ?
TIA
June 14th, 2011 6:11am
Just tried grouping by the ItemCode but with over 10,000 items on the report in 50,000 transactions it is a pig to run.....
Free Windows Admin Tool Kit Click here and download it now
June 14th, 2011 6:30am
I would add another field to your underlying table called First_Purchase_Year and group on that.Martina White
June 14th, 2011 10:46am
1. Try using a sub report by passing ItemCode and Year as Parameters
Or 2. As martina said add a field first_purchase year and pull all items under that year in single set. Probably this will increase size of your dataset.
Spandan
Free Windows Admin Tool Kit Click here and download it now
June 14th, 2011 12:26pm
Worked a treat Martina. Thanks
Thanks to you as well Spandan
Trouble is 2005 does not export the subreport to Excel.
June 14th, 2011 3:40pm