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.
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.