<div>
I have other formula's on the this report and as soon as I put this formula on the report it eliminates the other two formula's.<br />
<br />
They are &nbsp;attached below.. the formula above and below reference two different tables.<br />

<pre><code id="code-499724">IF {Customer.LAST_VISIT} in DATE (1982, 01, 01) to DATE (2009, 11, 14) THEN COUNT ({Customer.VISITS}) &gt; 0


IF {Customer.LAST_VISIT} in Date (1982, 01, 01) to Date (2009, 11, 21)   THEN COUNT ({Customer.VISITS}) &gt; 0
</code></pre>
</div>


I have other formula's on the this report and as soon as I put this formula on the report it eliminates the other two formula's.

They are  attached below.. the formula above and below reference two different tables.


IF {Customer.LAST_VISIT} in DATE (1982, 01, 01) to DATE (2009, 11, 14) THEN COUNT ({Customer.VISITS}) > 0


IF {Customer.LAST_VISIT} in Date (1982, 01, 01) to Date (2009, 11, 21)   THEN COUNT ({Customer.VISITS}) > 0


<div>
I added this date filter is that correct?<br />

<pre><code id="code-499726">if {HRO.STATUS} = &quot;C&quot; AND {HRO.PAY_DATE} in DATE (2009, 11, 15) to Date (2009, 11, 21) then

{HRO.TAX_PARTS}+{HRO.NTX_PARTS}+{HRO.TAX_LABOR}+{HRO.NTX_LABOR}+{HRO.TAX_SUBLET}+{HRO.NTX_SUBLET}+{HRO.SUPPLIES}+{HRO.ST}-{HRO.DISP}-{HRO.DISL}-{HRO.DISS}

else 0
</code></pre>
</div>


I added this date filter is that correct?


if {HRO.STATUS} = "C" AND {HRO.PAY_DATE} in DATE (2009, 11, 15) to Date (2009, 11, 21) then

{HRO.TAX_PARTS}+{HRO.NTX_PARTS}+{HRO.TAX_LABOR}+{HRO.NTX_LABOR}+{HRO.TAX_SUBLET}+{HRO.NTX_SUBLET}+{HRO.SUPPLIES}+{HRO.ST}-{HRO.DISP}-{HRO.DISL}-{HRO.DISS}

else 0


<div>
yes it works..glad if i cud help
</div>


<div>
<div class="content wysiwyg-content">
Right now I am making a formula<br />
<br />
What would the correct formula for Crystal be where add all the fields above and then say I need a filter for this formula where HRO.STATUS = C?<br />

<pre><code id="code-499705">{HRO.TAX_PARTS}+{HRO.NTX_PARTS}+{HRO.TAX_LABOR}+{HRO.NTX_LABOR}+{HRO.TAX_SUBLET}+{HRO.NTX_SUBLET}+{HRO.SUPPLIES}+{HRO.ST}-{HRO.DISP}-{HRO.DISL}-{HRO.DISS}

AND {HRO.STATUS} = &quot;C&quot;
</code></pre>
</div>
</div>


Right now I am making a formula

What would the correct formula for Crystal be where add all the fields above and then say I need a filter for this formula where HRO.STATUS = C?

Access Query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

Crystal Reports

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.