We are using crystal reports in visual studio 2008 and oracle as the database. the database has a table of categories. The first is "All categories" value= 0, then "primary", value = 1 etc. Now there is no data in "All Categories". What I want to do is when parameter cat = 0 then results from "primary", "secondary", "Primary and secondary" etc should be displayed. We have 3 such parameters like this one. All are numeric. How is this possible in Crystal reports?