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-05 : 20:14:17
|
| How to display amounts on the basis of date in SSRS without making it a parameterized report. I would just want to display amounts for march month on my tablix properties. How should I do it? |
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-06-05 : 20:16:23
|
| Also can I add a filter on the tablix properties I would want it to update it every month. Let's say if I want March now, next month should display April. Is there an expression for this? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-05 : 21:11:49
|
| you need to add a column group based on date field in your tablix for displaying data based on date values. Second question is not clear. Are you asking about adding a data filter which changes dynamically based on current date value?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-06-05 : 21:26:52
|
| Thanks Visakh I just solved. I added a date filter on my tablix property and passed a between operator and displayed the result set. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-05 : 21:32:20
|
| Oh ok...cool------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Date issue