Print Page | Close Window

How to add a new table to report

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=4023
Printed Date: 02 May 2024 at 10:57pm


Topic: How to add a new table to report
Posted By: toanees
Subject: How to add a new table to report
Date Posted: 19 Aug 2008 at 1:59am
Hi Friends
 
Iam new In Crystal reports and now i have a problem of adding a new table to reports that already have some tables .Iam in a middle of reports designing and need to add one more table from database to add feilds to report. Please help me its urgent.
 
Example.
Iam usind ODBC Connection to include the table to report.i have added three tables now. need to add 1 more table to report.
 
Thank You in Adavance.


-------------
Be passionate and very hardworking.


Replies:
Posted By: rahulwalawalkar
Date Posted: 19 Aug 2008 at 2:40am
Hi
 
Go to Database Expert
 
Expand the ODBC Connection then select then Expand the Tables Nodes select the Table you want to add and Click the > arrow
 
Cheers
Rahul

Posted By: toanees
Date Posted: 19 Aug 2008 at 3:41am
Thank you rahul. Actually i was researching on it and i got some solution. in crystal reports i clicked database menu-->Add Database to Report->select current connection and then add table . It worked . But your solution is good.
 
I have one more problem. ?
Accidentally I have created other database connetion to report. In Data explorer -->ODBC-->Database NAme->table. Now In Current Database I can see two databases available both referencing to same . How Can I delete one from it. Please let me know the solution for this . Iam using Crystal report 8.5.
 
Thank you.


-------------
Be passionate and very hardworking.

Posted By: rahulwalawalkar
Date Posted: 19 Aug 2008 at 5:27am
You can use the same steps Select the connection you want to remove and click the < arrow or
 
you can go to Database Expert  Log on Log off Server not sure though if you have that option in 8.5
 
Select the connection you don't want and log off
 
Cheers
Rahul

Posted By: toanees
Date Posted: 19 Aug 2008 at 5:51am
Thank you very much . great Help from you. The options you are telling are not  available in CR 8.5.

-------------
Be passionate and very hardworking.


Print Page | Close Window