Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ElQueso
Starting Member
4 Posts |
 Posted - 2005-03-31 : 17:54:58
|
| Help me! I'm in hell!I have a parent list that has a child list embedded within it.The parent list is set to group on a certain field in the data set. The parent list has a couple of fields specific to that grouping, then contains a row of text boxes with labels that are meant to be headers for the child list. I also have a line control that runs under the header text boxes.I've set the RepeatWith property for the header text boxes and the text boxes that contain the parent grouping information to the name of the child list. From everything I can tell, this is supposed to force these items to repeat on the next page if the rows from the child list spill on to the next page.The line repeats on the next page, but the text boxes containing the header labels and the fields for the parent group data DON'T.Any ideas? I'm fairly new to Reporting Services, so I'm sure I'm leaving out something simple... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-31 : 18:51:26
|
| I think in order for this to work that you are going to need to setup the child list as a separate report and have it embedded in the main report as a subreport. You can get to the subreport option in Visual Studio in the toolbox.Tara |
 |
|
|
ElQueso
Starting Member
4 Posts |
Posted - 2005-03-31 : 18:57:47
|
| Yeah - Just before I came back to see if there were any responses, I found this on MSDN:"RepeatWith cannot be used within a data region, subreport, or rectangle that contains a data region or subreport."I missed that the first time around.To be honest, I can't believe there is this limitation!I'm not even sure if using a subreport is going to work in this case, because I would still need my grouping for my parent list...It seems that I might need to use a Table with headers and footers, and put a Subreport in the detail? Then I can make the headers repeat on a new page, I think. Yuck.Am I the only one that needs to repeat group headers on another page when the group detail runs to another page? I've looked everywhere for people having this problem and haven't seenmuch at all. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-31 : 19:00:09
|
| Yes you would put the subreport in the detail. This is what I have done for a few reports thus far.Tara |
|
|
|
ElQueso
Starting Member
4 Posts |
Posted - 2005-03-31 : 19:01:53
|
| Cool - thanks for the help :) |
|
|
|
|
|
|
Repeating Group Headers