cancel
Showing results for 
Search instead for 
Did you mean: 

Parameter checking

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Could you create a mock up of your Categories table??

Edited by: achett13 on Dec 8, 2010 5:16 PM

Former Member
0 Kudos

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.

Former Member
0 Kudos

Worked out the problem. Thanks All.

Former Member
0 Kudos

The way to solved this is to go and create a selection formula

if {?schcat} = 0

then true

else

{Command.schcat} = {?schcat}