I want to load the Data Report Module (say rptTest.Dsr), that has been created by the VB-program at run-time based on the data fields to be displayed depending upon the users SQL query (that is the record set). Since the Data Report Designer is of no use when the recordset that is to be retrieved is unknown in a general type of database application, the best method is to create the file say, rptTest.Dsr at run time and then load this by the VB program itself. Afterwards the following statesments can be used to display the Report:

    Set rptTest.DataSource = rs   'i.e the recordset retrieved
    rptTest.Show vbModal
    rs.Close