The data you provided and the statement of the problem make this look like homework. Is it?

You'll need to analyze the data to work out how to break it...

I don't think you can modify the system procs, but you can open it up, change the name, and create your own custom proc that'll do what you need. ...

That goes beyond what I know on SSRS. There's probably a way to do it, but I wouldn't know where to start.

You'll need to convert to strings first.

@@SPID

l543123 (3/17/2010)

sorry if I am wrong, but why are you searching...

You're on the right track.

You'll need a dataset for the header (and any footer you have planned).

You'll need a dataset for the body of the report. Most likely, this...

You're welcome.

If there's to be government-induced security on the internet, I'd rather see it in terms of encouragement than regulation.

If, for example, antivirus software were tax-deductible, for both corporations and individuals,...

If it needs to run on 2k, I'd seriously look at moving it out of the database into a service or app. You'll get all the error handling you...

Look up "Common Table Expression" in Books Online or on MSDN.

Where @SearchType = 'All' and MyDateColumn between @StartDate and @EndDate or @SearchType != 'All' and ...

Have something like that in the Where clause.

Jeff Moden (3/17/2010)

It's real simple then... They didn't call me to ask...

One of my favorite rules. Knowledge induces...

Have you tried using a Try Catch block to handle it?