Creating reports and dashboards | Stimulsoft community forum

hi,
i have three table: PersonalInfo, LoanData, LoanTypes:
PersonalInfo contains: ID, FirstName, LastName
LoanData contains: ID, PersonID, TypeID, Amount, IsPaid
LoanTypes contains: ID, Name

where (PersonalInfo.ID=LoanData.PersonID) , (LoanData.TypeID=LoanTypes.ID)

i made a query (named LoanData_By_Person) like this:

"select PersonalInfo.ID, LoanTypes.Name, LoanData.Amount
from PersonalInfo Inner Join
(LoanData Inner Join LoanTypes On LoanData.TypeID=LoanTypes.ID) On LoanData.PersonID=PersonalInfo.ID
where PersonalInfo.ID = @PersonID"

i followed the sample sql master-detail by parameter in Demo. i used PersonalInfo as master and LoanData_By_Person as
detail.
but when i set master component in LoanData_By_Person dataBand at designer, and preview the result, only LoanData for first person showed in result. for example:

john piterson:

johnLoan1 1000$
johnLoan2 3000$
johnLoan3 2000$

mark jerry:

johnLoan1 1000$
johnLoan2 3000$
johnLoan3 2000$

andy white:

johnLoan1 1000$
johnLoan2 3000$
johnLoan3 2000$

AnyBody, I need your help please....
best regards
Thank you.
:tire:

hey everybody,
i found it. just change ReconnectEachRow parameter to true and
it works like a charm.

thank you anyway.