Print Page | Close Window

Report from multiple tables

Printed From: Crystal Reports Book
Category: General Information
Forum Name: New feature request
Forum Discription: Share what features you want to see in the next release of Crystal Reports.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7579
Printed Date: 01 May 2024 at 4:22pm


Topic: Report from multiple tables
Posted By: lvensen
Subject: Report from multiple tables
Date Posted: 03 Sep 2009 at 3:18am
Hi,

       How to generate a report from multiple tables? For example, students personal details stored in a table and their marks details stored in another table. Register is primary key in personal details table and foreign key in marks details table. I want to take the report based on the register no. Personal details will display one by one like name, address, phone no,... and the marks details will shown by a table from first mid term to annaul exam.

Name:  aaa
Address:  aaaa
Phone no: aaa

                          Tamil    English     Maths    Science    Social Science
First mid term        87       52            75          86               75
.
.
.
Annual                   90        95            99         92                89


How it is possible?



Print Page | Close Window