help in report

If I understand you. You want to dump the generated data of a report to a excel file (search the word "Excel" in this forum)? Or can you explain much further.

Crate a dataport. Process data, transfer it to excel & by using Automation Control of Excel in Dataport surely u will be able to make it uneditable.

I think there are 2 simple and out of the box ways to work with Excel (although you can also write your own automation code if you want).

Option 1: Use Excel Buffer (Table 370)
This table already has functions in it to create a work book, export data to excel, read data from excel. There are 2 reports - Import & Export Budget from/to Excel (Reports 81 and 82) that use this table and should provide a good example of how to work with the control.

Option 2 (Nav 5.0 Only): Use Templates
With the newest version of Navision you can build a template and use the built in function button on the menu bar to export data to excel.

I've built solutions based on that method in the past and I can't say I'm a big fan of them.

If the user is concerned about presentation of the numbers then I try to build a "pretty" report for output to either PDF or a printer. If the user is going to be analyzing the numbers then I export data to Excel for them to use and analyze how they see fit.

Furthermore when exporting to excel I tend to export information in it's rawest, ungrouped and unfiltered form. If there were any aggregation functions performed in a presentation version of a report...I think the Excel output should skip it. This leaves the decision of grouping, sorting, analyzing and printing the data entirely up to the user in excel.