Calculated field problem

[TonyG57]

I have created a calculated field which I use OK in reports. It does not show in the list of available fields using the 'Find/sort Assistant'.It is based on two other calculated fields, but neither of those appear in that list. Can anyone tell me why? - I shall waste a lot of paper printing useless mailing labels if I cannot use the field this way!
TonyG

 

[paulbent]

I'm guessing it includes a summary calculation and therefore will only evaluate in Print Preview when placed in a report summary panel.

It may be possible to simulate the calculation by aliasing the table and joining the aliases. A calc field can summarise a field in Table:2 with summary option "All records in Table:2". When the calc field is placed on a form based on Table:1, it will evaluate in Browse and should be sortable.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[Guest_imported]

If this involves summary calculations then read on, otherwise I can't help...

You should be able to use a Find on the View (not the Find/Sort Assistant) as long as the following are true:

1-The calculation allows a "Summarize on:" option (not grayed out) in the field definition dialog, Define Summary tab.

2-The find is performed while in Print Preview.

Cautionary note: The "Summarize on:" option may have to be set for the specific summary panel where the field is located. Generally, using "Summary panels where this field is placed" works but be aware that you may have to change it.

If it's a compound calculation using other summary calcs (i.e. Total Sales/Total Qty) then you have to trick the field into thinking it's a summary calculation so you can define the appropriate "Summarize on:" option (see #1 above and cautionary note). Thought it doesn't appear to make sense, most times you can use SMax(existing formula) because there is only one value in the panel to calculate anyway.

If you want to run the find in a macro, don't forget #2 above.

Experiment with this and if you have any other questions just ask...

Regards,

Keith Seeley

 

[TonyG57]

I have just returned home from a holiday and found the replies to my query. Many thanks to Paul and Keith for their help - I will be checking out the suggestions and come back again if I still have problems.
Tony Grimley