Statement of Account with Previous Balance

[CEFRA]

Hi good afternoon
I have a problem and how I can not solve, I'm trying to make account statement to a client, the particularity of this is that the report should take a customer's previous balance was taken into account in calculating the total of what the customer .

But as I can not do that because to calculate the customer's previous balance, I do a query that brings me the movement of transactions that the customer has not paid yet and add them in doing so I can not bring transactions customer during the time period established in the statement. Why I need 2 Data Sources for fetching a previous balance and one that brings all customer transactions.
As I can do since I'm using a SQL Server database CE 4.0 and Telerik WinForms. For my reports Others fill i use ObjectDataSource for my report in code behind like this
-------------------------------------------------------------------------------------

' Creating and configuring the ObjectDataSource component:

        Dim objectDataSource As New Telerik.Reporting.ObjectDataSource()
' GetData returns a DataSet with three tables

        objectDataSource.DataSource = vDatos.GetPagos_x_Cliente(gRep3_Cliente_id, gRep3_Fec_Ini, gRep3_Fec_FIn) 

Indicating the exact table to bind to. If the DataMember is not specified the first data table will be used.
        objectDataSource.DataMember = "GF_PAYS_FOR_CUSTOMER" '

 

        ' Assigning the ObjectDataSource component to the DataSource property of the report.

        Me.DataSource = objectDataSource

-----------------------------------------------------------------------------------

so how i use other datasource ??
I attach a picture to describe what I need.

Need help thanks

[Hadib Ahmabi]

You can use any item that supports data-binding:
table, list
these items can have their own data-sources that can be parameterized to fetch the data for the customer you wish.
You can also use SubReport with parameters.

[CEFRA]

Thanks for answer my question, well , i try but the same value appear for all records in the report.

i try this
http://www.telerik.com/community/forums/reporting/telerik-reporting/get-textbox-value-from-itemdatabound.aspx

my idea is populate a in codeBehind using a Datareader in the event ITEMDATABOUND i will get the balance for the ID populate in these moment

any idea ???