Hi,
my requirement is that I have to create six reports..all of the same froamt with the same columns.
Some of the columns are
Region,ItemCode,Sales etc
The first report is a consolidated report showing sales for all the regions
The next five reports should be regionwise(assuming there are five regions).i.e. It'll be a subset of the master report.
Format is Excel 2000 Single sheet
I am wondering which approach would be best and most feasible as i dont want to create new reports if number of Regions suddenly increase or decrease in the report
Please Help
Thanks in Advance