?
Solved

SSRS 2005 How to repeat group in table

Posted on 2011-09-23
14
Medium Priority
?
372 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
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.

 

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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

764 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