how to use shared variable using stored procedure in crystal reports

Posted by sonia on Stack Overflow See other posts from Stack Overflow or by sonia
Published on 2010-05-24T11:25:06Z Indexed on 2010/05/24 11:31 UTC
Read the original article Hit count: 261

Filed under:
|

i have a parent report and it contains a two sub report. * subreport: item which get all fields from store procedure named spGetReportItem. like ItemName ItemQuantity TotalItemCost ab 4 45 dd 6 98 *subreport: Labour which get all fields from store procedure named spGetReportLabour. like labourName labourQuantity TotalLabourCost ab 44 455 dd 63 986

i want to find the total of totalitemcost and total of totallabourcost and then want grandtotal of totalitemcost and totallabourcost.

i have seen many examples on internet in which shared variable is used in the formula bt the problem is that they have used the table but i m fetching data from stored procedure. so how can i access the stored procedure fields for calculation. like i have seen that many have used:

shared numbervar total:=sum({tablename.ColumnName});

but i have used stored procedure instead of table so how could i find total of field that resultset returns from stored procedure.. plz give me answer as soon as possible.. i need it urgently. thanks..

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server-2005