Print an empty row in SSRS

Question

Print an empty row in SSRS

Mark Beringer-730383

SSCommitted

Points: 1824
More actions
June 17, 2008 at 7:49 am

#187117

Hi
I have a SSRS report that has a table with a few columns. The data is sorted by the 'Asset Group' column. I want to display an empty row after each new 'Asset Group'.
Anyone know how this can be done?
Regards
MB

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95460 More actions · Answer 1

Add an extra row (detail or group as appropriate). Just don't put any fields in it. Watch out for the data wrapping across pages.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Mark Beringer-730383 SSCommitted Points: 1824 More actions · Answer 2

Ah thanx, that was pretty easy, just added a group with a group header with no text. 🙂