Skip to Content
0
Former Member
Apr 08, 2016 at 09:00 PM

It is possible to show a text or field on DW with different colors (or effects) on the same string?

134 Views

Hi,

I have a request to show a group of field values, concatenated on a string, separated by "/" but each value may have a different color or bold or italic inside the same string, all inside a DW. Each color or effect, denotes a different status.

For example:

Field1, field2, ... from header table and numbers from a detail table.

record1 field1 field2 1028/1029/1030/1035 field3

record2 field1 field2 1010,1011/1012/1013 field3

1015/1016/1017/108

record3 field1 field2 1050 field3


Is there a way to do this? I have the an SQL server database function to create the text required, but I no idea about format values inside a string.


Is not a RTE datawindow, it is a report with columns, totals, etc. Can not use a line per detail. Records already show some grouping requirements.


I will appreciate any other suggestion for a presentation of such data.


Regards

Alfredo Santibáñez