Hi,

I am creating a crystal report, in which i want to display organisation hierarchy in the report.

My report contains 2 mandatory parameters first one is 'Organisation(including sub-organisation)' and second one is the 'course name'.
I have created store procedure for my report.
Suppose I am having organisation as 'abc' under this organisation there are 10 learners. And I am selecting course name as 'xyz', none of the learner from organisation 'abc' is registered for the course 'xyz'. Then my report fetches the zero records. But I want to show the all the 10 learners records in the record with status 'Not registered'for the course.

If my course name parameter is optional then reports fetches 10 records. This is not according to the my requirement.

Please help me into this.
This is very urgent.

Thanks in advanced.

Regards,
Deepiks