try something like:

create procedure sproc(@param1 varchar(10)) as

begin

delete from table1 where var1 = @param1

select var1, var2 from table1 --or any other table

end

I'm sure this would work. You need something which is unique to each project. Globals!ReportFolder is just such a thing. As long as each project is associated with a different...

I think I understand now! You produce a new project for each customer (from the base project) and then tweak the individual reports as they require.

Depending on how you name...

If you don't want to dabble at the SQL Server end, the only thing I've done similar to what you're trying to do is to pick up the user account...

any report can be based on a stored procedure. As long as it outputs the required rows at the end, it can do anything else based on your data before...

there are a lot of things to take into account if you access data from custom code within a report and the error's probably due to your permissions being different when...

Can't you put the logic in an SQL Server function which is called by your views or sprocs? It depends on where the customer account number is available of course.

I wrote an article about this area of RS a few months ago.

http://www.sqlservercentral.com/columnists/jspink/areporttodisplayandedituserrights.asp

There is a lot of scope to work interactively, though as the previous post says you're...

it takes about 50 seconds to run which isn't too bad.

what I meant was that I can prioritise one table over another id tey both have entries for the same...

Thanks, I think this is the way to do it. I can also add in a code for the tables and so prioritise those in a certain order.

I'll have to...

sorry, it IS a common field. I didn't originally think it was key, but in fact it is what makes the problem so tricky.

I'm sure this can be done using...

... but I need to have the communication_id of the earliest transaction for each customer!

Yes, that certainly works. Thanks.

I now have to find the earliest communication_id for each customer: each table has a customer_id field. Will your code work with suitable modification? i.e....

Sorry, this should have been entitled: 'Picking earliest transaction ...', but then it's still early in the day in London...

you could run a report which returns a list of files from a given folder, then put a hyperlink on each row of the report which will take that path...