http://forums.method.me/cs/search/SearchResults.aspx?o=DateDescending&u=15011Search results by user ID 15011en-USCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/p/12137/35571.aspx#35571Thu, 21 Dec 2017 20:59:42 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:35571DanL<p><span id="mce_0_start" style="overflow:hidden;">I have <span id="mce_1_start" style="overflow:hidden;"></span>created a custom report using Report Designer<span id="mce_2_start" style="overflow:hidden;"> listing all active Estimates. My dilemma is how do&nbsp;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&nbsp;to find the correct field <span id="mce_5_start" style="overflow:hidden;">or proper way&nbsp;</span>to pull all items. As a test, I tried adding&nbsp;&nbsp;<span id="mce_2_start" style="overflow:hidden;"><span id="mce_3_start" style="overflow:hidden;">[Estimate.EstimateLine.Estimate.Item] multiple times but it returns the same line item multiple time. The other strange&nbsp;</span></span>&nbsp;<span id="mce_1_start" style="overflow:hidden;">issue is if I do have multiple line&nbsp;items in<span id="mce_6_start" style="overflow:hidden;">&nbsp;</span>the&nbsp;<span id="mce_7_start" style="overflow:hidden;">Estimate the&nbsp;</span>report might pull the 1st, last or anywhere in between<span id="mce_8_start" style="overflow:hidden;"> line item, there does not seem to be any order.&nbsp;</span><span id="mce_5_start" style="overflow:hidden;"></span>&nbsp;</span><span id="mce_0_start" style="overflow:hidden;"><span id="mce_9_start" style="overflow:hidden;"></span></span></span></span></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;">Any help is appreciated.&nbsp;</span></span></span></span></p>