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...

;WITH cte (prefix,suffix,leftpart,rightpart,descrip) AS (

SELECT CASE WHEN LEFT(range2,1) LIKE '[a-zA-Z]' THEN LEFT(range2,1) ELSE '' END,

CASE WHEN RIGHT(range2,1) LIKE '[a-zA-Z]' THEN RIGHT(range2,1) ELSE '' END,

LEFT(range2,CHARINDEX('-',range2)-1),

SUBSTRING(range2,CHARINDEX('-',range2)+1,255),

descrip

FROM #temp),

cte2 (prefix,suffix,startno,endno,descrip) AS (

SELECT prefix,suffix,

CAST(REPLACE(REPLACE(leftpart,prefix,''),suffix,'') as...