Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: How to add a new table to report Post Reply Post New Topic
Author Message
toanees
Newbie
Newbie
Avatar

Joined: 07 Aug 2008
Location: India
Online Status: Offline
Posts: 8
Quote toanees Replybullet Topic: How to add a new table to report
    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.
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet 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
IP IP Logged
toanees
Newbie
Newbie
Avatar

Joined: 07 Aug 2008
Location: India
Online Status: Offline
Posts: 8
Quote toanees Replybullet 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.
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet 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
IP IP Logged
toanees
Newbie
Newbie
Avatar

Joined: 07 Aug 2008
Location: India
Online Status: Offline
Posts: 8
Quote toanees Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.