• Registered: 09/18/2014
  • Posts: 5

Topic: How to make a report in FA? (Newbie)

Hi, I am still inexperienced with how to make a report in FA. I am done with a payroll module and I need to show the payslip, but I really have no idea how. I kept searching about possible leads but still I haven't got any of the slightest clue where they put the SQL statements for the report. Thank you very much for your help.

2 Reply by apmuthu (edited by apmuthu 09/24/2014 11:14:20 am)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: How to make a report in FA? (Newbie)

Use the standard functions in the */includes/db/*.inc files or roll your own in your module and include them in the report. If such SQLs are going to be used exclusively in the specific report only, make the wrapper function in the report itself or use it inline.

Study the existing reporting/repXXX.php files and the variable input form parameters file reporting/reports_main.php.

If you wish to have your own class of reports (Reports and Analysis Menu), then append it to the first stanza in reporting/includes/reports_classes.inc:

// Standard report classess
define('RC_CUSTOMER', 0);
define('RC_SUPPLIER', 1);
define('RC_INVENTORY', 2);
define('RC_MANUFACTURE', 3);
define('RC_DIMENSIONS', 4);
define('RC_BANKING', 5);
define('RC_GL', 6);

define('RC_PAYROLL',7); // <------ Added now

apmuthu's Website