Solved

SSRS 2005 How to repeat group in table

Posted on 2011-09-23
14
371 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
Major Incident Management Communications

Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.

 

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

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

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

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…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

688 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