I use the following to attempt to grab my main data stored procs. However, more are used for parameters but I have a naming convention for both.

select c.ItemID,

c.Name as ReportName,...

=Format(Round(Sum(Fields!CashPrev.Value),0),"#,##0")

You may want to investigate the Web Service that is installed with SSRS. It has a lot of functionality that may be useful in this instance.

In that case you may be able to utilize URL reporting. Send in the report parameter to the url. Via URL reporting you can turn off the parameter heading area,...

This should work within the report itself. I set a parameter's default to this and the results looked good.

=Switch(DatePart("w", now())=1,now(),

DatePart("w", now())=2,DateAdd("d",-1,now()),

DatePart("w", now())=3,DateAdd("d",-2,now()),

DatePart("w", now())=4,DateAdd("d",-3,now()),

DatePart("w", now())=5,DateAdd("d",-4,now()),

DatePart("w", now())=6,DateAdd("d",-5,now()),

DatePart("w", now())=7,DateAdd("d",-6,now()))

Have you found an answer to this? I would also be interested in this functionality.

There is a NoRows property on a table that you can enter in any message that you'd like to display when the dataset returns 0 rows.

Have you solved this yet? It is a little unclear what you're trying to actually accomplish. There must be more to it than just finding the ID of your dataset...

is it feasible to simply filter these rows out within your dataset generation (stored proc/sql, etc)?

In essence I just want the updated IDs into a holding Table.

Insert into ssrsWIPTemp (wipID, insertTime)

Select wipID, getDate()

From Inserted

Could you see another way to get any ID that was updated...

This trigger would be on our reporting server, so at that time of day (3AM) there shouldn't be much else going on.

Would this slowdown replication at all?

So where do you put this code?