Solved

SSRS 2005 How to repeat group in table

Posted on 2011-09-23
14
370 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
Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

 

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

726 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