How can i create crystal report from multiple tables that are related.? I need to create a report based on the value provided through selectionformula in visual studio 2005.
Tables are :-
1. Vendor
vendor.id
vendor.name
vendor.address
2. Invoice
invoice.id
invoice.number
invoice.date
invoice.amount
invoice.vendorid
inovice.chequenumber
3. Cheque
cheque.number
cheque.date
My report should come like this
====================================== =
Vendor details of a selected cheque - Single columns
--------------------------------------------------------------------
Invoices for the same cheque(invoice_number, date, amount) - Multiple columns
---------------------------------------------------------------------
Cheque Details(total amount, date)
=========================================
Please help me, i m a newbie to crystal reports.