Ok - suppose i want to run a report to compare 2006 sales to 2007 sales by supplier. I run 2 seperate reports according to date rage.
I now want to export them and present them in excel.
Problem - there are old and new suppliers, so things are not in order, and i have to sift through them to make sure i align the correct sales against the correct supplier. I've tried a few filters, but is there any way i can get it to put a suppliers name into the report, even if the sales from that supplier were zero??
thanks!
Phil