help!! Filter !! Somone has to know!

Am I just not explaining myself or does nobody use SSRS 2005 or if so not create very complex filtering requirements out there yet? Can I get some responses hopefully? I can't find anything out on the net about how to do what I'm trying to do here:

HERE IS A PRINT SCREEN OF THE FILTER TAB WHERE i WANT THIS ALL TO HAPPEN...PROPERTIES OF MY TABLE:

http://www.photopizzaz.biz/filtertab_ssrs2005table.jpg

essentially I want this check to filter records on my table...match to this criteria from my dataset:

In SSRS 2005, how can I add this check (what do I have to put in the Expression, operator, and value in filters tab of table properties) to my table filter to bringin only customers that match one of the 2 main OR statements?

essentially I want this check to filter records on my table...match to this criteria from my dataset:

(Fields!Branch.Value = '00002' and
Fields!CustomerNumber.Value = '0000002' or
Fields!CustomerNumber.Value = '0000003' or
Fields!CustomerNumber.Value = '0000004' or
Fields!CustomerNumber.Value = '0000155' or
Fields!CustomerNumber.Value = '0000156' or
Fields!CustomerNumber.Value = '0000159' or
Fields!CustomerNumber.Value = '0000160' or
Fields!CustomerNumber.Value = '0000161' or
Fields!CustomerNumber.Value = '0000118' or
Fields!CustomerNumber.Value = '0000153' or
Fields!CustomerNumber.Value = '0000152' or
Fields!CustomerNumber.Value = '0000108' or
Fields!CustomerNumber.Value = '0000158' or
Fields!CustomerNumber.Value = '0000133')

OR

(Fields!Branch.Value <> '00002' and
Fields!CustomerNumber.Value = '0000053' or
Fields!CustomerNumber.Value = '0000058' or
Fields!CustomerNumber.Value = '0000072' or
Fields!CustomerNumber.Value = '0000073' or
Fields!CustomerNumber.Value = '0000079' or
Fields!CustomerNumber.Value = '0000080' or
Fields!CustomerNumber.Value = '0000143' or
Fields!CustomerNumber.Value = '0000146' or
Fields!CustomerNumber.Value = '0000157' or
Fields!CustomerNumber.Value = '0000135')

See the post from Robert Bruckner (MSFT) titled Answer Re: And/or filter field not enabled in the group filter tab: http://forums.microsoft.com/msdn/showpost.aspx?postid=227116

This post was very helpful to me in building some complex "and/or" filtering on tables and groups, describing what values to put in the expression, type, and value fields.

Good luck...

-Chris

HELP! Corrupt MDF

