How Join Query work in Crystal Report ?

Posted by K011gusain89 under ASP.NET on 10/29/2012 | Points: 10 | Views : 1811 | Status : [Member] | Replies : 1
It is possible to make join query in crystal report in Visual studio 2010




Responses

Posted by: Rajesh081725 on: 10/29/2012 [Member] Bronze | Points: 25

Up
0
Down
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.

K011gusain89, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response