Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Multi row records in reports Expand / Collapse
Author
Message
Posted Tuesday, November 6, 2012 3:55 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 6:30 AM
Points: 46, Visits: 229
Hi Guys,

Despite searching, I haven't been able to find any info on how to go about displaying records in multiple rows. ( I dont mean the cangrow property )

Id like to display a report in the formatting below:

Contact Date Time Subject
Notes Notes Notes Notes Notes Notes Notes Notes Notes Notes Notes Notes
Notes Notes Notes Notes Notes Notes Notes Notes Notes Notes Notes
Notes Notes Notes Notes Notes Notes Notes Notes Notes Notes Notes
....

Where the Notes then used the entire row and expanded as required.

Could anyone point me towards some documentation \ tutorial on how to do this?

Thanks

Donald
Post #1381476
Posted Tuesday, November 6, 2012 3:57 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:55 PM
Points: 13,357, Visits: 10,222
It looks a lot like a newsletter style report (at least for the notes field).

http://blog.hoegaerden.be/2012/11/01/creating-multiple-column-reports/




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1381477
Posted Tuesday, November 6, 2012 6:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 6:30 AM
Points: 46, Visits: 229
Koen Verbeeck (11/6/2012)
It looks a lot like a newsletter style report (at least for the notes field).

http://blog.hoegaerden.be/2012/11/01/creating-multiple-column-reports/


Hi Koen,

Thanks for the reply.

I took another look at grouping in SQL Reporting 2005 and managed to sort it out.
Post #1381545
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse