Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: missing feild values 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: missing feild values
     Posted: 15 Sep 2008 at 12:57am
hi Guys and girls.
 

Iam a begginer working in crystal reports , Got stuck in one problem and need help

Iam using database  Dynamics and created a  oledb sqlserver connection .

I have selected 4 tables from this database and trying to make invoice for a company

It contains field from different tables .

Voucher #           Doc #     Date      PO #      Reference           Movements        Running balance

                                                                                                                Credit   Debit                      balance

Here PO# is only from a different table and is not displaying in reports  I have linked this tables using a common field in these tables i.e Vendor id.  The data from PO # Field is missing or not displaying. What additional changes has to done to overcome this . Please help me . waiting for your reply.

With regards

MD Aneesuddin Arif

 

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: 16 Sep 2008 at 12:49am
Hi,
 
Are you joining all the tables using inner join............try joining the table PO# using left join ......
 
cheers
Rahul
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