While on vacation, a customer of ours had their RAID die and nobody seemed
to follow a good recovery process so when I came back all I was left with is
a bad MDF. When I use EM to attach I get Error 823: I/O Error (Bad Page ID)
...
Is there any way to force this to attach?Well I got it attached but I think it's toast because everything I try comes
back with an error of some kind or other.
Of course, backups were not functioning (not my network, I'm just trying to
help :p)
Me-thinks they're screwed.
"Bob Castleman" <nomail@.here> wrote in message
news:euC8AIbeGHA.2188@.TK2MSFTNGP04.phx.gbl...
> While on vacation, a customer of ours had their RAID die and nobody seemed
> to follow a good recovery process so when I came back all I was left with
> is a bad MDF. When I use EM to attach I get Error 823: I/O Error (Bad Page
> ID) ...
> Is there any way to force this to attach?
>|||Hey Bob,
I'm contractor and just got a call similar to your situation. But worse yet
is that the IT dept caused it! They had failed drive in RAID 5 config and
were pulling it to replace with spare but yanked wrong drive which then
failed the array...
There proud of themselves for forcing some kind of rebuild but they got 2
suspect DBs so they thought they'd detach and re-attach. Detach worked,
re-attach is giving the 823 torn page error.
So now they call me. Last back was mid-March. If I can recover any data,
I'd sure like to. How did you get yours to re-attach'
peace - kathy|||Hey Bob,
I'm contractor and just got a call similar to your situation. But worse yet
is that the IT dept caused it! They had failed drive in RAID 5 config and
were pulling it to replace with spare but yanked wrong drive which then
failed the array...
There proud of themselves for forcing some kind of rebuild but they got 2
suspect DBs so they thought they'd detach and re-attach. Detach worked,
re-attach is giving the 823 torn page error.
So now they call me. Last back was mid-March. If I can recover any data,
I'd sure like to. How did you get yours to re-attach'
peace - kathy|||Your best bet is to restore from a backup. If no backup is available, you
can do the following and live with some loss_of_data.
1. create a new empty db with the same name/path.
2. put the db into emergency mode (see alter db for sql2k5, modify
sysdatabases for sql2k)
3. take the db offline (see alter db)
4. swap the db files
5. put the db online (alter db)
6. run dbcc checkdb
-oj
"Kathy_Automation" <KathyAutomation@.discussions.microsoft.com> wrote in
message news:3039CC2A-8DF5-4B2C-A6AD-5016A681DA57@.microsoft.com...
> Hey Bob,
> I'm contractor and just got a call similar to your situation. But worse
> yet
> is that the IT dept caused it! They had failed drive in RAID 5 config and
> were pulling it to replace with spare but yanked wrong drive which then
> failed the array...
> There proud of themselves for forcing some kind of rebuild but they got 2
> suspect DBs so they thought they'd detach and re-attach. Detach worked,
> re-attach is giving the 823 torn page error.
> So now they call me. Last back was mid-March. If I can recover any data,
> I'd sure like to. How did you get yours to re-attach'
> peace - kathy|||Your best bet is to restore from a backup. If no backup is available, you
can do the following and live with some loss_of_data.
1. create a new empty db with the same name/path.
2. put the db into emergency mode (see alter db for sql2k5, modify
sysdatabases for sql2k)
3. take the db offline (see alter db)
4. swap the db files
5. put the db online (alter db)
6. run dbcc checkdb
-oj
"Kathy_Automation" <KathyAutomation@.discussions.microsoft.com> wrote in
message news:3039CC2A-8DF5-4B2C-A6AD-5016A681DA57@.microsoft.com...
> Hey Bob,
> I'm contractor and just got a call similar to your situation. But worse
> yet
> is that the IT dept caused it! They had failed drive in RAID 5 config and
> were pulling it to replace with spare but yanked wrong drive which then
> failed the array...
> There proud of themselves for forcing some kind of rebuild but they got 2
> suspect DBs so they thought they'd detach and re-attach. Detach worked,
> re-attach is giving the 823 torn page error.
> So now they call me. Last back was mid-March. If I can recover any data,
> I'd sure like to. How did you get yours to re-attach'
> peace - kathy

HELP! Corrupt MDF

While on vacation, a customer of ours had their RAID die and nobody seemed
to follow a good recovery process so when I came back all I was left with is
a bad MDF. When I use EM to attach I get Error 823: I/O Error (Bad Page ID)
...
Is there any way to force this to attach?Well I got it attached but I think it's toast because everything I try comes
back with an error of some kind or other.
Of course, backups were not functioning (not my network, I'm just trying to
help :p)
Me-thinks they're screwed.
"Bob Castleman" <nomail@.here> wrote in message
news:euC8AIbeGHA.2188@.TK2MSFTNGP04.phx.gbl...
> While on vacation, a customer of ours had their RAID die and nobody seemed
> to follow a good recovery process so when I came back all I was left with
> is a bad MDF. When I use EM to attach I get Error 823: I/O Error (Bad Page
> ID) ...
> Is there any way to force this to attach?
>|||Hey Bob,
I'm contractor and just got a call similar to your situation. But worse yet
is that the IT dept caused it! They had failed drive in RAID 5 config and
were pulling it to replace with spare but yanked wrong drive which then
failed the array...
There proud of themselves for forcing some kind of rebuild but they got 2
suspect DBs so they thought they'd detach and re-attach. Detach worked,
re-attach is giving the 823 torn page error.
So now they call me. Last back was mid-March. If I can recover any data,
I'd sure like to. How did you get yours to re-attach'
peace - kathy|||Your best bet is to restore from a backup. If no backup is available, you
can do the following and live with some loss_of_data.
1. create a new empty db with the same name/path.
2. put the db into emergency mode (see alter db for sql2k5, modify
sysdatabases for sql2k)
3. take the db offline (see alter db)
4. swap the db files
5. put the db online (alter db)
6. run dbcc checkdb
--
-oj
"Kathy_Automation" <KathyAutomation@.discussions.microsoft.com> wrote in
message news:3039CC2A-8DF5-4B2C-A6AD-5016A681DA57@.microsoft.com...
> Hey Bob,
> I'm contractor and just got a call similar to your situation. But worse
> yet
> is that the IT dept caused it! They had failed drive in RAID 5 config and
> were pulling it to replace with spare but yanked wrong drive which then
> failed the array...
> There proud of themselves for forcing some kind of rebuild but they got 2
> suspect DBs so they thought they'd detach and re-attach. Detach worked,
> re-attach is giving the 823 torn page error.
> So now they call me. Last back was mid-March. If I can recover any data,
> I'd sure like to. How did you get yours to re-attach'
> peace - kathy