dimanche 12 juin 2016

displaying data from more than one table in crystal report

I am using a web form asp.net application in which i have to present a sap crystal report. Application is about a CAR SERVICE Center. I am using VS 2013 and sql server 2012.

In my sql server I have tables as follows

INVOICE
------------------------------------------------------
Invid           Serv_Req_Id         Total     Final     Advance
------------------------------------------------------
INV16060006	SRQ16060008	  2300.00	2185.00	  1500.00
------------------------------------------------------


Services
------------------------------------------------------
JObId       Serv_Req_Id           serviceid     qty   unitprice
--------------------------------------------------------
JOB16060008	SRQ16060008	  SRV16050002	1	  300.00
JOB16060009	SRQ16060008	  SRV16050005	1	  2000.00

Which means for an Invoice there are multiple services a person can do.

The invoice should be displayed in CR as below


Invoice details xxx xxx xxx xxx xxxx xxxx


services

xxxx xxxxx xxxxx xxxxx
xxxx xxxxx xxxxx xxxxx
xxxx xxxxx xxxxx xxxxx
xxxx xxxxx xxxxx xxxxx

total :xxxx discount:xxxx advance: xxxx grand total: xxxx


In database i tried to create stored procedure but failed. How can i achieve this. the solution can be by getting these data in some form from database or displaying these in CR

Thanks in advance

Aucun commentaire:

Enregistrer un commentaire