I haven't used XI yet, but I've seen it done in 9, with a custom function. I was able to perform individual SELECTs for each field on the report. Of course I had to check to see if non-SELECTs worked as well... they did. This was on a Labware LIMs system.
~Thadeus