Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Inner join in crystal 2008 Post Reply Post New Topic
Author Message
vikram_sukumar
Newbie
Newbie
Avatar

Joined: 15 Feb 2010
Online Status: Offline
Posts: 1
Quote vikram_sukumar Replybullet Topic: Inner join in crystal 2008
     Posted: 30 May 2010 at 7:14pm
Hi All,

         I am new to Crystal report 2008, i have  a requirement in which i have to make new  connection to Access database which has two tables in it. I have to inner join two tables in crystal reports where the condition is that 1st table contains date and time field and other table has only month. I have to inner join these two fields.Can it be done in crystal reports or i have work on Access itself?


Regards,
Vikram Sukumar
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 30 May 2010 at 9:33pm
just suggestion,
 
better you done it in Access by making same type of field (month with month or date with date).
 
 
hope it help.
 
Emir W
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 01 Jun 2010 at 5:11am
Or even better, create a query in Access with the proper joining.  Also it is easier to verify the results.
IP IP Logged
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