but surely if I have say 10 customers, there has to be some way of me dynamically inserting 10 customer-IDs...and if I want to automate the whole reporting monthy,say, I must have some means of dynamically changing the underlying SQL command.
Any help or advice is greatly appreciated.