newbieSSRS
Programmer
Hello ,
I am fairly new to SSRS and my table data has a Regdate with year, month and day values( eg 2020, 01-Aug and 01-Aug-2020)
I want to be able to collapse the dates like when i clcik the year, it opens the months and when i click on months it opens the days.
I have tried creating 2 fields as calculated fields =FORMAT(fields!regdata.value, "MM-YYYY") and =FORMAT(fields!regdata.value, "DD-MM-YYYY") in the same dataset.
But this does not display data at all.
Kindly help!
I am fairly new to SSRS and my table data has a Regdate with year, month and day values( eg 2020, 01-Aug and 01-Aug-2020)
I want to be able to collapse the dates like when i clcik the year, it opens the months and when i click on months it opens the days.
I have tried creating 2 fields as calculated fields =FORMAT(fields!regdata.value, "MM-YYYY") and =FORMAT(fields!regdata.value, "DD-MM-YYYY") in the same dataset.
But this does not display data at all.
Kindly help!