Sep 04, 2015 01:38 AM|Krunal Parekh|LINK
Is this how you also want to render the report or just when you export to the excel? If you want to render and export it same like this. then I would suggests that in your tablix you set the datasource and format the blanks on the sql it self I mean where
ever you need the spaces just put those columns null in the SQL server. you wont be needing to format anything on SSRS if your dataset looks like this.