Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SSRS 2005 How to repeat group in table

Posted on 2011-09-23
14
Medium Priority
?
375 Views
Last Modified: 2012-05-12
I have this report created by someone else and I need to insert another row that belongs to Group1. If you look at the screen shot you will see he has Group 1 already repeating 4 times. How did he do that and how can I continue to add yet another Group 1?
RepeatingGroup.jpg
0
Comment
Question by:rwheeler23
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 7
14 Comments
 
LVL 9

Expert Comment

by:edlunad
ID: 36587638
If this is for SSRS 2000 or 2005 you just need to right click over the row handle and select Insert Group.

more details here...

SSRS 2000
http://technet.microsoft.com/en-us/library/aa179430(SQL.80).aspx

SSRS 2005
http://technet.microsoft.com/en-us/library/ms156487(SQL.90).aspx



0
 

Author Comment

by:rwheeler23
ID: 36587905
Yes, but when I do that it now inserts group 2 and group 3 etc. How do get it to insert another line for group 1?
0
 
LVL 9

Expert Comment

by:edlunad
ID: 36588707
so if you insert another group in the middle of the 4 groups you will get a group named "2" in there?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 

Author Comment

by:rwheeler23
ID: 36588999
Yes, I do not see how he was able to get all 4 of them to be in group 1. Even though I named them Table1_Group1
0
 
LVL 9

Expert Comment

by:edlunad
ID: 36589088
what will be the problem if you leave it named as group 2?
0
 
LVL 9

Expert Comment

by:edlunad
ID: 36589098
Did you group by the same field as the other groups?
0
 

Author Comment

by:rwheeler23
ID: 36589287
Yes, everything is exactly the same. Should I attached the rdl?
0
 

Author Comment

by:rwheeler23
ID: 36589300
The real problem was I was trying to get the heading above the table to appear on every page. Right now it only appears on the first page. I thought if I could add more groups and drop each text box onto each row that would be the way to do that.
0
 
LVL 9

Expert Comment

by:edlunad
ID: 36589346
If you can attach the rdl that will help.
0
 

Author Comment

by:rwheeler23
ID: 36589570
Print-RFQs.rdl

Here itr is
0
 
LVL 9

Expert Comment

by:edlunad
ID: 36590024
well I have SSRS 2008 and in there all looks like one big group, so I just added a couple of extra lines in the header and detail section, probably that works to you if you are able to open it...
Print-RFQs.rdl
0
 
LVL 9

Accepted Solution

by:
edlunad earned 2000 total points
ID: 36590052
Have you tried to right click over the details section and select "Insert Row Above" or Below
0
 

Author Comment

by:rwheeler23
ID: 36590213
When I get back I will check thisvout. Thank you.
0
 

Author Closing Comment

by:rwheeler23
ID: 36601487
Apparently this is simple to do in SSRS 2008 but a bear in 2005.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question