Hi Mike

Thanks for this suggestion, I shall give it a try and let you know the result

Regards

Further poking around etc showed me that there were a couple of setting adrift in the various places.

I am now at the point where I have got it to work,...

Good Morning,

I eneded up using this as the expression which works fine;

=IIF(Not(Fields!unittype.value = "Car Parking") AND Not(Fields!unitstatus.value = "Vacant"),1,0)

Thank you for all your assistance

Regards

Thank you for the information

Regards

Thank you, I shall look at that right now and then hopefully will not have to bother anyone for a while.

Thanks Again!

Hi, ok to clarify. There will only be one set of budget information per site_ref. On the first row that has the min(unit_ref) I would like that budget information placed. The...

The solution as found elsewhere on the net!

To get the old Version of the report do the following:

open http://[servername]/reports and navigate to your report, open it, and goto the...

I went with this as the option. Thanks for you suggestion though, much appreciated

WHERE     (src_date >= CONVERT(varchar(6), @dt_src_date, 112) + '01') AND (src_date < DATEADD(month, 1, CONVERT(varchar(6), @dt_src_date, 112) +...

Hi

Both valid suggestions and I thank you for making them to me.

Regards

OK, well if that is the case I suppose the only option is to make an entry in the query result a NULL so they can specify that as an...

Thanks Jim

Your assistance is much appreciated.

Kindest Regards

Thank you very much all of you for your detailed posts. Evry day on here is like a day at school.

Great info, thank you

Regards

Thank you Jeff, I will give that a run now.

Watch this space!

Kindest Regards

I have gone for this as the final solution to the problem.

WHERE

(src_terrier.datadate = @dt_src_date)

Noted and Thank you

Regards