Any record you need to extract must exist as a DETAIL. All the other template types only produce any fields when associated with a detail record.
So the A lines have to be detail records if you want them to appear on the report.
I assume an A line must always exist so that is the easy part.
For the B lines it would still be worth investigating if there is any way at all that a single template could give what you want. If not field by field maybe it would work as a 'block' capture that you could then split using calcualted fields and their functions.
Alternatively you could split the process and extract just the 'A's in one process and just the Bs (with an append template to pick up enough of the A data to create a link) and then use an external lookup from one to the other to re-connect them.
There are a number of opportunities to perform some good analysis on this sort of problem but it gets tricky to make meaningful suggestions without being able to assess an original report.
Could you post a full example of the report but with any personal information suitably altered?
There are over 50 columns in the B records, so I am having the end user confirm the columns needed in the output. Meanwhile, here is a sample of the report. As you can see it aligns up to the gender field F on the B record and then does it own columns on the B records. The A and B records are linked by the 123456789 employee SSN field, which connects a family. So another B record (dependent) under employee AM HAPPY would have the same 123456789. Though another employee would come over as its own A record with any corresponding family members with a B record.
Also, I did try by changing it to the A records as the detail and then the B records as the append but not all my B records are displaying (though all the A records are there now), only the first B record and they are 1 line below and then it fills the ones that don't have B records with a B record that should not be there. So as you can tell that I need help there. I hope the sample report helps in you seeing a better picture of my issue.
BR123456789 00099999HAPPY YOU F1947021520070101 S Y C20070101
Sorry for the delay - had some phone line problems for a few days and I have also been away so am now trying to catch up.
You are unlikely to get the results with B records as appends - an append trap must come BEFORE its associated Detail trap and I am guessing that it does not (at the moment) in your model.
To work out the best approach for this. I think you may need to treat them all as detail records no matter whether they are A or B types.
However whilst that would solve the extraction of missing lines it may not help you to deliver the records imn the format the user wants to see them.
Do you know what they want to see as the result? I am asking this in particular because you have also asked them which fields they want - which sorto fo suggests they may not yet have told you everything about the 'specification' that you need to deliver the results they want.
Your best approach to the extraction task may well depend on what they want to get as an output.