Crystal Reports Filter multi fields in Crystal Reports 9

Message

   Hi All,

I am new to this forum. Any body help me to find how to do following example with crystal reports 9

Access 2003 Database

Table Names
1. All_data
    Field Names: cat1, cat2, cat3, cat4, name, address
2. temp
    Field Names: cat1, cat2, cat3, cat4

Crystal Reports 9

Manually we are entering data to temp table - cat1,cat2.cat3.cat4

if temp.cat1="All" then
show all data in All_data.cat1

if temp.cat2="All" then
show all data in All_data.cat1,cat2

if temp.cat3="All" then
show all data in All_data.cat1,cat2,cat3

if temp.cat4="All" then
show all data in All_data.cat1,cat2,cat3,cat4
----

if temp.cat1<>"All" then
show All_data.cat1=temp.cat1

if temp.cat2<>"All" then
show Add_date.cat1=temp.cat1+All_data.cat2=temp.cat2 ect;

and can use mix mode..
ex: ca1="All" and cat2="Color-Red" and cat3="Play-Cricket" and cat4="All"

Thank you,
Regards,
Supun Silva