Forum Discussion
Solved
Getting Dates from Data into a Report Builder Report
Greetings. I'm building a report in Report Builder. The source data is formatted like this: Date Scenario Type Type Sort Amount 6/30/2024 Actual Revenue 1 50,000.00 ...
I think I have figured out a solution.
For the Actual Last Year, I used MIN(Date), which, right now, is 6/30/24. For the three This Year columns, I'm using First(Fields!Date.Value, "DataSet1"). For future years, I'm taking the MIN(Date) and adding 2, 3, 4, etc. then adding the 6/30 portion.
I think I have figured out a solution.
For the Actual Last Year, I used MIN(Date), which, right now, is 6/30/24. For the three This Year columns, I'm using First(Fields!Date.Value, "DataSet1"). For future years, I'm taking the MIN(Date) and adding 2, 3, 4, etc. then adding the 6/30 portion.