Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tking1
Starting Member
22 Posts |
 Posted - 2010-05-25 : 10:46:38
|
| Hi, I'm pretty new to SQL Server, and am developing monthly reporting for my department using Report Services/BIDS. Part of my results need to be based on project statuses at the time the report runs. I need to be able to "lock in" those values for each month in a matrix, so that each time the report runs, the results are updated only for the "current" month. Any input on how I can accomplish this?I'm sure this is a newbie question and there's an easy solution? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-05-25 : 11:33:36
|
| I assume you want the results for each month never to change. If this is the case, save the results into another table and grab all previous months from there, you can use UNION to then put them in the same result set as your current results.. |
 |
|
|
tking1
Starting Member
22 Posts |
Posted - 2010-05-25 : 11:42:19
|
quote:
Originally posted by RickD
I assume you want the results for each month never to change. If this is the case, save the results into another table and grab all previous months from there, you can use UNION to then put them in the same result set as your current results..
Thanks for your reply Rick. That's a good idea, however I don't have write access to the DB containing my data. Other options/suggestions?Thx in advance! |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-05-27 : 04:06:44
|
Save the table to a database you do have write access to.. Otherwise, I can't think of a sensible way to do it, there are a few non-sensible ways, like output the results to a file each month and read from that, but really think you should get write access to one table created for the purpose of completing this report. State the business case for this requirement and you should get the access.. |
|
|
|
|
|
|
|
|
Monthly Reports - lock previous results?