AnsweredAssumed Answered

Writing a script to perform a filtered result in a report

Question asked by dcutlan on Aug 1, 2012
Latest reply on Aug 1, 2012 by philmodjunk

Title

Writing a script to perform a filtered result in a report

Post

I have a report containing the following fields:

  1. Indent Date
  2. Supplier’s Name
  3. Salesperson
  4. Plus other fields with specific data

I have created two Global fields:

  1. Begin Date
  2. End Date

I want to create a script where, when the report is opened, the user can:

  1. Enter a Begin Date and an End Date, then
  2. Click on Button 1, which, not only finds the records by the above dates but also sorts them by Supplier

I then want to create Button 2, which when clicked on asks the user to enter the Salesperson for which the report is required. In other words shows only the records related to that salesperson.

The final report needs to show the records

  1. Between (and including) the two Begin Date and End Date (These are Indent Dates)
  2. Sorted by Supplier
  3. Filtered to only show records for the selected Salesperson.

Can anyone please help me write the scripts for the above?

Many thanks

David Cutlan

 

Commission_Projected_Report.JPG

Outcomes