You’re offline. This is a read only version of the page.
580
| Based on the date column will create dynamically(aggregate function I used) | Date from | 01-01-2016 | |||
| Date To | 31-12-2018 | ||||
| Report | 2016 | 2017 | 2018 | ||
| How to count the value based on the year (Count A) ????? | Count A | 1 | 2 | 3 | |
| =SUM(IIf(Fields!FieldA.Value<>"ABC",1,0)) how to check the year dynamically | Count B | 3 | 2 | 1 | |
| Total | 4 | 4 | 4 |
*This post is locked for comments
In SSRS you can create a Calculated Field that uses the Year function to get the year from a date column. You can then use this Calculated Field in the report. For the output you want, you can create a Column Group based on this field
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (