How Join Query work in Crystal Report ?

Hai ,
Ya it is possible to join query in crystal report in Visual studio 2010
For example i am using two table in Customer and Product
First you need to write a procedure in TSQL like this

SELECT C.idCustomer CustomerId, C.Name Name, C.Address Address, P.Description Description, P.Total Total
FROM CUSTOMER C
INNER JOIN PRODUCT P
ON C.idCustumer = P.idCustomer
And add set this proc as the datasource for the report. Then you have to do a grouping for field, CustomerId in the report. After that you need to place the customer details in the group header section and the order details in the Details section. And also to get the total value for the you have to use the summary field in crystal reports


Thanks and Regards,
Rajesh Kumar.


Time is Gold
Thanks & Regards,
Rajesh Kumar,
9962038582.