I am creating a chart inside my SSRS table. In my table I have ClaimAccount, Quantity, BillingDate and ChargeComments. I am creating a report that groups on ClaimAccount. But for a few accounts there are multiple records per month so I want to split out those reports while grouping the others. ChargeComments has project details that can use for grouping. Specifically, I want to group on the part of ChargeComments that starts with a slash and all the way to the last letter of the string. This section of the string is variable length.
How do I add a group in SSRS based upon this section of ClaimAccount that starts with a slash?
ClaimAccount BillingDate ChargeComments
000450 01012018 DOIXM/agribix2348 this is one group
000450 01012018 CIXMS/bourlagzip7 this is one group
000520 01012018 DASFALKG/zip3 this is one group
000520 02012018 DASFALKG/zip3 this is part of the group above because it has the same ClaimAccount and same BillingDate