Hello All,
I'm looking for a excel exporter that is dynamic like the current contributions, but using the logic available in version 2.x. Without the RecordRef or FieldRef types is there a way to allow a "very NON tech" user to select a table and then fields within the table and click a button to export data into excel without creating dataports each time they change the export fields??
Any ideas? :-k
Thanks
Steve
0
Comments
Can they get to a table or Tabular form of the table?
& show/hide the columns they want & even throw a few filters in?
then copy & paste into excel
**EDIT ADDED THOUGHT**
I wonder if it's ONRUN of a command button possible to
SENDKEYS Ctrl-A //Select All
SENDKEYS Ctrl-C //COPY
Shell(excel.exe)
Then all the person has to do is hit the paste button in excel??
:-k :-k
how about something like this?
http://www.mibuso.com/forum/viewtopic.php?t=26657
http://www.BiloBeauty.com
http://www.autismspeaks.org
A non-tech version is to copy and paste to Excel from the screen.
If you need to batch, you can use dataport to export the data in Navision 2.x in a comma delimited format. Excel will pick up and be able to read .CSV files.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
Then you will be able to use all new tools, including all using RecordRefs, Style Sheets tool (which require some development of course), and other new C/AL commands. As a bonus you will get new better debugger
Slawek
BTW: I have a customer which has 2.6, with objects from version 1.03, running on version 5.0 executables and SQL2005. There were some problems only with porting old OCX components - so test thoroughly before upgrading production database. You will also need a new updated licence, which you will get for free if you have active Maintenace agreement with MSFT
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
I agree with Slawek, that a technical upgrade is the best option.
Another reason why clients should be current. Stuff that worked 5 years ago will eventually not work...
Just like my pick up lines.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
In a perfect world, yes. But if you make no changes for years, it sure feels like a lot of $$$ given away for nothing or if something "Might"be needed. So many companies have to drop it to help thru the lean times.
http://www.BiloBeauty.com
http://www.autismspeaks.org
Well... The same argument can be said about insurance. Some people drop their insurance if they're tight on cash.
The enhancement plan with Microsoft, in a way, is like an insurance. You can opt not to be current on it, but when you need it, you'd be kicking yourself in the butt if you don't have it.
Personally, I think you need the insurance to protect the most important asset in the company. I mean Navision of course.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
It would be nice to have 5.0 executables, and three new export buttons in the toolbar (btw I think they might be reprogrammed so it would be really user friendly solution
Regards,
Slawek.
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
Thanks for the healthy conversation, but it's not my license nor my company. This was a client I worked for in the past that approached me to assist with this problem. I agree with the upgrade recommendation, but without extra $$$ to play with and not under maintenance can get real $$$.
So I agree that upgrade recommendation is the best course of action, but understanding there policy I can't see that happening anytime soon.
Thanks
I believe there is a granule you can purchase that that will add excel functionality to all reports. You will need a developer's license to run to as it requires exporting the report to a text file. Ask your solution center about it.