FrontAccounting forum — Error while reporting in excel (rep103) - second row don't appear

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

null@example.com (saeed) — Tue, 31 Jan 2012 09:59:55 +0000

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

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

null@example.com (yudhiapr) — Thu, 04 Nov 2010 07:19:33 +0000

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

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

null@example.com (joe) — Wed, 03 Nov 2010 07:48:13 +0000

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

/Joe

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

null@example.com (yudhiapr) — Wed, 03 Nov 2010 02:16:52 +0000

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 ..

thanks aniway for your re-code on rep103.php

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

null@example.com (yudhiapr) — Tue, 02 Nov 2010 22:18:56 +0000

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

i'm looking for that function bro ..

thanks aniway.

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

null@example.com (joe) — Tue, 02 Nov 2010 09:18:03 +0000

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

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

null@example.com (yudhiapr) — Tue, 02 Nov 2010 07:50:59 +0000

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.