December 15, 2010 at 8:42 am
I need to make a report non-refreshable (i.e. refresh the data once a month and keep it static throughout that month). Ideally, I would like the refresh to be triggered by a T-SQL command from a different server. Is this possible?
Thanks,
Jason
December 15, 2010 at 3:40 pm
Jason,
I am not sure if this is the best solution, or even if it suits your particular requirements, but what jumped to my mind was:
1. Create a special table that will hold only the data contained in your report.
2. Create a stored procedure that:
a. Deletes the contents of this table.
b. Inserts all of the report data.
3. Create a job on your other server that triggers the stored procedure.
That way, even though the report will technically be "refreshable," refreshing the report will not actually put a huge burden on your server (which is what I assume is your purpose for making the report non-refreshable -- I could be wrong).
My two cents.
Adam
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply