You can create a subscription that delivers a document based on the
original report to a library within the same SharePoint site as the
original report. You cannot deliver the document to a library on
another server or another site within the same site collection. To
deliver the document, you must have Add Items permission on the
library to which the report is delivered.
i would like to note "you cannot deliver the document to a library on
another server or another site within the same site collection"
if the above is ok than you need to make sure you follow this:
Point to the report in a library.
Click the down arrow next to the report, and select Manage
Click Add Subscription.
In Delivery Extension, select SharePoint Document Library.
In Document Library, select a library within the same site.
In File Options, specify the file name and title for the document that
will be created by the subscription.
In Output Format, select the application format.
Web archive (MHTML) is the default because it produces a
self-contained HTML file, but it will not preserve interactive report
features that might be in the original report.
In Overwrite Options, specify an option that determines whether
subsequent deliveries overwrite a file. If you want to preserve
previous deliveries, you can select Create a file with a unique name.
A number will be appended to new files to create a unique file name.
In Delivery Event, specify a schedule or event that causes the
subscription to run. You can create a custom schedule, select a shared
schedule if one is available, or run the subscription whenever the
data is refreshed for a report that runs with snapshot data.
In Parameters, if you are creating a subscription to a parameterized
report, specify the values that you want to use with the report when
the subscription is processed. The parameters section is not visible
on this page if the report you select does not contain parameters.