How to Convert all the data to Excel in Nav 5.0

sadynamics

Hi Experts,

In Nav 5.0 there is an option to send the whole information to excel and word. what is the code behind that.i dont have license to that... could you please tell me that ?

is it possible to do the same in Nav 3.7 ?

tinoruijs

sadynamics wrote:

Hi Experts,

In Nav 5.0 there is an option to send the whole information to excel and word. what is the code behind that.i dont have license to that... could you please tell me that ?

is it possible to do the same in Nav 3.7 ?

Do you mean the data from all tables?
What are you trying to achieve?

You could go to object designer, open a table, ctrl+a, ctrl+c, wait until it's done and paste it in Excel.
Or use odbc.

sadynamics

Hi,

i know that can be copied by using Ctrl+c but i need in that way in nav 5.0. Suppose if you are viewing vendor information say x, if i need all the data of vendor x like invoicing, communication, posting etc. if i click the button in Nav 5.0 (symbol of Excel and word) all the details are copied to excel in seperate sheets how that possible ? is it possible to do that same in Nav 3.7 ?

Hope this clarifies you...

tinoruijs

Ok. That clarifies it.

No, it's not possible in 3.7.
In NAV 5.0 it is the new stylesheet-functionality.

If you want it in 3.7, you will have to do a lot of customization.

sadynamics

Oh... That's fine... Thank you for the reply.. Could you please tell me about style sheet ?

tinoruijs

sadynamics wrote:

Oh... That's fine... Thank you for the reply.. Could you please tell me about style sheet ?

There's a lot of info about Style Sheet on this site. Just use "Search the forum".
Or press F1 and search in NAV 5.0.