Thanks guys. I think the table-valued function is probably the way to go.

I conclude then that using an IN clause (in the sproc) is out of the question?!

Thanks Joe. Whilst we might know better than that (!) we seem to be forced into doing it to get round the problem of a parameter which comes out of...

Thanks Mike. I can see the table/join approach should be possible, but the neater

if @var in (@paramlist)

doesn't seem to work. Or am I using the wrong syntax?

Cheers.

I'm having the same problem, though we have now ditched the SS2000 report manager. Seems you can't have your cake AND eat it.

We've just upgraded our report server database to SS2005 from SS2000. All the (data) databases which the reports connect to still reside happily in SS2000.

you need to put an iif expression in the Visibility/Hidden property for the row which evaluates, e.g. whether there is any data to display.

For the textbox properties, select advanced properties and in 'Jump to URL' add 'mailto:name@domain' with appropriate values. You can make it dependent on the data by clickong on the fx...

you need to use an inner join, by matching up a column in your table that matches a column in your view. If you haven't used joins before, you're best...

As far as I know, once the snapshot has run, you can't amend the report except by using filters.

most of these functions can have a second argument which is either the dateset name or the name of a group you want to count over.

I've spent so much time looking for complicated solutions, ... as far as this piece of work goes, I think that will probably do the trick! Thanks a lot.

1. use a custom format in the value cell of

#;#;0

to ensure that zeroes are printed out.

2. I've had the same problem with specifying column headers; would be happy to learn...

Yes, the problem is though that I don't want to send an email at all if there are no rows to display. In the end I used a stored procedure...

Try setting the sort order using the Sorting tab under the data region properties. If you have any groups they can each have their own sort orders.

I find the column and row headers print on subsequent pages fine without selecting anything specific.