help in Building complex data report

[amit mishra]

i am attaching the format of report i want to get printed for each student.

there data is in access.

Dear friends,


i have to print that report on single page, i have to display marks of the student in grid form, secondly student's participation in different activities, that is also in grid format, thirdly graph showing his performance and his picture too



my problem is i donot know how to make report having multiple tables one under neath each other and how to make graph at run time on the bases of marks student gets pl. help me out
is it possible to get such report through data report

amit

[ZanM]

If you go into Access 97 or 2000 and open your database you can use the query builder to build complex SQL string that can bind multi tables together and sort the output to your liking.

Once you have the SQL built, you can paste it into a dataEnviorment's Command and connect a report to the command. Karl Moore explain's it better in part 6 of te database tutorial here.