• From: Indonesia, Bogor
  • Registered: 11/02/2010
  • Posts: 4

Topic: Error while reporting in excel (rep103) - second row don't appear

Dear FA guru ...

i have problem when reporting to excel format, especially when reporting to Sales -> Customer -> Customer Detail Listing (rep103.php)

it produce report correctly when format is exported to PDF, but it generate error when produce XLS format. there are error window dialog said 'File error: data may have  been lost'. with OK button in bottom.

if i click OK button, then report sometime appear, and sometime not appear in some computer.
when report appear, it just 'show' first row every record. it contain 'customer name', 'price list type', 'customer branch name', and 'customer address'

it does not 'show' second row above, for example 'phone number', 'fax number'.

could you help me please.

i use front accounting 2.2.11 on windows (XAMPP) environtment.

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Error while reporting in excel (rep103) - second row don't appear

You are right, you encountered a bug.
The problem has been fixed in release 2.3 final. If you want to fix it in 2.2.11, you can download the new file from 2.3 RC3 here and copy from line 193 and forwards until the commented out text (about line 235). Finally comment the same lines as in this new file.



You CANNOT replace your file with this one entirely.

/Joe

  • From: Indonesia, Bogor
  • Registered: 11/02/2010
  • Posts: 4

Re: Error while reporting in excel (rep103) - second row don't appear

thank you joe for your response ...
but maybe you forgotted to include function get_branch_contact() instead ya ? wink

i'm looking for that function bro ..

thanks aniway. wink

  • From: Indonesia, Bogor
  • Registered: 11/02/2010
  • Posts: 4

Re: Error while reporting in excel (rep103) - second row don't appear

dear FA guru ..

i've adding function get_branch_contact() by myself on top of rep103.php bellow

function get_branch_contacts($branch_code = 0) {
    $sql = "SELECT ".TB_PREF."cust_branch.*
    FROM ".TB_PREF."cust_branch
    WHERE ".TB_PREF."cust_branch.branch_code = ".$branch_code;
   
    return db_query($sql,"No transactions were returned");
   
}

please correct me if i'm wrong, it's running well on my machine .. wink

thanks aniway for your re-code on rep103.php wink

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Error while reporting in excel (rep103) - second row don't appear

Yes, that was needed in release 2.2.X. There is another approach in release 2.3.

/Joe

  • From: Indonesia, Bogor
  • Registered: 11/02/2010
  • Posts: 4

Re: Error while reporting in excel (rep103) - second row don't appear

thank you for your great application and your quick response joe and the others FA guru's ... wink

  • saeed
  • New member
  • Offline
  • Registered: 04/06/2011
  • Posts: 4

Re: Error while reporting in excel (rep103) - second row don't appear

i have problem as un readable characters in excel exported report found. can some one helps me i am using Version 2.3.2 Build 13.01.2012