Report Services: Possible to have two row groups? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Report Services: Possible to have two row groups?

Author

Topic

Maxer
Yak Posting Veteran

51 Posts

Posted - 2007-07-30 : 16:06:32

In old school COBOL Reports you'd often see a header row that would be something like
Line1: CustomerID
Line2: Customer Name
Detail1: 0156784613
Detail2: Jane, Doe

Can that be done with reporting services?

If I have a group in a table, can I make that group cover two rows?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-07-30 : 16:07:56

Yes that can be done in the header.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

Maxer
Yak Posting Veteran

51 Posts

Posted - 2007-07-30 : 16:50:56

I should have elaborated, can I do that with the detail line as well?

I don't see how to actually do that in the reprot, so that my detail line is two rows "high" so I can have:
Detail1(row1): Fields!CustomerID
Detail2(row2): Fields!CustomerName

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-07-30 : 17:06:20

Yes you can do that. But I think you would use the column from your data set and use that in the field. You can use the same column multiple times.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

Maxer
Yak Posting Veteran

51 Posts

Posted - 2007-07-30 : 17:54:10

So then I can't do that with rows, just with repeating columns?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-07-30 : 17:58:27

Yes you can do it with rows. Perhaps you need to show us exactly what you are doing. Just us a sample result set of the dataset, your header and your detailed section. Show what it should be doing too.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

Maxer
Yak Posting Veteran

51 Posts

Posted - 2007-07-30 : 21:21:58

Ok so I have:

CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState

I want it to display:
Row1 - CustomerID, CustomerName
Row2 - Customer Address
Row3 - Customer City, State, Zip

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-07-30 : 21:34:25

So just stagger your fields in the detail section of the report. There's nothing that says that they all have to be on the same line of the report.

I've got one report that probably has 10 lines for each row.

Are you getting an error when you put them on more than one line?

Tara Kizer
http://weblogs.sqlteam.com/tarad/

Maxer
Yak Posting Veteran

51 Posts

Posted - 2007-07-31 : 08:29:47

Ok thanks, got it worked out.

Some sort of odd user error on my part, I'm able to add rows just fine now. Not sure why I couldn't before.

Thanks.

-I don't suppose you know how to make multiple tabs/pages in a report?

Basically so a report can have a "cover page" and then the actual report after that?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-07-31 : 11:47:45

I believe you would just setup page breaks in the report.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources