Modifying Report text with Formula Tool

bazerkaX

Hello,

I am attempting to create a condition based on Report Text existing to affect the layout of a report i've created.

Problem: 

The output no longer functions properly and only displays code instead of "Text - View Browse Tool Report Tab"

I've attached a few images better illustrating my problem.

1. There are OOS Titles, and OOS Tables. 

2. A formula was created -// if isnull([OOS Table]) then "" else [OOS Title] endif  

3. Previously this worked properly, creating a blank on the layout if the condition is met. 

I believe this is something to do with the formula / data types or even the table that the formula is based off of. 

The Data type is V-WString

1.PNG

2.PNG

3.PNG

patrick_digan

@bazerkaX I think you can work around this issue. I would connect your last report text tool right to the layout tool. Once you have your layout tool setup, then change it back it back to the way you have it where the formula tool connects to the layout tool. The layout tool will complain about bad data, but the output should work as expected. I'm attaching an example in case that helps. I suspect that the layout tool is checking the source field of the metadata. 

Test Report Tools.yxmd