I am using Crystal Report7 with VB. I am using external report (ie .rpt. Not Crystal report designer in VB) and Access as the database. There I made a query for which parameters are passed from VB. In VB I mentioned the query as Stored Procedure using Command object. I execute the query and the result is a set of records that I display in a data grid in the same form. Now I want to display the records in the grid to crystal report.
My query is an union query. I have assigned the datasourse property of the grid in a ADO object. But how to use this ADO object in the report? I tried to create the report using .ttx file. But how to replace the ttx fields with ADO recordset dynamically?
My query is an union query. I have assigned the datasourse property of the grid in a ADO object. But how to use this ADO object in the report? I tried to create the report using .ttx file. But how to replace the ttx fields with ADO recordset dynamically?