I've read that sub reports can only be one level deep... The situation I'm in requires my sub report to have a sub report.

What are my alternatives? How else can I achieve what I need?

Below are my links for for my tables... The main report passes a job reference and the use is a constant for this use. There are multiple consolidated records to be shown, each consolidated record has one or more tariffedinvoicelinearchive records...

Not sure how to tackle this one, I'd appreciate any help.