I'm thinking it is possible with a Format Trigger, but I've only ever returned (TRUE) or (FALSE). I am very new to Oracle Reports Builder. Thanks.
create as many label as your need and control with the code..
/*true means display, false means don't display */ if your_criteria_or_condition is ok then return (TRUE); else return (FALSE); end if;
InoL wrote:Yes! i agree.
If you use the wizard the column headers are created as fixed text items. No way to change that.
So, you have to remove the text items and replace them with fields that use some column in your data model as source. That is how I create reports all the time. There is never any fixed text, all text is retrieved in the data model.
Alternatively you can use the format trigger model. Just place different text items on top of each other and return TRUE or FALSE to display the correct label.