<div>
There are a few different ways...but try this first.<br />
<br />
Go to SELECT EXPERT....choose your field....then ....choose formula.<br />
<br />
In the formula type:<br />
<br />
NOT ISNULL({yourtable.field})<br />
<br />
Then close with OK....Crystal will pull in ALL fields that are NOT NULL.<br />
<br />
MIkeV
</div>


There are a few different ways...but try this first.

Go to SELECT EXPERT....choose your field....then ....choose formula.

In the formula type:

NOT ISNULL({yourtable.field})

Then close with OK....Crystal will pull in ALL fields that are NOT NULL.

MIkeV

<div>
You can also do this by using hardcoded SQL SCRIPT as your datasource...<br />
<br />
Or...<br />
<br />
You can use CONDITIONAL PRINTING in your report to only allow items that are NOT NULL.<br />
<br />
...<br />
<br />
MIkeV
</div>


You can also do this by using hardcoded SQL SCRIPT as your datasource...

Or...

You can use CONDITIONAL PRINTING in your report to only allow items that are NOT NULL.

...

MIkeV

<div>
<div class="content wysiwyg-content">
How do you remove blank or null fields from report formats (Crystal 9) in the report output versus seeing a blank line in your report? I'm creating a report format based on residential and business adrress'. Some addresses contain more than one line for address info. (ex: John Hancock Tower, 200 Clarendon St, Boston, MA. 02120). If the line containing &quot;John Hancock Tower&quot; is blank or null, how can I remove the space it gives me in the report output??<br />
-Mackbully2
</div>
</div>


How do you remove blank or null fields from report formats (Crystal 9) in the report output versus seeing a blank line in your report? I'm creating a report format based on residential and business adrress'. Some addresses contain more than one line for address info. (ex: John Hancock Tower, 200 Clarendon St, Boston, MA. 02120). If the line containing "John Hancock Tower" is blank or null, how can I remove the space it gives me in the report output??
-Mackbully2

Removing Crystal blank or null fields address info

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

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.