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/3167.aspxFri, 13 Aug 2010 14:34:03 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:3167Anonymous0http://forums.method.me/cs/forums/thread/3167.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=3167<p>&nbsp;Hello Kandy, </p> <p>To link 2 tables you can use linked fields. Please refer to the following post to learn more about linked fields and how to use them: <a href="http://www.methodintegration.com/cs/forums/p/381/1191.aspx#1191">http://www.methodintegration.com/cs/forums/p/381/1191.aspx#1191</a></p> <p>For the 2nd part of your question on how to add a date filter to a report, you can do this in the &#39;Generate Report&#39; action. After you have created your report in the Method Report Designer you can add the Generate Report action to a button to pull the report. When setting up this action, ensure that the &#39;Fields in Table&#39; selected is a date field, and for the Condition Statement, &#39;Within Date Range&#39; is selected.</p> <p>As an alternative; you can also use a grid to filter records within a date range and then export to excel.</p> <p>Hope this helps. </p>http://forums.method.me/cs/forums/thread/3160.aspxThu, 12 Aug 2010 18:48:32 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:3160Kandy080http://forums.method.me/cs/forums/thread/3160.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=3160<p>If I want to get data from Transaction and Bill Line Item tables how do I join and get a dataset ? I&nbsp;also wantto know how to add a date filter to&nbsp; the report so that user can select a date range and this&nbsp;date range to be part of the data selection criteria?</p> <p>&nbsp;</p> <p>Thanks&nbsp;</p>