Print Page | Close Window

Report from multiple tables

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11497
Printed Date: 18 May 2024 at 10:18am


Topic: Report from multiple tables
Posted By: arv1980
Subject: Report from multiple tables
Date Posted: 22 Oct 2010 at 5:05pm
Hello All,

I am new to crystal reports and I am trying to create report from multiple tables(around 7 tables, seperate table for engineer, doctor..). The reports looks something like this

Daily Report
Date: 06/14/10  - 06/15/10  Time Frame: 5 a.m. to 5 a.m.








Engineer Status:
In Time: Out Time: Engineer Name Site ID: Description: Ticket No. Resolution: Medium
               








Doctor Status:
In Time: Out Time Doctor Name Description: Ticket No. Resolution:
           
           








Pilot Status:
In Time: Out Time Doctor Name Description: Ticket No. Resolution:
           

I am not sure how to create it. I am able to create only the first part ie it shows me report for only one table. Once the report is created I have to export it in excel. Also I mention the dates from VB . ie which day report I want. Please please help.

Thanks & Regards,

Amit
        


Replies:
Posted By: arv1980
Date Posted: 23 Oct 2010 at 5:59am
Someone please help.


Print Page | Close Window