Dear pietlinden

You got me pointed in the right direction, many thanks. I used:

=Mid(Fields!Address.Value, InStr(Fields!Address.Value, "(") + 1, InStr(Fields!Address.Value, ")") - InStr(Fields!Address.Value, "(") - 1)

Can you write the query outside of the stored procedure and run the report from this dataset? You may then be able to do what you want.

To ChrisM@Work

Thanks - your solution worked well and WHERE EXISTS was not something I had encountered before.

Why not just add this to the join predicates to the Duplicates cte in the script I posted yesterday.

AND d.ReferenceNumber <> r.ReferenceNumber

I did try that Sean, but the output is...

As per the request above, please see:

create table Reference(referencenumber int primary key identity(1,1),lastname varchar(20),firstname varchar(20))

create table [Address](addressid int primary key identity(1,1),referencenumber int references reference(referencenumber),address1 varchar(20),

...

Will do. Apologies for my many egregious breaches of forum etiquette: I will do better next time.

Dear Sean

The script you suggested above worked, but (due to my poor explanation of what I actually wanted) the data that's come out isn't quite what I want.

Basically our contact...

Thanks for taking the time and your patience; I'm relatively new to actual scripting, as is probably obvious.

The query worked fine, in that it pulled through all our customers: their...

Hello Sean,

Yes, it was a hopeless entry. I reposted with this, which I hope is clearer:

Hello, I posted earlier with a poor script. Below is a better one.

It pulls through...

Thanks. Basically the report serves as a snapshot of the previous week so is sound for that purpose.

However, when you say ' otherwise data will be aggregated ' - I'm...

I solved the above by setting 'label' and 'group on' as:

=weekdayname(weekday(Fields!date.Value))

Many thanks for getting back.

This has nearly worked but across the x-axis it is displaying the first day only, five times, eg for the dates 23/2/15 - 28/2/15 it has...

Thanks.

Thanks - I misread the '' part. Worked perfectly.

Many thanks for taking the time and trouble to help.

Thanks very much for getting back.

I have tried as you suggested:

AND ISNULL(person_name) NOT IN ('john smith', 'sally brown')

But got the error message 'The isnull function requires 2 arguments'

I think I...