Loading

Crystal Report Problem

aman gandhi

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Prabhu Raja15y ago
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.