C
chris seiter
XP, Office 2007
I have a report that when run basically tells us the part number, how many
are in stock, and how many we need to make to complete a particular order.
There are several order dates to each part, so the rows repeat themselves for
each of the order dates. There are total fields on the report that show how
many parts need to be made if the customer orders more than what is on hand;
all the calculations are done in the report itself. I was able to use a
macro to filter everythihg down to show for each part number the first due
date for parts that need to be manufactured and not just taken from stock.
This report needs to be exported to excel, but that functionality was taken
out of 2007. How can I get the report to open in Excel with the calculated
fields showing?
I have a report that when run basically tells us the part number, how many
are in stock, and how many we need to make to complete a particular order.
There are several order dates to each part, so the rows repeat themselves for
each of the order dates. There are total fields on the report that show how
many parts need to be made if the customer orders more than what is on hand;
all the calculations are done in the report itself. I was able to use a
macro to filter everythihg down to show for each part number the first due
date for parts that need to be manufactured and not just taken from stock.
This report needs to be exported to excel, but that functionality was taken
out of 2007. How can I get the report to open in Excel with the calculated
fields showing?