SSRS report builder 2.0 store STATIC DATA to use to query results
Does any one know if there is a way to import a spreadsheet into report
builder 2.0 and then use my data set to make calculations against.
This might seem like a novice question as my limited experience of report
builder does not help.
The reason i want to do this is so that i don't have to have my main
data-set run the query on working out averages of hundreds of thousands of
records as it take ages to run. by having the benchmark average data
static i would want to run my query and do the calculations in report
builder which will make it a 100 times faster.
Thank you for your time in advance
