Record Selection

[busi1]

Hi,

I have a report with five fields program, activities,name,target and status.
Report is grouped on program and activities.
Programs have multiple activities and some activities don't have programs.I want to display all the
activities only which have programs.

I am using Crystal 10.0 and oracle 10g

Help is appreciated

Thanks

 

[synapsevampire]

Are there multiple tables?

An inner join between programs and activities will do precisely what you want.

Not knowing the table structures, or if it's just one table, you could also use a record selection that says:

not(isnull(activities))
and
not(isnull(programs))

Now you should only see programs with activities.

-k