Set the expression of the text box to:

=IIF(Left(SalesOrderID,2)="SP","Warranty 1 Year","Warranty 6 months")

If there are other options you may look into the Switch function.

Thanks for the replies. I definitely am interested in alerting on poor performing queries and blocking. We have our time and billing system that needs to be kept an...

I have been severely unimpressed with any book that I've seen regarding Reporting Services. Once you get into it, you'll quickly get used to the new system. After that, I...

I know that on my computer (development) this works. However when you publish to the report server it only shows true / false.

I used this. It only grabs report objects...

select c.[Name], r.RoleName, u.UserName

from reportserver.dbo.catalog c

join reportserver.dbo.PolicyUserRole p on c.PolicyId=p.PolicyId

join reportserver.dbo.Roles r on p.RoleId=r.RoleId

join reportserver.dbo.Users u on p.UserId=u.UserId

where name <> '' and c.Type...

What version are you running. I thought that this was an issue in 2005 but then fixed in 2005 sp2.

We implemented this same thing. Just make sure that you're in a group that still has access to the reporting environment. We added an administrator group that was IT Reporting...

I actually just witnessed this in use. They added a link to a subreport that was actually the same report as they were in. What are you trying to do...

I would suggest using a drop down to ask which the user wants to filter on, then only 1 text box for user input.

As far as how the parameters are...

Have you changed how users launch reports? I know that if you access these reports via url, you can tell it to minimize the parameter area.

I would talk to your Exchange admin. All I did was type in the IP address of the SMTP server and it worked.

Have you found an answer to this? I have the same question.

How would you do that? I've attempted with using a scope in the sum filter, but that throws an error.

Have you gotten this to work? I am running into the same thing that you're talking about. I've attempted "RunningValue" but that isn't working either. Thanks!

You have to setup the parameter within the report to allow for null values. By default you must enter a value.