SSRS will not display the text. It expects a dataset with the predefined columns.
Since the resultset doesn't contain any rows, it will show an empty report.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP