Iff[TableName.FieldName]= "TEXT" then print BOLD

[Rickinrsm]

Paradox 7.

I have a table with 7 fields placed in the report footer using the table tool.

The first field will have different company names. I need a specific name in that field to print in bold when it shows up.

What I do, using the field tool is create one additional field (calculated) that I place directly on top the field in the table frame. Then I define field, check calculated, and start with IIF([TblName.FieldName] etc. See below. However when I select the field name from the drop down list the summary box selection for some reason is "count" and I can't change this in the Summary box. If I change it in the calculated field section I get an error message "Invalid reference . . ."
This is the calculation in that field to get the result of BOLD PRINT SPECIFIC NAME No wild cards:

IIF([TblName.FieldName]="SMITH COMPANY IRVINE","SMITH COMPANY IRVINE","")

This works fine in the record band but no in the report footer for some reason.

Any assistance would be greatly appreciated. Rick

 

[TonyMcGuire]

If that field is from the same table as in the record band, then what you are seeing in the report footer is correct.

What field value (record) would you have Paradox display? It can't know what record to use from the record band to fill that calculation.

Tony McGuire

http://forums.tonymcguire.com

 

[Rickinrsm]

Hi Tony. No, the fields in the record band are from a different table.

In the report footer is a small table filled with data generated from queries as variables. Simple numbers and an office name for each set of numbers. Usually a total of less than 10 records!

Why is it that when I use the field tool to create a new field in the report footer that when I select define field, select the calculated box, and then select the field name, the SUMMARY drop down list at right identifies the field as "count?" When I first define the fields in the table frame the SUMMARY box says "None." Somewhere in here lies the problem. Any ideas . . . Rick