Only 1 record from subreport (1 Viewer)

[Valentine]

I have a report created that pulls an individuals admin information and a sub report on there that should pull the most recent test results. For some reason it is pulling ALL the test results for the individual. I tried to turn can grow to no but that's not right. Is there a way to show just the most recent test results on the report?

 

[plog]

Sounds like your datasource is incorrect. You should base that subreport on a query that determines the record you want for each individual.

 

[Valentine]

Yeah I figured out I was completely wrong. CanGrow is the way to make it 1 record I just had to resize my subreport on the report.

 

[plog]

Are you sure its the right record? You can ensure that with the correct datasource.

 

[Valentine]

yeah i have it pulling from the query that I have sorting through date, so the top record is always going to be the most recent and thats what i wanted to show

 

[Pat Hartman]

Then change the recordSource query to select TOP 1

Do not just hide the other records. That will just cause other problems.