Display Multiple Detail Sections Together

[Mav3000]

Hi, I have a Site report which has a section in the RH showing the notes for the site and any Jobs done on the Site.. These notes come from two tables - {tblSiteNotes} and {tblJobNotes}.

I have put a subreport in my RH to list all of the notes (the main section of the report will show data, so I'm listing notes in the RH as a summary of activity).

I have split the subreport into DetailsA and DetailsB. DetailsA has {tblSiteNotes.Notes} in it and DetailsB has {tblJobNotes.Notes} in it.

I want to list all Site Notes, then all Job Notes. At the moment, All Site Notes show for each Job Note, meaning Site Notes repeat multiple times down the list.

How can I stop this?

Thanks, Richard

 

[PatriciaObreja]

Maybe you should have 2 subreports: one for Site Notes and one for Job Notes.

-------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium