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 |
|
Joshrinn
Posting Yak Master
118 Posts |
 Posted - 2012-06-06 : 14:07:40
|
| Hi,I have a matrix. There are values for sept through dec. what I would like to do is with te help of an expression leave sept month blank and put the values currently displaying in sept to October, currently displaying in October to nov and currently displaying in nov December. If you could write a code with an imaginary field it would be great. Or if there is some other way to do it it's fine as well. Please help ASAP |
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-06-06 : 14:11:48
|
| In the expression field I put =first(fields!fieldname.value, "dataset") But that would change all the values as same as sept which is not how I wanted |
 |
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-06-06 : 15:00:07
|
| Also how can I add another column to store previous month values in the dataset. Can I do it with the help of a query or in the dataset itself? |
|
|
|
|
|
|
Problem assigning values in SSRS