A report usually regards more than one record.
You are talking about single fields, which belong to a single record, so we need to know what the report is showing.
Merely talking about interface, I would not like to see a report with some lines and a field which sometimes is a discount and other times is a rollback price. I would have to interpret each line.
IMHO having 2 fields side by side, one of which is empty sometimes, is better, because we do read by columns when we have them.
Ok, so it is actually a catalogue and I think I figured it out.
On the Discount Price field, under conditional formatting, Formula is: not IsEmpty ( Master File::Rollback Price ). Then I set the text to white.
Thanks for the quick reply.
1 of 1 people found this helpful
if your filemaker version supports it, hide when is better than conditional formatting white from a performance pov.
Oh really? I never thought of that option. Is your suggestion a better way? Performance?
instead of going for the field content, applying a style to it and drawing it (white, in your case), with hide when filemaker won't even bother dealing with it. That's some miliseconds gained
You could accomplish what you describe with conditional hiding rather than conditional formatting. From what you describe, it sounds as if the Discount Price field is never empty, but the Rollback Price field is. So:
1. Set up the Discount Price field on your report layout with the condition, Hide object when: not IsEmpty ( Rollback Price )
2. Make these two fields the same size, and directly over one another, with Discount Price above
3. To enable you to enter the Rollback Price on this layout, make Rollback enterable and Discount Price not enterable
The effect will be that you will see the Discount Price if the field below it is empty, but when you click on the field, you will click through the upper field directly into the lower one, and as soon as you enter a value there, the upper one will disappear.
This approach would work as well.