Standard Deviation Logic

Question

Need some ideals. I have data and i want to create a standard deviation base off of the data. Im going to give you a example below:
I want to  take the values  and produce a standard deviation report by test via each parameter, im using microsoft reporting services rdlc  when th id is 1, thats a indication that test started
over. Take a look the output im trying to produce below under "OutPut"  what would the best way to go about this

Raw Data:

ID	Test	Param	Values
1	Apple	Black	3
2	Apple	Orange	4
3	Apple	Yellow	1
4	Apple	Blue	5
5	Apple	Red	3
1	Apple	Black	1
2	Apple	Orange	2
3	Apple	Yellow	5
4	Apple	Blue	5
5	Apple	Red	2
1	Grapes	Black	2
2	Grapes	Orange	3
3	Grapes	Yellow	1
4	Grapes	Blue	4
5	Grapes	Red	4
6	Grapes	Purple	2
7	Grapes	Violet	3
8	Grapes	Green	1
9	Grapes	RedOrange	2
10	Grapes	PurpleBlue	3
11	Grapes	DarkGreen	4
1	Grapes	Black	2
2	Grapes	Orange	3
3	Grapes	Yellow	1
4	Grapes	Blue	4
5	Grapes	Red	4
6	Grapes	Purple	2
7	Grapes	Violet	3
8	Grapes	Green	1
9	Grapes	RedOrange	2
10	Grapes	PurpleBlue	3
11	Grapes	DarkGreen	4

"OUTPUT"

ID	Test	Param	Values	Values	StdDev
1	Apple	Black	3	1	?
2	Apple	Orange	4	2	?
3	Apple	Yellow	1	5	?
4	Apple	Blue	5	5	?
5	Apple	Red	3	2	?
1	Grapes	Black	2	2	?
2	Grapes	Orange	3	3	?
3	Grapes	Yellow	1	1	?
4	Grapes	Blue	4	4	?
5	Grapes	Red	4	4	?
6	Grapes	Purple	2	2	?
7	Grapes	Violet	3	3	?
8	Grapes	Green	1	1	?
9	Grapes	RedOrange	2	2	?
10	Grapes	PurpleBlue	3	3	?
11	Grapes	DarkGreen	4	4	?