Last post Aug 22, 2010 03:54 AM by javedhakim
Aug 19, 2010 01:31 AM|javedhakim|LINK
Hi! I want to display a crystal report in my vb.net application. Suppose I have tables named student details, student marks, student address, etc... Now
if I want to display all these details (fields of all tables) in one crystal report (with page breaks if necessary) then how will I achieve it. I will be providing a combo box in my application that contains list of student names.
How can I link this combo box with the cystal report to dynamically display report for different student on selected index change of combo box? Help me friends. An example would be appreciable.
Aug 19, 2010 11:39 AM|sansan|LINK
Create a procedure which takes a student ID as parameter which you will be assigning from front end.
Write a Query like this
FROM STUDENT A
LEFT OUTER JOIN
STUDENT_MARKS B ON A.STUDENT_ID=B.STUDENT_ID
LEFT OUTER JOIN
STUDENT_ADDRESS C ON A.STUDENT_ID=C.STUDENT_ID
That gives student information based on the parameter
create a new crystal report with datasource as the procedure that you create with aforementioned query.
In the report Create a group for StudentID and drag marks fields onto details section
add one more details section and drag address fields onto details section
you can set options in group expert/section expert (repeat Group header on page and start new page after)
That should do the job.
Aug 22, 2010 03:54 AM|javedhakim|LINK
Thanks sansan for replying. Could you please be more precise?
It would be appreciable if you provide images for creating the crystal report or atleast a sample project that implements the above said concept.