I have been trying to get my data to display correctly in a table but I am struggling.

I have data comming in from a data source, Stream Name, FlowComputerName, GrossVolume, StandardVolume, Mass, NsVolume.

The way we have our current report is to group by the FlowComputerName field and use text to identifuy the field. e.g

FC1

"Gross Volume" : GrossVolume Value
"StandardVolume" : StandardVolume Value
"Mass" : Mass Value
"NsVolume" : NsVolume Value

FC2......etc

"Gross Volume" : GrossVolume Value
"StandardVolume" : StandardVolume Value
"Mass" : Mass Value
"NsVolume" : NsVolume Value

So pretty standard but I want to be able to do this on a table and I cannot seem to get it to work. I have looked at cross tab but I cannot seem to get it to work? I can do a seperate cross tab table for each field but that seems a bit long winded?

Is there anyway that I can get it to look like

FC1 FC2
"Gross Volume" | GrossVolume Value | GrossVolume Value
"StandardVolume" | StandardVolume Value | StandardVolume Value
"Mass" | Mass Value | StandardVolume Value
"NsVolume" | NsVolume Value | StandardVolume Value

My problem is I don't have individual tags that i can just drop on to a table due to the nature of the data collector which i ahve no control over? so basically i'm just trying to change the way the existing data is displayed.


I hope someone can help, even if it si just a link to where the information i have missed is located.

Thanks
Kris