Outputting a Report to Excel - for dummies

Business Central/NAV Developers Forum
21

Hi,

I was in the process of converting a report to excel. This link helped me a lot to convert the report to excel. The only issue I am facing is, the integer value is getting rounded off. I tried with few possibilities but couldn’t get. Can anyone help me what has to be changed to get the exact value without rounding off in the excel.

22

Along with transforming report to excel, How do i have Header Information (eg:-Company details) in excel.

23

Put the Header information under the presection of the main table.

I use variables in the CAL/Globals - Text Constants.

For numbers I use the FORMAT Command turned number to a text and it keeps all the decimal values.