Populating TTX and displaying on Report

I call a Stored Procedure from VB form inorder to retrieve data from the database and create its ADO recordset from the Output of Stored Procedure . I am able to do this .

But how can I possibly populate a TTX file with the required data and Invoke a report based on this TTX file. How should I proceed with the task.

Or ,if there is any other better way to do this task as I am working with CR9 ,please do let me know.

Since this is urgent, I will really appreciate your help.

Thanks