Solved

SSRS 2005 How to repeat group in table

Posted on 2011-09-23
14
368 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
  • 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

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 500 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

770 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