Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditionally Suppress Text Box Drop Shadow With Formula

Status
Not open for further replies.

dazum

Technical User
Apr 6, 2011
57
US
I have a date formula in the Group Header of a report that shows if the date falls within the date parameters. I put the date within the text box and conditionally made the background of the textbox CrSilver if the date formula was not null. It worked by using the below formula:
If not isnull {@Date}
then
CrSilver
else
CrNoColor;
There is an "Drop Shadow" option for the textbox also, and I tried condtionally suppress the drop shadow with the same formula as above, but I get the error "The Formula Result Must Be A Boolean". Without somehow suppressing the Drop Shadow, it shows when {@Date} is null.
How can I suppress the Drop Shadow when {@Date} is null?
I am using CR 11.
 
You would conditionally SHOW the dropshadow, using a formula like this in the x+2 box next to the dropshadow option:

not isnull({@Date})

-LB
 
Thanks lbass!
I tried your suggestion and it's now giving me the Drop Shadow when I want it to show.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top