Is there a way to take an analysis report and export it into excel?
You have to be more descriptive by what you mean by analysis report. If you are referring to the sales analysis reports, then they can be printed to a tab delimited text report and then pulled up in excel, but there is plenty of clean up involved with that. The best way is if the report can be pulled up with Smartlist. Depending on what type of information you need on the report, you may need Smartlist Builder. Do you own it?
Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com
Its a RM Period Sales Analysis Detailed sorted by Customer. I've pulled it up in excel but would rather avoid the clean up in the future if theres an easier way to do it such as the smart lists. I havent been able to find a way to add enough information to the smart lists to make it as useful as the reports and no I do not own it. Thanks.
If you feel comfortable in RW, you could redo the report somewhat as a custom or strip down the original to limit the clean up (i.e., reduce the headers and footers, and page headers for example). Is an alternative. That would be the only other answer that I am aware of.
Or another thought I had after submitting the last request. If you are on GP 2010 (not sure about 10), if you have SRS reports deployed, that would be an option as well. Pretty easy to get those to excel.
Thanks for the help.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13