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.
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
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.