hi my stored procedure is
ALTER procedure [dbo].[get_finalcash]
(@regdno varchar(25),
@total money,
@advance money,
@deduction money,
@netamount money,
@todate datetime,
@paid money,
@due money,
@to money,
@to1 money,
@to2 money,
@to3 money
)
as
begin
select f.regdno,f.name,f.doa,f.time,f.advance,f.dod,f.time1,f.billno,e.rddp,e.napa,e.na,e.total from finalbill f
inner join efinalbill e on f.regdno=e.regdno where f.regdno=@regdno
select rddp as OtherEx,total as Total from efinalbill where regdno=@regdno and head='Other Expenses'
end
i am getting this store procedure into crystal report but i am getting first statement values only
how can i get second statement values also
Thanks&Regards
LakshmiNarayana Nalluri.