Report snapshot

• Jason Marshall

  SSCommitted

  Points: 1791

  More actions

  December 15, 2010 at 8:42 am

  #232097

  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

• adam.pittman

  SSC Rookie

  Points: 32

  More actions

  December 15, 2010 at 3:40 pm

  #1263203

  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