SSRS 2005 How to repeat group in table

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
rwheeler23Asked:
Who is Participating?
 
edlunadConnect With a Mentor Commented:
Have you tried to right click over the details section and select "Insert Row Above" or Below
0
 
edlunadCommented:
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
 
rwheeler23Author Commented:
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

 
edlunadCommented:
so if you insert another group in the middle of the 4 groups you will get a group named "2" in there?
0
 
rwheeler23Author Commented:
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
 
edlunadCommented:
what will be the problem if you leave it named as group 2?
0
 
edlunadCommented:
Did you group by the same field as the other groups?
0
 
rwheeler23Author Commented:
Yes, everything is exactly the same. Should I attached the rdl?
0
 
rwheeler23Author Commented:
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
 
edlunadCommented:
If you can attach the rdl that will help.
0
 
rwheeler23Author Commented:
Print-RFQs.rdl

Here itr is
0
 
edlunadCommented:
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
 
rwheeler23Author Commented:
When I get back I will check thisvout. Thank you.
0
 
rwheeler23Author Commented:
Apparently this is simple to do in SSRS 2008 but a bear in 2005.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.