Non Quirky Update solution (uses Tally table)

;WITH d (RowNo,PirateID,StartEvent,EndEvent,Duration) AS (

SELECT ROW_NUMBER() OVER (PARTITION BY PirateID ORDER BY StartEvent),

PirateID,StartEvent,EndEvent,DATEDIFF(second,StartEvent,EndEvent)

FROM timeSpent

),

r (RowNo,PirateID,N) AS (

SELECT d.RowNo,d.PirateID,t.N

FROM d

JOIN dbo.Tally t ON t.N BETWEEN...

Create a parent group and set the expression to

IIf(RowNumber(Nothing)<=10,1,2)

and set page break on the group

Normally this is done in the presentation layer, but if you must then

'$' + REVERSE(SUBSTRING(REVERSE(CONVERT(varchar,CAST(Finance_Report As money),1)),4,255)) AS [FinanceReports]

If FY_1 is a year and assuming it is an int datatype then use the following expression

=String.Format("Fiscal Year : {0}",Fields!FY_1.Value)

"yyyy" formatting only works with date datatypes

No. As I already stated you would have to use different values (and changing indicator ranges) to get MIN to work the way you want.

Because MIN will not obey 0, -1, 1 order

If...

How about this

=Switch(Sum(IIf(IsNothing(Fields!Passed.Value), 0, IIf(Fields!Passed.Value, 0, 1)))>0,0,Sum(IIf(IsNothing(Fields!Passed.Value), 1, 0))>0,-1,True,1)

Try this

=Switch(Sum(IIf(Fields!Passed.Value, 1, 0))>0,1,Sum(IIf(IsNothing(Fields!Passed.Value), 1, 0))>0,-1,True,0)

Yes or Report Builder via web browser (if you have permission)

After

Dim readStream As New StreamReader(sr, Encoding.UTF8)

Add

MessageBox.Show(webResp.StatusCode.ToString)

MessageBox.Show(webResp.StatusDescription)

MessageBox.Show(String.Join(",", Array.ConvertAll(System.Text.Encoding.UTF8.GetBytes(readStream.ReadToEnd()), Function(x) x.ToString())))

This will give you three prompts, response status, response description and ascii codes for response buffer

Change

Dim respData As String = sr.ReadToEnd()

to

Dim...

Only avaliable...

DECLARE @Result char(4)

EXECUTE (@sql)

SET @Result = CASE WHEN @@ROWCOUNT=0 THEN 'Fail' ELSE 'Pass' END

UPDATE tableB SET [column] = @Result WHERE ....

When you post there is a button bottom right (Edit Attachments) that will allow you to add attachments.

If you could make a mock up of what you want it to...