Special Feild RecordNumber

[mgreer]

In the footer of my reports I have a the Special
Field RecordNumber. My problem is when no records are returned RecordNumber still displays 1. I would like for it to display 0 instead of 1.

 

[kenhamady]

This surprised me, but here is a simple workaround. Create the following formula using a field that is always filled in, like any system field:

if IsNull({Your.field}) then 0 else RecordNumber

This will print 0 when no records are returned, but will print the recordnumber otherwise. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[mgreer]

Ken,

That's how I have it working now and it works fine, I guess I was just hoping there was a better workaround or some other function that I didn't know about.

Thanks for your help!

 

[kenhamady]

Nope, that is how it works.

I have seen this 'dummy' record come up with formulas on the detail band. Many formulas will print one instance on the detail band even when there are no records. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal