• I would suggest using SSIS for this.

    First create a subscription for the report that writes the data to a text or csv file.

    Create an SSIS package to read the file and import it into the table.