Visual Studio - Report Builder Current/Previous Month

Question

I'm new to the application and kind of learning on the fly. I'm trying to build a report In Visual Studio where the data is pulled from SQL Management Studio. The report has three columns. One lists different types of Purchases (Direct, Telephone, NSCC, etc), and the next columns are trying to get to sum up the those purchases based Current month, and the other column based on Previous month.

I'm guessing I need to build something as an Expression. Tricky part is the date data from SQL is in a very messy "yyyy-mm-dd hh:mm:ss.xxx" format. Any help on how to achieve this will be greatly appreciated.

Answer 1

Hi @Mills, Tim W，

You may use sql query to format the date when loading data from sql database.

Ex:

SELECT 
  FORMAT(DateColumn, 'yyyy-dd-MM') AS FormattedDate
FROM YourTable;

Or you may use SSRS expression to format as you want.

=Format(Fields!ModifiedDate.Value,"dd/MM/yyyy")

=FORMAT(Fields!ModifiedDate.Value,"MM-dd-yyyy")

-- Current month
FORMAT(GETDATE(), 'MMMM yyyy') AS CurrentMonthName,
-- Previous month
FORMAT(DATEADD(MONTH, -1, GETDATE()), 'MMMM yyyy') AS PreviousMonthName

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.