First, not a techie.  I got roped into a project way out of my league trying to develop a report in SSRS using visual studio 2012.  I have a simple table with two values in a column.  I want to simply generate a third row in that column that returns the lesser of the two values.  Is there a simple way to do this or does it involve some complex code?  Help very much appreciated and please dumb it down for my non tech oriented brain.

Hi RRAP,

I Hope you have covered all the basics of SSRS, This is pretty simple .In the below image I have taken show n the lower value of the sales column.The way is achieved it 

1.Take a table control and drag your respective column from the dataset.

2.Then insert a row outside the group below the details row

3. Then use the expression in the column =Min(Fields!YourColumnName.Value) in my case it is =Min(Fields!Sales.Value)

If you are not tech brain then i would do something like this... :-)

Declare @tbl1 as table(col1 numeric(9,5))
insert into @tbl1 values(123.4),(1456.5)

select col1 from @tbl1 
union all
select min(col1) from  @tbl1

change your query to something like this or if you are using table than change it to query and use union all on the same table.

This should work for you.