How can i create an ssrs report from the following table
Table DML
DBName
Count1
Count2
Count3
Count4
RecordDate
Report should be like this..
Select ReportYear(dropdown box for year from RecordDate Column)
DBName
Jan Feb Mar April......Dec
Count1 344 234 534 432....
Count2 543 675
Count3 324 234
Count4 984 865
Total Jansum Febsum