You may have to create in your application a loop using a variable (number of times to use the datarow  in the dataset). Then run the report against it.  I am thinking the solution might further end up being using the variable to run the query the number of times and populate (append) the dataset with the row from each run of the query.

Hey it always comes down to what works. Thanks for letting us know how you solved the problem. Someone else can use it or build from it.