Export To Excel when groupheader is involved

aliennav
aliennav Member Posts: 449
edited 2010-06-28 in NAV/Navision Classic Client
Hi All
I am converting a report to excel.
Everything is running fine except when it comes to groupheader, in excel, it is printing 2 times.
What mght be the proble??

Comments

  • Saalek
    Saalek Member Posts: 181
    Hi

    Do you conditioned your code ???
    currreport.showoutput(currreport.totalscausedby=fieldno(-- the field--));
If currreport.showoutput then
  begin
     -- code to excel -- 
  end

    Bye
  • aliennav
    aliennav Member Posts: 449
    Yes I have done that.
  • aliennav
    aliennav Member Posts: 449
    aliennav wrote:
    Yes I have done that.
    still gettin the same prob.
  • ufuk
    ufuk Member Posts: 514
    Put a variable like i in this section and check how many times it's displayed. If it is same with excel then check if group structure is true. (Lastfieldno, totalscausedby etc.)
    Ufuk Asci
    Pargesoft
  • aliennav
    aliennav Member Posts: 449
    ufuk wrote:
    Put a variable like i in this section and check how many times it's displayed. If it is same with excel then check if group structure is true. (Lastfieldno, totalscausedby etc.)

    But when I run the report in NAV it is getting printed only once.
  • ufuk
    ufuk Member Posts: 514
    I am not sure of the section type but once I had this problem too and I've moved code to another section or a dataitem then problem solved.
    Ufuk Asci
    Pargesoft

Categories