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/14155.aspxThu, 18 Oct 2012 18:55:26 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:14155Anonymous0http://forums.method.me/cs/forums/thread/14155.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=14155<p><BLOCKQUOTE><div><img src="/cs/Themes/methodtheme/images/icon-quote.gif"> <strong>Blake C:</strong></div><div>Is this possible? Can I send in filter criteria for multiple tables in a report?</div></BLOCKQUOTE><span id="mce_1_start" style="overflow:hidden;"></span></p> <p><span style="overflow:hidden;">No. &nbsp;</span>Through the Generate Report action you can only filter on one table but you do have access to add a <em>Where</em> clause. &nbsp;What you might be able to do is filter jobitems on the detail report level?</p> <p><img src="http://i.imgur.com/z7PrD.png?1" width="500" height="254" alt="" /><span id="mce_5_start" style="overflow:hidden;"><span id="mce_6_start" style="overflow:hidden;"></span></span></p> <p>And if you needed to filter based on criteria from a Method screen then create a custom field in your ActivityJobItems table, populate it before the generate report action, then pull that data out to use as criteria for your filter.</p> <p>~C</p>http://forums.method.me/cs/forums/thread/14148.aspxThu, 18 Oct 2012 14:45:42 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:14148Blake C0http://forums.method.me/cs/forums/thread/14148.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=14148<p><span id="mce_0_start" style="overflow:hidden;">I&#39;m still trying to build a report the way I want. I&#39;m currently filtering a report with a list of RecordIDs for the Activity table. However, in the report I have also have the JobItems table unattached. I&#39;m trying to filter this table from the Generate Report action as well.</span></p> <p><span id="mce_0_start" style="overflow:hidden;"></span>Is this possible? Can I send in filter criteria for multiple tables in a report?</p> <p>I really don&#39;t think I&#39;m trying to do anything crazy here...simply showing a handful of related line items across multiple &quot;master&quot; records.</p> <p>At this point, I&#39;m getting really close to creating a custom report table structure on the fly to report from.</p> <p></p> <p>Thanks</p>