<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — How to make a report in FA? (Newbie)]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=5196&amp;type=atom" />
	<updated>2014-09-24T11:09:49Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=5196</id>
		<entry>
			<title type="html"><![CDATA[Re: How to make a report in FA? (Newbie)]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=20963#p20963" />
			<content type="html"><![CDATA[<p>Use the standard functions in the <strong>*/includes/db/*.inc</strong> 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. </p><p>Study the existing <strong>reporting/repXXX.php</strong> files and the variable input form parameters file <strong>reporting/reports_main.php</strong>.</p><p>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:<br /></p><div class="codebox"><pre><code>// Standard report classess
define(&#039;RC_CUSTOMER&#039;, 0);
define(&#039;RC_SUPPLIER&#039;, 1);
define(&#039;RC_INVENTORY&#039;, 2);
define(&#039;RC_MANUFACTURE&#039;, 3);
define(&#039;RC_DIMENSIONS&#039;, 4);
define(&#039;RC_BANKING&#039;, 5);
define(&#039;RC_GL&#039;, 6);

define(&#039;RC_PAYROLL&#039;,7); // &lt;------ Added now</code></pre></div>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2014-09-24T11:09:49Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=20963#p20963</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[How to make a report in FA? (Newbie)]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=20957#p20957" />
			<content type="html"><![CDATA[<p>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&#039;t got any of the slightest clue where they put the SQL statements for the report. Thank you very much for your help.</p>]]></content>
			<author>
				<name><![CDATA[harell286]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19638</uri>
			</author>
			<updated>2014-09-24T05:26:43Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=20957#p20957</id>
		</entry>
</feed>
