http://forums.method.me/cs/forums/13.aspxAsk technical support questions, how do I? Questions... Or anything else you want to know from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/28820.aspxThu, 10 Sep 2015 16:57:13 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:28820GloTab0http://forums.method.me/cs/forums/thread/28820.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=28820<p><span id="mce_0_start" style="overflow:hidden;">Awesome! &nbsp;Thanks for the guidance. &nbsp;I will give it a shot.</span></p>http://forums.method.me/cs/forums/thread/28817.aspxThu, 10 Sep 2015 14:40:29 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:28817Method_Morty0http://forums.method.me/cs/forums/thread/28817.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=28817<p><span id="mce_0_start" style="overflow:hidden;">Hey Gloria,<span id="mce_30_start" style="overflow:hidden;"></span></span></p> <p>You can&#39;t accomplish that using Calculated Fields<span id="mce_40_start" style="overflow:hidden;">; y</span>ou would <span id="mce_42_start" style="overflow:hidden;">need</span>&nbsp;to use Scripting.</p> <p><span id="mce_0_start" style="overflow:hidden;"></span>Take a look a<span id="mce_21_start" style="overflow:hidden;"></span>t our Report Designer Help Center<span id="mce_31_start" style="overflow:hidden;"></span> article<span id="mce_54_start" style="overflow:hidden;"></span>s, specifically:&nbsp;<span id="mce_4_start" style="overflow:hidden;"><span id="mce_5_start" style="overflow:hidden;"></span></span>S<span id="mce_3_start" style="overflow:hidden;"></span>olution No. <span id="mce_6_start" style="overflow:hidden;"></span><a href="https://www.methodintegration.com/method/kb.aspx?folder=methodcrm&amp;article=Scripting&amp;id=416#main2">416<span id="mce_3_end" style="overflow:hidden;"><span id="mce_4_end" style="overflow:hidden;"><span id="mce_5_end" style="overflow:hidden;"><span id="mce_6_end" style="overflow:hidden;"></span></span></span></span></a><span id="mce_10_start" style="overflow:hidden;"><span id="mce_32_start" style="overflow:hidden;"><span id="mce_71_start" style="overflow:hidden;"></span></span></span></p> <p><span style="overflow:hidden;"><span id="mce_55_start" style="overflow:hidden;"></span>Scroll down to:<span id="mce_11_start" style="overflow:hidden;"></span> <em><span id="mce_13_start" style="overflow:hidden;"></span>&#39;Calculated script for getting parent<span id="mce_14_start" style="overflow:hidden;"></span>&#39;<span id="mce_11_end" style="overflow:hidden;"><span id="mce_13_end" style="overflow:hidden;"><span id="mce_14_end" style="overflow:hidden;"><span id="mce_33_start" style="overflow:hidden;"><span id="mce_56_start" style="overflow:hidden;"><span id="mce_72_start" style="overflow:hidden;"></span></span></span></span></span></span></em></span></p> <p><span id="mce_26_start" style="overflow:hidden;">You would need to m</span>odify the code to&nbsp;get it working with LineItem<span id="mce_61_start" style="overflow:hidden;"></span>s/Retrieving Child.<span id="mce_37_start" style="overflow:hidden;"><span id="mce_38_start" style="overflow:hidden;"><span id="mce_43_start" style="overflow:hidden;"><span id="mce_44_start" style="overflow:hidden;"><span id="mce_68_start" style="overflow:hidden;"><span id="mce_75_start" style="overflow:hidden;"></span></span></span></span></span></span></p> <p><span id="mce_37_start" style="overflow:hidden;"><span id="mce_38_start" style="overflow:hidden;"><span id="mce_43_start" style="overflow:hidden;"><span id="mce_44_start" style="overflow:hidden;"><span id="mce_68_start" style="overflow:hidden;"></span></span></span></span></span><span id="mce_25_start" style="overflow:hidden;"><span id="mce_27_start" style="overflow:hidden;"><span id="mce_34_start" style="overflow:hidden;"><span id="mce_47_start" style="overflow:hidden;"><span id="mce_63_start" style="overflow:hidden;"><span id="mce_73_start" style="overflow:hidden;"></span></span></span></span></span></span>-- Mortaza<span id="mce_53_start" style="overflow:hidden;"><span id="mce_57_start" style="overflow:hidden;"><span id="mce_58_start" style="overflow:hidden;"><span id="mce_59_start" style="overflow:hidden;"><span id="mce_62_start" style="overflow:hidden;"><span id="mce_66_start" style="overflow:hidden;"><span id="mce_69_start" style="overflow:hidden;"><span id="mce_70_start" style="overflow:hidden;"><span id="mce_74_start" style="overflow:hidden;"></span></span></span></span></span></span></span></span></span></p> <p><span id="mce_53_start" style="overflow:hidden;"><span id="mce_57_start" style="overflow:hidden;"><span id="mce_58_start" style="overflow:hidden;"><span id="mce_59_start" style="overflow:hidden;"><span id="mce_62_start" style="overflow:hidden;"></span></span></span></span></span></p>http://forums.method.me/cs/forums/thread/28808.aspxWed, 09 Sep 2015 17:01:15 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:28808GloTab0http://forums.method.me/cs/forums/thread/28808.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=28808<p><span style="overflow:hidden;"><span style="overflow:hidden;"></span></span></p> <p><span id="mce_45_start" style="overflow:hidden;"><span id="mce_46_start" style="overflow:hidden;"><span id="mce_47_start" style="overflow:hidden;"><span id="mce_48_start" style="overflow:hidden;"><span id="mce_49_start" style="overflow:hidden;"><span id="mce_50_start" style="overflow:hidden;"></span></span></span></span></span><span id="mce_49_end" style="overflow:hidden;">Help! &nbsp;</span></span></p> <p><span id="mce_45_start" style="overflow:hidden;"><span id="mce_49_end" style="overflow:hidden;"><span id="mce_50_end" style="overflow:hidden;"></span></span></span>I <span id="mce_3_start" style="overflow:hidden;">have <span id="mce_6_start" style="overflow:hidden;">successfully&nbsp;</span>c<span id="mce_6_end" style="overflow:hidden;"></span>ustomized our company&#39;s&nbsp;</span>Estimate template <span id="mce_2_start" style="overflow:hidden;"><span id="mce_4_start" style="overflow:hidden;">with Report Designer</span></span>.&nbsp; <span id="mce_7_start" style="overflow:hidden;">However, I <span id="mce_10_start" style="overflow:hidden;">need to have the</span>&nbsp;</span>&ldquo;item&rdquo; <span id="mce_8_start" style="overflow:hidden;">field view/</span>print<span id="mce_9_start" style="overflow:hidden;"> only the &quot;child&quot;&nbsp;<span id="mce_12_start" style="overflow:hidden;"><span id="mce_14_start" style="overflow:hidden;">name/number</span>&nbsp;and not the full &quot;parent&quot; name<span id="mce_13_start" style="overflow:hidden;">/number</span> <span id="mce_16_start" style="overflow:hidden;">details</span>.</span></span>&nbsp;<span id="mce_17_start" style="overflow:hidden;"> Does anyone know how I could accomplish this in</span>&nbsp;Report Designer? &nbsp;Do I need to create a customized &quot;field&quot; in Report Designer, if so, how? &nbsp;<span id="mce_51_start" style="overflow:hidden;"></span>Is there&nbsp;something that<span id="mce_18_start" style="overflow:hidden;"> I&nbsp;</span>need to adjust&nbsp;in QB or Method so that it only<span id="mce_25_start" style="overflow:hidden;"> views/</span><span id="mce_27_start" style="overflow:hidden;"></span>prints the child information?<span id="mce_28_start" style="overflow:hidden;"></span></p> <p><span style="overflow:hidden;">Example:</span></p> <p><span style="overflow:hidden;">Item Field Prints<span id="mce_31_start" style="overflow:hidden;"> - Two Parent Levels</span><span id="mce_30_start" style="overflow:hidden;"></span>:&nbsp;<span id="mce_52_start" style="overflow:hidden;"></span><strong>Aerosol Products<span id="mce_52_end" style="overflow:hidden;"></span></strong>:<span id="mce_54_start" style="overflow:hidden;"></span><span style="text-decoration:underline;">Flow Measurement &amp; Control<span id="mce_54_end" style="overflow:hidden;"></span></span>:<span id="mce_56_start" style="overflow:hidden;"></span><em><strong>1104<span id="mce_29_start" style="overflow:hidden;"><span id="mce_56_end" style="overflow:hidden;"></span></span></strong></em></span></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;">Need it to Print<span id="mce_32_start" style="overflow:hidden;"><span id="mce_33_start" style="overflow:hidden;"> -&nbsp;</span>&nbsp;Child Leve<span id="mce_35_start" style="overflow:hidden;"><span id="mce_36_start" style="overflow:hidden;"></span></span>l<span id="mce_35_end" style="overflow:hidden;"><span id="mce_36_end" style="overflow:hidden;"> Only</span></span></span>: <span id="mce_60_start" style="overflow:hidden;"></span><strong><span style="text-decoration:underline;"></span><em>1104<span id="mce_37_start" style="overflow:hidden;"><span id="mce_41_start" style="overflow:hidden;"></span></span></em></strong></span></span><em><strong><span id="mce_23_start" style="overflow:hidden;"><span id="mce_26_start" style="overflow:hidden;"><span id="mce_38_start" style="overflow:hidden;"><span id="mce_39_start" style="overflow:hidden;"><span id="mce_40_start" style="overflow:hidden;"><span id="mce_42_start" style="overflow:hidden;"><span id="mce_44_start" style="overflow:hidden;"><span id="mce_59_start" style="overflow:hidden;"><span id="mce_60_end" style="overflow:hidden;"><span id="mce_67_start" style="overflow:hidden;"></span></span></span></span></span></span></span></span></span></span></strong></em></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span id="mce_43_start" style="overflow:hidden;"><span id="mce_66_start" style="overflow:hidden;">I appreciate any assistance provided.<span id="mce_68_start" style="overflow:hidden;"><span id="mce_69_start" style="overflow:hidden;"><span id="mce_70_start" style="overflow:hidden;"></span></span></span></span></span></span></span></span></span></span></span></p> <p>Thanks,</p> <p>Gloria</p>