<div>
The use of {} is necessary ? try without...<br />

</div>


The use of {} is necessary ? try without...


<div>
If you can't get Crystal Reports to accept the nvl syntax you want, then create a view that has the nvl's and select from the view in Crystal Reports instead of from the base table(s).<br />

</div>


If you can't get Crystal Reports to accept the nvl syntax you want, then create a view that has the nvl's and select from the view in Crystal Reports instead of from the base table(s).


<div>
I don't want to create a view. How would I achieve null value substition out in the formula editor of crystal reports for the following<br />
nvl ({STOCKWAREHOUSE.BEGINNING<wbr />COUNT},0) &nbsp;+nvl({STOCKWAREHOUSE.QTYRE<wbr />CEIVED},0)<wbr /> &nbsp;-<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; nvl({STOCKWAREHOUSE.QTYISS<wbr />UED},0) +<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; nvl({STOCKWAREHOUSE.ADJUST<wbr />MENTS},0)<br />

</div>


I don't want to create a view. How would I achieve null value substition out in the formula editor of crystal reports for the following
nvl ({STOCKWAREHOUSE.BEGINNINGCOUNT},0)  +nvl({STOCKWAREHOUSE.QTYRECEIVED},0)  -
                nvl({STOCKWAREHOUSE.QTYISSUED},0) +
                nvl({STOCKWAREHOUSE.ADJUSTMENTS},0)


<div>
<div class="content wysiwyg-content">
In crystal reports , the function NVL is not being recognized,<br />
nvl ({STOCKWAREHOUSE.BEGINNING<wbr />COUNT},0) + nvl({STOCKWAREHOUSE.QTYREC<wbr />EIVED},0) &nbsp;- nvl({STOCKWAREHOUSE.QTYISS<wbr />UED},0) + nvl({STOCKWAREHOUSE.ADJUST<wbr />MENTS},0)<br />
In crystal reports how would I solve the problems of Null value substition?<br />
<br />
Help
</div>
</div>


In crystal reports , the function NVL is not being recognized,
nvl ({STOCKWAREHOUSE.BEGINNINGCOUNT},0) + nvl({STOCKWAREHOUSE.QTYRECEIVED},0)  - nvl({STOCKWAREHOUSE.QTYISSUED},0) + nvl({STOCKWAREHOUSE.ADJUSTMENTS},0)
In crystal reports how would I solve the problems of Null value substition?

Help

Oracle &amp; Crystal Reports &amp; NVL Function

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle &amp; Crystal Reports &amp; NVL Function

Oracle & Crystal Reports & NVL Function