This is just to illustrate the concept outside of SSRS

Create table #temp (

colA tinyint,

colB tinyint,

colC tinyint,

colD tinyint,

colE tinyint,

colF tinyint,

colG tinyint,

colH tinyint

)

/* inssert some test data into our table */

insert into #temp

SELECT 1,2,3,4,

floor((rand()*100)),

floor((rand()*100)),

floor((rand()*100)),

floor((rand()*100))

GO 7

insert into #temp

SELECT 8,6,5,4,

floor((rand()*100)),

floor((rand()*100)),

floor((rand()*100)),

floor((rand()*100))

GO 3

--/*[optional] take a look at the data --> */ SELECT * from #temp

/* output */

select distinct colA, colB,colC,colD

from #temp

;

-- drop table #temp