Taking what Luis put together, you can hide these rows by adding an isVisable column to your dataset. Then, for the Row Viability setting in SSRS use an expression that makes the row hidden when isVisable = 0.

-- sample data that represents your data

DECLARE @yourTable TABLE (someid int identity, col1 varchar(100));

INSERT @yourTable(col1) SELECT TOP (20) newid() FROM sys.all_columns;

-- adding an isVisable column

WITH yourdata AS

(

SELECT col1, ROW_NUMBER() OVER ( ORDER BY someid ) AS rn

FROM @yourTable

)

SELECT

rn,

col1,

isVisable = CASE WHEN yourdata.rn % 10 NOT IN (4, 8) THEN 1 ELSE 0 END

FROM yourdata;