Personally, I like to write report SQL within a Stored Procedure, and just call the SP within the report.
This allows me to test that the correct data is being retrieved, independantly of the report. It also helps me realise that any problems with rendering that data are due to the report design. Both things tend to keep me on the right path when dealing with SSRS.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara