Getting previously measured data into excel

Have a program that has been run with complete data and then SAVED AS to a new PCDMIS PRG to retain that data. Now I'm trying to reload that data (no problem, I just open that pdmis program copy) and run that data so it loads into an excel file. And there's the rub. I see the excel options under the PRINT REPORT dialog box, but I can not get PCDMIS to rerun that data into an excel file. There must be a way to do this, but it beats me. Any help is appreciated.
Paul S

Parents

ArkansasBeeper 10 months ago

Your profile says your running 2015? I was never able to get the excel export work even in 2016. But report output did work. (sometimes)

Below are the steps for that. You can pick whatever options work for you, but sometimes getting the data into a sheet and then using a new sheet in Excel to massage just what you want is easier.
Keep note of the file locations as they can get wonky. Also had it fail sometimes if you set it to open the report when done.
Then just open your report window and hit print, it will generate the PDF then the Excel.

Attached Files
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

ArkansasBeeper 10 months ago

Your profile says your running 2015? I was never able to get the excel export work even in 2016. But report output did work. (sometimes)

Below are the steps for that. You can pick whatever options work for you, but sometimes getting the data into a sheet and then using a new sheet in Excel to massage just what you want is easier.
Keep note of the file locations as they can get wonky. Also had it fail sometimes if you set it to open the report when done.
Then just open your report window and hit print, it will generate the PDF then the Excel.

Attached Files
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

No Data