on 12-08-2010 9:56 AM
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?
Could you create a mock up of your Categories table??
Edited by: achett13 on Dec 8, 2010 5:16 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The Category table has 2 relevant columns;-
schcat_id numeric, schcat_desc varchar
0, All Categories
1, Govt
2, Pvt
3, NGO
There is no data under All Categories, so when 0 is selected, no report is generated.
I want to display all records pertaining to Govt, Pvt, NGO etc when 0 ie All Categories is selected.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.