How can I get two rows for the same record using SSRS?

Question

How can I get two rows for the same record using SSRS?

NineIron

SSChampion

Points: 12529
More actions
April 26, 2016 at 5:03 am

#306849

I have a report with too many columns to fit onto a landscape format. Is there a way to "divide" the record up to create two rows for the same record?

Viewing 7 posts - 1 through 6 (of 6 total)

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

Neil Burton SSC-Insane Points: 22923 More actions · Answer 1

NineIron (4/26/2016)
I have a report with too many columns to fit onto a landscape format. Is there a way to "divide" the record up to create two rows for the same record?

You could create a group for each row and put some of the columns underneath. You might need to group on more than one column to get a unique row but that trick has worked for me in the past.

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

Spiff SSCertifiable Points: 7766 More actions · Answer 2

Right click your Detail row and Insert a row "Inside" the group.

NineIron SSChampion Points: 12529 More actions · Answer 3

I tried that but, I have 12 columns to group on and it doesn't look good. I was thinking of a subreport but, I don't know how to get the report to show for each record separatly.