I have an FML report with "ON TABLE SET FORMULTIPLE ON". In building the report I've pulled a level 1 field from the hierarchy as Consolidated and the total is correct. If I try to use a level 2 field from the hierarchy the number for that tag line as well as the original are wrong.

Thoughts? I'm fairly new to this and I'm not sure I can recreate it using the car file.

Is your master you created this on is correct?

And how about the recursive join?

Can you post your master and the join plus a part of the used code?

Craig,

Having little info to go on here, I will add this....using FML is not necessarily the most efficient way to get data out of a hierarchy. I've used different methods before to create hold files and then used FML to format the report. I had great success doing this.