First post, so be gentle!
I am relatively new to SQL and SSRS and have self taught myself so this may be a simple question, asked by a simple person!
What is the difference between Snapshots and Cached Reports? I have a report that contains high volumes of data and takes our management team a few minutes to run each time.
What I would like to do is provide them with a more efficient way of accessing this data and I am hoping either a Cache or Snapshot can help so that when they come to run their report(s) each day, they are only accessing / filtering on the data already extracted.
Whats the best way to handle this? Is it possible to run the cache / snapshot with all parameters selected and then just allow the users to filter out the data they dont want, without having to execute the full report again?
Apologies if I've explained it really badly - as I said, I'm new to SQL and SSRS!
Thanks in advance for reading.