And you've been using SSRS for how long now?
1. datasets on the RIGHT are for the PROJECT. datasets on the LEFT are for the report you're working on. If...

Since you can only round numbers, you'd have to cast the values as a decimal and round those. You can't round a string.

Don't think it will work unless the first 2 characters of a the strings are unique, so you wouldn't have something like
Ball
Bath
as members of the set. If...

Elegant? That's the standard pattern for this kind of question. AFAIK, that's the way to do it.

I think you're missing a table.
Package (PackageID*…)
Server(ServerID*,..)
ServerPkg(ServerID*, PackageID*)   (basically the "contents"/inventory of each server)

One way to do it is
(Package CROSS JOIN Server)...

What I'm trying to get at is this: Is there another way of doing this search?
All the NOT LIKE and NOT IN clauses are going to kill performance. Think...

(Maybe I should have read more carefully!)
Those NOT LIKE and <> s are going to cause table scans. Performance will be brutal.

I'm probably going to get grief for saying this, but have you considered creating a view containing the filters you always use and then querying that? I freely admit that...

Before I suggest anything, I'd like to be sure I know the problem. There's a really good article on Subclassing by Rebecca Riordan (but she's implementing it in Access -...

Okay.
SSIS just baffles me. How much RAM am I supposed to have for this? If I open a Script task, it takes like 15+ seconds to close again. WTH???!!!...

Oh, okay. I'll give it a try. (Remember when MSFT used to be really explicit about which version of a program was installed and you could go to help>about and...

Do I seriously have to create a DSN for this to work?

Thanks Federico. I downloaded that and installed it,
I created a connection using the Source Assistant and could only connect to the database at all using the SSIS provider. But...