reporting works when only sqlDataSource is re-built manually in test mode

See more:

C#

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