Solved it via:

IIF(IsNothing(fields!date2.value), "no",

IIF(DateDiff(DateInterval.Day, fields!date1.value, fields!date2.value) >= 0, "no", "yes"))

Thanks for getting back. I did try CONVERT but had the same problem as above.

However, I've nearly solved the problem by using:

IIF(DateDiff(DateInterval.Day(fields!date1.value, fields!date2.value)>=0, "no", "yes"

However if the date 2 field...

Thank you for the prompt and practical solution.

Thanks for getting back.

I have tried:

WHERE ...

AND ((job.orderdate BETWEEN (@odate1) AND (odate2))

OR (job.completeddate BETWEEN (@odate1) AND (odate2)))

Which nearly works in that it brings through the correct completed total. However...

I'd added a company logo to the report: its position was affecting the way columns exported. Problem fixed.

stevenb 14609 (9/2/2015)

---

You have converted the date to a VARCHAR, so now it's sorting alphabetically instead of by date. In other words, alphabetically would be 1, 11, 12, 2, 3...

John Mitchell-245523 (9/2/2015)

---

Yes, or just do the conversion after calculating the minimum:

CONVERT(varchar(17),MIN(a.orderdue),103)

This has the added advantage that it only has to do the conversion once (on the minimum date) instead...

=IIF(Fields.Date.Value = nothing, "No Date Input", CSTR(DateDiff("d",Fields!Date.Value,Now)))

Thanks for the reply amd interesting re SSRS: however all of my reports (at the moment) are for a small internal audience: this may of course change in the future....

Note that I've just realised I put "1" and "0" in the queries - removing " " makes the sum work fine

Thanks for the reply: worked very well.

Dear Jack

Thanks very much for taking the trouble to get back to me. I tried Alvin's solution first, which worked, but yours looks very similar and I'm sure would have...

Dear Alvin

Thanks, your solution worked perfectly. I wish I could buy you a drink.

Thanks for the very prompt response: much appreciated.

Sorry to appear feeble, but could you please suggest how I would write the expression as you mention above?

Dear Alan.B

Yes, I should work towards what you suggested. I daresay the query would run faster as well. Thanks for taking the trouble to reply.