=IIf(Fields!Number.Value >= 1 and Fields!Number.Value <= 1000

, Fields!Number.Value

, "All OK")

Sorted this by creating calculated fields and selecting them to chart with.

Sorted by series label properties, number, percentage.

Thanks all - a table it shall be!

Many thanks for getting back.

Do you mean set up two calculated fields:

=DatePart("dw", fields!jobstartdate.value) and =DatePart("dw", fields!jobenddate.value) and then subtract the difference?

Sorry don't quite get it.

Thanks (and noted re the...

Many thanks marksquall for taking the trouble to get back.

Your suggestion worked well and it is good to know another way to solve the sorting issue I had.

Thanks for getting back.

Worked perfectly.

Solved by:

=Ltrim(Rtrim(fields!address1.value)) & ", " & Ltrim(Rtrim(fields!address2.value)) &", " & Ltrim(Rtrim(fields!address3))

Worked perfectly - thanks.

Many thanks - your help and answers today have got me on the right track.

Thanks. I've entered the expression and it's thrown up an error: 'the valueexpression used in field 'time' references a dataset field which contais an error. Conversion from string "DA"...

Thank you.

Basically if the field is put straight into the report (as a column) it splits into three:

Timeslot appears first

Type of job second

Address third.

So the content of the field is...

Thanks for taking the time to get back.

Sorry to appear slightly dense (I am fairly new to reporting services), but how would I parse the column? I get the time...

Worked perfectly - thank you.

Option 1 worked well - thanks very much.