I need to create 3 different groups in my report, based on a condition:
Group 1 - AccountNumber like '400%'
Group 2 - AccountNumber like '42%' and '43%'
Group 3 - AccountNumber = '47100'
Can someone tell me how and where in SSRS I do this and what the syntax should be?