Ok thanks for that I'll give it a try.

But I eventually managed to get that working but I had to go the long way around.

I just basically entered the values...

That worked, thanks for all your help with this.

I have re-named them but it's coming up with the exact same error message. Just with the names changed.

My first textbox is now called 'self1'. The second one is called...

I am getting an error with that:-

The value expression for the textbox3 contains an error[BC30456] "textbox1" is not a member of Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.ReportItems

Ok I'll give it a try, thanks.

Linked to the same report, I am trying to make a join between 2 tables on different server.

One DB is called vacancy and the other is called InsightSSRS.

My from clause...

That worked!

I tried:-

=Trim(Fields!forename.Value)& " " & Trim(Fields!surname.Value)

Thanks again.

Thank you for that I'll give it a try.

When I run the IsNothing with my expression it runs fine but the figures are not correct.

The figures are showing 24 helpdesk jobs still open whereas it should be 14....

Hi

Sorry, I'm still getting an error.

Ok I have found the problem.

When I run the SQL directly against my database I can use IS NULL like this:-

WHERE CLSDDATE IS NULL

and this works.

However when I try to...

Hi,

sorry I'm just trying to pinpoint the IIF expression down to the correct results I need it to bring me back as the figures it's showing me are not correct...

Ok I think I may need to make my IIF more specific as it seems like it's not showing the correct numbers it should (although it's got rid of the...

Hi,

Thanks for that.

The problem is that it's not blank, it has the word 'NULL' in the datetime field if nothing is filled in.

How could I compare it to the text...

Ok yes I'll give it a try.

Thanks again.