Since you want to transform 1 row of data into multiple rows of report detail, as long as the number of fields is constant you could probably do it in a formula. In the formula you would need to set variables to the values you desire (the variables would be 'in order') and then you could display the variables on their own lines or one line, however you choose, but this might not work depending on what else you want the report to do.
That is how I would start to attack the problem, the final solution might not look like this, but it is a start.
Depending on what else the report needs to do, you might want to think about writing a stored procedure so that your one line of data becomes several with the desired data in its own line.
Hope this helps.
IP Logged
