I have created a custom report using Report Designer listing all active Estimates. My dilemma is how do I get ALL items listed on the estimate to pull into the report. I have an estimate with 4 line items but it only pulls 1. I can not seem to find the correct field or proper way to pull all items. As a test, I tried adding [Estimate.EstimateLine.Estimate.Item] multiple times but it returns the same line item multiple time. The other strange issue is if I do have multiple line items in the Estimate the report might pull the 1st, last or anywhere in between line item, there does not seem to be any order.
Any help is appreciated.