SSRS add Page Group to Existing Report without Report Wizard
I'm net to SSRS and need to add a page group to an existing report. I know you can accomplish this when creating a new report throug the Report Wizard (Job Field in Example Below) but need to now add a page group to an existing report. I need the final results to to be like the screenshot below. In the existing report i am working with i already have the phase and Cost Type groups but am now trying to add the Job "Page Group" so the final results are like the example below. Any help on this will be greatly appricated. RYAN PRICE
June 5th, 2012 3:01pm

Hello Ryan Price, Thanks for posting out your problem on our forum. You want to insert the page group manually in the existed report. Based on my experience, it is a difficult way to achieve this goal. We can try the next steps. In the existed report, we need insert a new table without the header. In addition, the table only has one column. When you create the table, it will generate the Row Groups automatically.Click the automatically Row group in the bottom, and select "Group Properties".In the General tab of popup dialog, we need add Group Expression to make the table Group on Job.In the Page Breaks tab, we select the item "Between each instance of a group".In the Sorting tab, we insert the Sort by column to Job.Click OK to save the changes.Delete the default text box in the cell of the table and insert the Rectangle control.In the rectangle, insert the textbox control and set the value as [Job].Insert the remaining content table in the report. If you have any questions about this issue, please let me know. Regards, EdwardEdward Zhu TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
June 11th, 2012 10:59am

Ryan, Wanted to add this too in case it helps...I was trying to do the same thing and found little to no documentation on how to do this. Since I think it's silly to be required to use a Wizard, I played around and finally found this to work: -Insert a "List" from the Toolbox next to your existing report design (mine was a Matrix). -Delete the "=(Details)" from the Row Groups area of this List. This will turn your List into a Rectangle. -Drag your existing Matrix into the Rectangle. -Drag the field you want to Group from your dataset into the Row Group area of the Rectangle -Since you want that Group to appear at the top of each page and NOT in the Matrix body, delete that newly inserted Group column but select "Delete column only" when prompted. -Add a text box at the top of your Rectangle design and then insert the Field Value you want to Group on into that text box -Finally, to break each page at the Group, go into your Group properties and set the Page Break options. There's probably more elegant ways to do this but this gave me exactly what I wanted and I think meets your requirement too.
June 11th, 2012 1:00pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics