Method:Classic General Q&A

Re: Report Conditional Formatting

Blake C — Tue, 03 Jan 2012 22:55:22 GMT

Yeah, I wound up doing it the way you are suggesting.

Kind of a pain, but it works. Thanks!

Method_Michael — Tue, 03 Jan 2012 22:49:01 GMT

Blake-

With Formatting Rules you can't dynamically set text on a label you can only change its apperance.

What you could do is stack 2 labels on each other and use Formatting rules to only show the appropriate label.

Something along the lines of:

Condition: [FieldInTable] = False

Visible: False

Also when you create a Formatting rule don't forget to actually apply it to a label, intially when you create one it doesn't automatically apply.

The other alternative is to use a vb script in the Scripts > BeforePrint event found in the property grid, though this is a bit more advanced.

-Michael

Blake C — Tue, 03 Jan 2012 22:28:46 GMT

I have a label on a report and I want it to read either 'Turf Program' or 'Estimate' based on a Yes/No field for the current record.

Can I do this using the Formatting Rules for the label?

What would the Condition look like? I've tried a few diff. combos but can't seem to set the label text dynamically.

Thanks