Crystal Report Problem

Question

i am generating a crystal report from two tables student_name,student_id,course from student table and fee_id,amount,date,fee_type from fee table. my problem is that i want to create a report only from a fix student_id entered in textbox.

how can i do that. how to apply a where query in crystal report.

thanks

Aman Gandhi

Prabhu Raja · Answer

Hi my suggestion is 1) create a stored procedure in database with one parameter (student_id) and select all values from your tables by using the parameter in Where Clause. 2) In your Application Use that stored procedure as a data source for crystal report. 3) now you can send the student_id entered in text box to crystal report as a parameter . So that the Crystal Report automatically executes that procedure and will display the values.