Method Community

If I want to get data from Transaction and Bill Line Item tables how do I join and get a dataset ? I also wantto know how to add a date filter to  the report so that user can select a date range and this date range to be part of the data selection criteria?

Thanks 

 Hello Kandy,

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: http://www.methodintegration.com/cs/forums/p/381/1191.aspx#1191

For the 2nd part of your question on how to add a date filter to a report, you can do this in the 'Generate Report' 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 'Fields in Table' selected is a date field, and for the Condition Statement, 'Within Date Range' is selected.

As an alternative; you can also use a grid to filter records within a date range and then export to excel.

Hope this helps.