Dear All
I have built a report and it works once and goes off the next time.
Pls provide me with the best way to keep the program connected.
I have attached the stored procedure which is called by the program.
The program is passing parameters to the report.
I've bound the data and done the test query and it works well
However it works once and its off the next,
Hence I keep re-establishing the sqlDataSource.
ALTER Procedure [dbo].[rpt_Disbursement]
(
@FromDate DateTime,
@ToDate DateTime
)
As
Begin
Select @FromDate FromDate,@ToDate ToDate,IDNO,CUSTOMER,INT_NO,INT_NAME,TERM_START,AMTPAYBLE,
DATELOAN,ADVLOAN
From LOANS
Where DATELOAN Between @FromDate And @ToDate
Group By IDNO,CUSTOMER,INT_NO,INT_NAME,TERM_START,AMTPAYBLE,DATELOAN,ADVLOAN
End