Found Count

[Sixdots]

On my FM 5.5 I have this merged field on my layout that shows the following

Record 1 of 6533

Found 533

It comes from 3 Calculated fields

Status(CurrentRecordNumber)

Status(CurrentRecordCount)

Status(CurrentFoundCount)

I am trying to do this on a layout in FM 8 with no sucess

Thank you in advance

Dave

[Raybaudi]

Status(CurrentRecordNumber) = Get ( RecordNumber ) or merge directly the "@@" symbols

Status(CurrentRecordCount) = Get ( TotalRecordCount )

Status(CurrentFoundCount) = Get ( FoundCount )

[Sixdots]

Thank you very much

When I tried the Get Functions they would not work,

I then noticed that my old functions were unstored calculations after I changed the calculations to unstored it worked great

Thank you for taking the time to help me out

Dave

Edited February 26, 2006 by Guest

[LaRetta]

Hi Dave,

This is an example of when Custom Function is handy (since you have Advanced). You can create ONE custom function and just call it within each table (as unstored text calc). Going by the example you gave, you could have CF called RECORD BAR (with no parameters)

"Record " & Get ( RecordNumber ) & " of " & Get ( TotalRecordCount ) & ¶ & Get ( FoundCount ) &

If ( Get ( FoundCount ) < Get ( TotalRecordCount ) ; " Found" ; " Total" )

It will speed up your development, add consistency for your Users and best of all, if you decide to change it, you will only have to do so in the Custom function itself. I also add the Sort state to the mix (since I remove Status Area). You can use it directly in a calc in each table without CF also. By combining your three calculations, your Define Fields will also be shorter (YAY). You would then just place the field directly on the layout (or place a merge field of the ONE calc).

LaRetta

[Sixdots]

Hello LaRetta

Thank you for the information. I set it up as a custom function and it worked great. I had not used the custom function feature before, I learned something new.

Thank you

Dave

[Raybaudi]

"Record " & Get ( RecordNumber ) & " of " & Get ( TotalRecordCount ) & ¶ & Get ( FoundCount ) &

If ( Get ( FoundCount ) < Get ( TotalRecordCount ) ; " Found" ; " Total" )

Simple and handy :)