report builder not displaying some rows

Hi friends
am using report builder to create a report ,the report not displaying some rows.
i've 2 tables . Patients and transactions (1- many)

and assume that i've following records
patient
--
1 , sriram , albert street,nz
2 , david , victoria street ,aus

transactions (flds are patientid,charge,transaction date)

1 , $100, diabetes problem ,10/10/05
1, $100 , diabetes problem , 19/01/06
2, $150,someother problem

if i create a report with following fields
name , address (from patient table)
charge , problem (from transactions table) i get following results

sriram , albert street,nz,$100
david , victoria street ,aus , $150

as u can see it ignored the 2nd record for patient "sriram" ?i used sql profiler to get query report builder creating and if i run it in QA i get all results am expecting but report builder thinks ignores 2rd record as it thinks its duplicate.

i know how to fix this by just adding transaction date field but the abv report is very common one our users create ,is there any way report builder displays all rows ?
Thanks
it is still an issue for me !! no one has faced similar situation ?|||

Sorry: I have not used Report Builder (we're on SQL 2000 and Report Designer), but it sounds like it is just returning DISTINCT recordset.

There may be an attribute on the table? Or the query uses SELECT DISTINCT?

Perry

|||Thanks for the post Perry
The query RB creates is fine as it returns correct results if i run it QA.
but looks like RB doing a distinct after gettting the data!