Export to Excel Report Reverse Rows In to Column

sameer_79

Hi all,

I am using Nav 4.3,
Can anyone help me????
My report format is like this

Vehicle No. : ABC
Date Qty.
1 23.00
2 34.00
3 32.00
4 45.00
i want when goes to excel it looks like this format

1 2 3 4
ABC 23.00 34.00 32.00 45.00

any one tell me how i can do this???????????????



regards

sam

rmpatel22

Define record variable for Table 370 (Excel Buffer) (With Temprery=Yes) in your report.

Then generate excel file by calling appropriate methods of this Table like,

CreateBook
OpenBook
CreateSheet
CreateRangeName
GiveUserControl
ReadSheet
SelectSheetsName
FilterToFormula
NextValue
SumIf
GetFormulaUnitErr
GetExcelReference
ExportBudgetFilterToFormula
AddToFormula
GetFormula
SetFormula
ClearFormula
NewRow
AddColumn
StartRange
EndRange
CreateRange
AutoFit
BorderAround
ClearNewRow
SetUseInfoSheed
AddInfoColumn
UTgetGlobalValue

Regards,
Rakesh Patel