How to highlight memo when value is null

JuhasJuhas
edited 6:26AM in FastReport 4.0
Hi, I tried very hard, but haven't worked it out.

In my database I have a datetime field(named firstIn). And it can be null.
When it's null I want to highlight a memo.

So, I check the memo, go into highlight editor, I chose desired color and then:

<frxDBDataset."firstIn"> = null - doesn't work, none of the records are highlighted
ValidDate(<frxDBDataset."firstIn">) = false - doesn't work. Every record is highlighted
<frxDBDataset."firstIn"> = '' - doesn't work. I get conversion error
DateTimeToStr(<frxDBDataset."firstIn">) = '' - doesn't work. None of teh records are highlighted

I tried also trim function with DateToStr.
So what should I do?

Comments

  • SchehlSchehl
    edited April 2009
    Look at your datasource perhaps the field is numeric 0 or similar depends on datasource
  • gordkgordk St.Catherines On. Canada.
    edited 6:26AM
    see my reply to the same post in the news group

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport 4.0Comment As ...

© Vanilla Keystone Theme 2024