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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics