Hi, in Telerik Report Designer, I want a text box on my report to display the word chicken, but only if the value of another item, fields.name, begins with the letters apple so there would need to be a wildcard after the e in apple. If fields.name is anything else then I don't want the word chicken to show up on the report.
I'm new to the product and used to "Print When" logic.
Thanks
2 Answers, 1 is accepted
Rank 1
Iron
Figured it out mostly, but I don't know how to make the filter not be case sensitive.
Does anyone know how to not make it case sensitive?
I add a text box, right click, conditional formatting, add a rule, add 2 filters, the wildcard goes at the end %.
Then under the "Style" part click "Layout" then uncheck the box for "Visible"
So the "E0781......" will only print if the drug name begins with FLUORO or MILRIN
Hi, Francisco,
Indeed, if you want to control the visibility of a certain TextBox Report Item based on the value of another report item, it is suitable to use Conditional Formatting like you described.
If you want to make the condition case insensitive , it is suitable to use the text function ToLower:
I have prepared a sample .trdp report for your reference. The report shows a collection of books and the "Chicken" TextBox Report Item is visible only for the book "Stories".
I hope you find this information helpful. Please, let me know if there is anything else I can assist you with.
Regards,
Dess | Tech Support Engineer, Principal
Progress Telerik