Problem occurs if I try to place a field from second table onto the report and then execute the report. Having two tables linked and only placing field from first table on report works fine.
I have one Member_Speak_mst table(feedback table),it contain the customers feedback records of non-member customer and member customer.The detials of these customers are in two table,customer_master(members),crs_guest_master(non members)
I want to generate report of feedback records with these customers detials report
My problems is these detials of customers are in two different tables.The link between feedback table and Master tables with one unique key field name(book_no_c) in feedback table.I am storing this field from one of the masters table field name(book_no_c).
what are the fields should I add in design time.I linked to tables to Masters,I tried to add both from customer_master crs_guest_master and,but that time data is not displaying.
My table struture is given below briefly
1)Member_Speak_mst table(feedback table)
a)book_no_c
b)member_type
2)customer_master
a)book_no_c
b)name
3)crs_guest_master
a)book_no_c
b)name
I am using 4.6.1.0 version of Crystal Reports
Connectsing my report through ODBC
If you are programming also include:
The version of VB is 6
. OCX is (Crystal32.ocx)
please give a solution