Unable to copy and Past into Excel

elmarfv · 2006-06-28

Hi guys,

I am having a problem with form 408 "G/L Balance by Dimension" in version 4.0. I used to be able to copy from the form directly into Excel, but now I only get the headings of the fields, but not the value of them. Is there a setup I am missing or is this the way the new Navision works now?

ara3n · 2006-06-28

works fine on 4.0 Sp2 client.

kriki · 2006-06-29

[Topic moved from Navision Attain forum to Navision forum]

johnson_alonso · 2006-06-29

It should be work too in NAV 4.0. I think there is maybe something worng with the header (filter functions) or codeunit. this following C/AL coding I copied from my editor:

SetCommonFilters(AnalysisViewEntry);
AnalysisViewEntry.FIND('-');
AnalysisViewToExcel.ExportData(
AnalysisViewEntry,LineDimCode,ColumnDimCode,ShowOppositeSign,
ShowInAddCurr,AmountField,PeriodType,ShowColumnName, DateFilter,GLAccFilter, BudgetFilter,
Dim1Filter, Dim2Filter, Dim3Filter, Dim4Filter, AmountType, ClosingEntryFilter, ShowActualBudg, BusUnitFilter);

C/AL Local:
Name DataType Subtype Length
AnalysisViewToExcel Codeunit Export Analysis View
2. etc.

Rgds,
Johnson

http://sea-navision-community.blogspot.com
mailist:
sea-navision-community-subscribe@yahoogroups.com

Unable to copy and Past into Excel

Comments

Categories