Grouping in Export To Excel Problem

Nehapr
Nehapr Member Posts: 59
edited 2012-08-22 in NAV/Navision Classic Client
Hi all,
I am doing period Called Summary outstanding Report,Here I am Grouping Sell to Customer No. Feild ,so while preview report everything is coming correct but in export to excel in Grouping i am getting 0 for some custer No.
Ex :
Custmer No. 47563218
28/01/2011 101017 1928-W ST.MORITZ Storage Unit/Drawers 2 1,894 3,409.20
28/01/2011 101017 1964-W INNSBRUCK Storage Unit/G.Door 1 1,617 1,455.30
28/01/2011 101017 1976-W INNSBRUCK Storage Unit/W.Door 1 1,418 1,276.20

Custmer No. 49525252
24/01/2011 101019 1908-S LONDON Swivel Chair, blue 1 147.468 280.19
24/01/2011 101019 1928-S AMSTERDAM Lamp 1 42.535 80.82
24/01/2011 101019 70102 Paint, blue 1 3.239 6.48

Custmer No. 49525230 0

Custmer No. 49525263
23/01/2011 101015 1972-S MUNICH Swivel Chair, yellow 3 147.468 884.81
23/01/2011 101015 1968-S MEXICO Swivel Chair, black 3 147.468 737.34
23/01/2011 101015 1896-S ATHENS Desk 6 776.422 9,317.06
23/01/2011 101015 1906-S ATHENS Mobile Pedestal 6 336.392 4,036.70

so can anyone tel me how can i sort this problem in export to excel....

Regards,
Neha

Comments

  • Sog
    Sog Member Posts: 1,023
    yeah, without code its rather hard to help you.
    However, if you receive 0 for some customers, debug your code and see if the records are exported to excel at the right moment.
    Make sure the filters and other business rules are applied correctly before the record is exported. (It might have something to do with code in the onpre section and post-section.
    Also remember to use calcfields for flowfields before exporting
    |Pressing F1 is so much faster than opening your browser|
    |To-Increase|
  • vijay_g
    vijay_g Member Posts: 884
    If you have written your code on sections(hopefully on groupfooter) for excel and that particular section printing value fine(not printing zero value) then add this code before calling your excel code. 
    IF (CurrReport.SHOWOUTPUT) AND ExportToExcel then begin
Your excel code......
END;
    Hope this will help you..
  • Nehapr
    Nehapr Member Posts: 59
    Dear Friends,
    Thanks for replying me and help me to sort my problem....
    I have solved my problem ,actually the problem was Document type should be filter in properties or in coding ,since Document type was not filter it was showing all records irrespective of Datefilter and grouping too ...




    Thanks&Regards,
    Neha

Categories