Hi David,I am trying to split a row of data into two when displaying it by a report control. I can do that in the API but it will put a heavy process load onto server which I am trying to avoid and push as much as possible to the client side.Please see the queries below on what I am trying to achieve:I am trying to display this
"SELECT A, B FROM TABLE UNION ALL SELECT A, C FROM TABLE ORDER BY A"
From
"SELECT A, B, C FROM TABLE"
This way I will have B and C in two rows which allows me to display them a nicer a more readable manner in the report control.
So I am trying to display below in the report control:
| A | B |
| A | C |
| A | B |
| A | C |
From a HTTPCLIENT response that is returning:
| A | B | C |
| A | B | C |
Thanks for your help.