Tquery and clientdataset

Hi all,

I have a little problem that I hope you can help me with

I have a Tquery that is running a sql select statement, this works fine !! I then link my reporting tool to the query and it works fine !

However i have been asked to add a total column at certain points through the output.

This caused me a problem so what I thought is that I could attach my reporting tool to a clientdataset instead. Then use a while loop to go through the tquery copying the data into the clientdataset and also adding the total column where required.

BUT I just can’t initialise the Clientdataset and copy the data across. Anyone got any ideas ???? I have been told that it can be done but I just can’t figure it out !!!!

Any help would be fab !!!!!

Thanks
John

What is the reporting tool used?
I had to do something similar, but I did it inside the report.

The reporting tool is RBuilder, i cant seem to find a way of doing it inside the report builder.

Thanks
John