Grand Total 1

[savok]

Ok i use a special field record number to get a grand total but if nothing is selected it still shows up as 1 and not 0. What can i do to change that?

 

[MalcolmW]

You are summing the record number? Malcolm

 

[kenhamady]

This is a 'feature' of the way they increments the recordnumber in CR. Instead create a formula field that says:

if IsNull({AnyField}) then 0 else Recordnumber

Use this in place of the recordnumber in your report. Ken Hamady

http://www.kenhamady.com/

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

 

[savok]

That did the trick, thanks a lot