There's at least two ways to achieve that, but the best option is to use proper
SELECT
statement, as is shown below:
DECLARE @tmp TABLE(product_type VARCHAR(5))
INSERT INTO @tmp (product_type)
VALUES('a'), ('a'), ('a'),
('b'), ('b'), ('c'),
('c'), ('c'), ('c'),
('d'), ('d'), ('d')
SELECT product_type, CASE WHEN product_type = 'c' THEN 'a'
WHEN product_type = 'd' THEN 'b'
ELSE product_type END AS product_type1
FROM @tmp
ORDER BY product_type1
Result:
product_type product_type1
a a
a a
a a
c a
c a
c a
c a
d b
d b
d b
b b
b b
Got it?
Another way is to add
formula field[
^] which will do the same as SQL statement.
=IIf(Fields!product_type.Value ="c", "a", IIF( Fields!product_type.Value ="d","c", Fields!product_type.Value))
To get information about grouping data in ReportViewer, please see this:
Grouping Data in a ReportViewer Report[
^]