The procedure has one parameter, which is a 3 digit brand name. It looks something like this:

Select Top 30

a.FERMID

,a.FermID

,a.Value AS TA

,b.Value AS FA

,c.Value as XTF

,a.FillDate

FROM snb01.dbo.vwAe a

INNER...

I was able to convert the enclosed table into a subreport, so now the subreport is enclosed in one of the cells of the first table and I can use...

I do have the original, but I wanted to add some functionality to the report that requires me to split up the datasets. The new stuff works now, but...

I found one possible solution to my issues as shown below:

=sum(iif(fields!InSpec.Value ="Yes",0,1))

and for the percentage

=sum(iif(fields!InSpec.Value ="Yes",1,0))/count(fields!InSpec.Value)