# Dashboard to Excel **Category:** [Epicor ERP 10](https://www.epiusers.help/c/e10/5) **Created:** 2016-11-11 16:34 UTC **Views:** 6819 **Replies:** 23 **URL:** https://www.epiusers.help/t/dashboard-to-excel/36247 --- ## Post #1 by @Tricia I'm slowly making progress here. Thank you for all the help so far. I've created a BAQ and a related dashboard. Both result in the required data. However, from the dashboard when I right-click and select "copy all with headers" and then paste it in Excel - all the formatting is CRAZY! How do I get it to carry the same columns from the dashboard to Excel??? Thanks!!! --- ## Post #2 by @mjfwagner When you say all the formatting is crazy do you mean the cells don't line up? Normally when you copy and paste it should align with excel. You can also try deploying the dashboard as a .dll. In dashboard maintenance go to Tools/Deploy Dashboard and check the box for "Deploy Smart Application". Click the deploy button and it will create the .dll When complete, save the dashboard Go to menu maintenance where you deployed the dashboard. Change the dashboard type to dashboard assembly instead of run time. Close out and reenter Epicor You will now be able to right click and "Copy to Excel" (if excel is on the same computer) and see how the alignment looks. Users also like the extra feature of being able to both open and copy to excel at the same time Mark Wagner Sr. Partner Capstone Alliance Partners 888.597.2227 Ext. 71 <888.597.2227%20Ext.%20714>2 | 904.412.6847 (cell) | www.capstoneap.com --- ## Post #3 by @DavisStd1 One thing we have seen is that there are carriage returns in the Part Description. Excel interprets these as a new cell, and that causes the data to not line up. You can try to truncate the description in the dashboard to 15 or 20 characters. --- ## Post #4 by @Tricia Mark, Thanks. I got through the dashboard deployment and saved it. However, I'm not sure what you mean by "menu maintenance where you deployed the dashboard". Nothing opened after I clicked save so I'm not sure where I'm supposed to look. :frowning: Thanks! --- ## Post #5 by @Tricia Mark, OK - I did find what you were suggesting and did all that. When I reopened Excel and ran the dashboard, I did get the Copy to Excel option. However.....nothing happens. :( Excel doesn't open - there is no spreadsheet. Am I still missing a step?? Thanks again! --- ## Post #6 by @Tricia Thanks for the suggestion. I'm not using description at the moment - just part number, trans type and trans date. I can't figure out what is happening. :( --- ## Post #7 by @duckor If those are the only columns you are using, I find it strange that the formatting would be messed up. I've only seen formatting get screwy when there are carriage returns. Maybe post a picture of the excel sheet so that we can narrow down where the formatting issue is? --- ## Post #8 by @mjfwagner Do you have excel deployed on the same workstation? It should be greyed out if it cannot detect Excel usually Only thing may be a permissions problem where on the Epicor server where the .dll folder is kept? Try redeploying the dashboard one more time and then recheck your menu to make sure it is deployed correctly for the right dashboard Mark Wagner Sr. Partner Capstone Alliance Partners 888.597.2227 Ext. 71 <888.597.2227%20Ext.%20714>2 | 904.412.6847 (cell) | www.capstoneap.com --- ## Post #9 by @mjfwagner IS the dashboard deployed as a menu or only for your use? If it is on a menu, in security/menu maintenance you find that menu, you need to change it to a dashboard assembly instead of runtime dashboard, When you change the selection it will allow you to browse to find the .dll you created If this dashboard is just for your use and you deploy it as a smart client, you can test in dashboard maintenance by going to tools/deploy dashboard/test smart client. Retrieve your results through the refresh button and then you should be able to right click and Copy to Excel If you are deploying a dashboard assembly, you can only test it through the tools/deploy dashboard/test smart client. Otherwise it has to be deployed on a menu to get it to work Mark Wagner Sr. Partner Capstone Alliance Partners 888.597.2227 Ext. 71 <888.597.2227%20Ext.%20714>2 | 904.412.6847 (cell) | www.capstoneap.com --- ## Post #10 by @Tricia I *think* I might have found an issue??? I can find the dashboard on the security/menu maintenance. How do I get it, for example, in the Inventory Management section? Or even Exec Analysis/Status Dashboards? Thanks! --- ## Post #11 by @gpayne How I do this since I am lazy it to check the add favorite Item which make the menu entry in the process section of the menu and is only shown in your dashboard assemblies favorites. Then open menu maintenance and change the parent menu and order sequence to where you want it to show. --- ## Post #12 by @cchang Have you tried adding it as a menu item in Menu Maintenance in the Inventory Management section? --- ## Post #13 by @Tricia I'll do some research to figure out how to add it to IM. I knew how to do all of that when we were on Vantage 6.1 - but things have apparently changed with 10 and it doesn't seem to work the same way. :( Thanks all!!! I sure appreciate all the help and advice! --- ## Post #14 by @mjfwagner You just add a new menu item through Menu maintenance and add it to the Inventory Folder Do you want some screen shots on how to do that? Mark Wagner Sr. Partner Capstone Alliance Partners 888.597.2227 Ext. 71 <888.597.2227%20Ext.%20714>2 | 904.412.6847 (cell) | www.capstoneap.com --- ## Post #15 by @Tricia Mark - that would be great!! Thank you! --- ## Post #16 by @Chris_Conn Add it to desired menu with menu maintenance: --- ## Post #17 by @Chris_Conn Just click the parent menu item, then NEW MENU with the create button. The biggest things to set are: MENU ID (unique) Name (As displayed) Order Seq (relative to other menu items) Program Type to dashboard (most likely assembly) Dashboard: Select from dropdown Customization (if needed) Also don't forget to set security on other tab if needed --- ## Post #18 by @Tricia To all - thank you SO much for all your help!! You have no idea how much it is appreciated! I'm still having an issue, though and can't figure out why. I have successfully added the dashboard to the menu - it is marked as dashboard-assembly. Security set for me. Copy to Excel option is there. However, when I click it - nothing happens. Excel doesn't open. No error message. Just nada. I have closed and re-opened Epicor several times. Thoughts???? Thanks again!!! --- ## Post #19 by @Chris_Conn The excel issue is out of my league. Perhaps one of the local superhumans can help. @josecgomez.trigemco @rbucek @jgiese.wci --- ## Post #20 by @mjfwagner Are you refreshing the dashboard with data before you right click? Is the BAQ on which the dashboard is based "shared" Mark Wagner Sr. Partner Capstone Alliance Partners 888.597.2227 Ext. 71 <888.597.2227%20Ext.%20714>2 | 904.412.6847 (cell) | www.capstoneap.com --- ## Post #21 by @jgiese.wci The easiest way to get a menu item created for a dashboard is when you go to deploy it, select "Add to Favorites". Then back in the menu enter "developer mode". Go to the menu tree folder you want to deploy in, then go to your favorites tab. Right click and drag the dashboard item from your favorites to wherever you want in the menu and it will add a menu item. You can do that for anything. Makes short work of moving stuff around. When you were copying out to Excel before did you have any groupings enabled? Excel handles those the best way it can but it dices up your spreadsheet pretty good. --- ## Post #22 by @rbucek don't look at me lol, I've never seen any real value in that feel good feature. --- ## Post #23 by @Tricia Mark, Yes - to both of your questions. --- ## Post #24 by @cchang Do you have Excel installed? How much data are you copying to Excel? --- **Canonical:** https://www.epiusers.help/t/dashboard-to-excel/36247 **Original content:** https://www.epiusers.help/t/dashboard-to-excel/36247