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