<div>
Yep - that's exactly what I wanted - and thanks for the emphasis on the suppression side - makes perfect sense. 
</div>


Yep - that's exactly what I wanted - and thanks for the emphasis on the suppression side - makes perfect sense.

<div>
<div class="content wysiwyg-content">
Hi my background is as a developer in PeopleSoft apps. I am fairly new to Crystal reports (using version 9) since I would normally write an SQR. However, Crystal is a very capable tool andI have an opportunity to use it more - so I want to. So far though I am finding very limited online resource for syntax help etc (happy to receive site or book recommendations!).<br />
<br />
Anyway, to my current problem. I have a subreport which uses a formula for a &nbsp;heading . The formula is based on a simple count of rows - like this.<br />
<br />
IF Count(queryname) &gt;&nbsp;0 Then <br />
&quot;heading text&quot; + Clientnamefromquery<br />
Else<br />
&quot;Alternative heading text&quot;<br />
<br />
When there are rows, the formula works. When there are no rows it seems Crystal doesn't even get to the formula, so is there a better way to display the &quot;Alternative heading text&quot;?<br />
<br />
Thanks in advance!
</div>
</div>


Hi my background is as a developer in PeopleSoft apps. I am fairly new to Crystal reports (using version 9) since I would normally write an SQR. However, Crystal is a very capable tool andI have an opportunity to use it more - so I want to. So far though I am finding very limited online resource for syntax help etc (happy to receive site or book recommendations!).

Anyway, to my current problem. I have a subreport which uses a formula for a  heading . The formula is based on a simple count of rows - like this.

IF Count(queryname) > 0 Then 
"heading text" + Clientnamefromquery
Else
"Alternative heading text"

When there are rows, the formula works. When there are no rows it seems Crystal doesn't even get to the formula, so is there a better way to display the "Alternative heading text"?

Thanks in advance!

Change heading inside a subreport when the subreport returns now rows.

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.