Queries in Crystal Reports

jeva39

Well-known member
Joined
Jan 28, 2005
Messages
135
Location
Panama
Programming Experience
1-3
I have in my Database two tables: Clients and Payments. I need to create a report to permit the user know the payments by Client. Using the same report is possible the user select a specific Client to know the payments of this Client?. Please, what is the code or where I can define this query in Crystal? Thanks...
 
do you have a primary key on your tables?
if you do..

select the 2 tables then
link then using the visual linking expert...
afterwhich create a parameter with the same data type as the primary key in the client table..
then go to the record selection option equate the parameter with the primary key field in the client table...

for this to work you must have a similar field in you payment table with regards to the client table.. ex. client.clientno = payment.clientno;
 
Back
Top