asked
SSRS Report Builder Grouping
Hi, I am a newbie to this SSRS report builder 3.0 and is stuck over this simple grouping thing. I did group my report based on Account group. Now inside this report builder, I want to group the first three account group (000, 100, 110) together, then the next 2 (120, 140) together and so on. Then give the total for each groups of account group. I.E my report should produce something like this: Account Group 000 100 110 total 120 140 total . . . Grand total Any help is really appreciated as I am stuck on this for hours now. ![alt text][1] [1]: /storage/temp/1332-untitled.png
Never Mind, I figured out. I had to define the code in the report property first. Thanks anyways
You can create parent group with group expressions as illustrated here:
http://technet.microsoft.com/en-us/library/bb630426.aspx
Thanks Venkat, Appreciate your reply. Like you said, I created a new Parent Row Group and and tried to create a group expression as mentioned in the link you provided (Group By many age ranges). When I run the report, it keeps complaining that Name "code" is not declared. For your reference my group expression is: =Code.AccountGroup(Fields!ACCOUNT_GROUP.Value) Function AccountGroup(ByVal ACCOUNT_GROUP As Integer) As String Select Case ACCOUNT_GROUP Case 0 To 100 AccountGroup = "First Account Group" Case 101 To 200 AccountGroup = "Second Account Group" Case Else AccountGroup = "Rest of the Account Groups" End Select Return AccountGroup End Function
14 People are following this question.
