Method Community

I added a 'report' at the bottom of my purchase order screen and quote screen so my sales people can view and email the selected form but my report includes ALL quotes.  How do I tweak this so only the selected quote is showing?  Thanks, Laura

I would suggest is taking a look at how this currently done for Invoices, specifically looking at the report properties from the Invoice_PrintPreview screen.  If you dig into the report properties you’ll notice this report takes advantage of the Filter Options.  This filter only includes the Invoice with the RecordID that is currently selected from the screen.

I would suggest you mimic this scenario by following the steps below.

1. Add the Report object to your screen.
2. From the Report Properties select a report or create a new one.
3. Select the table.
4. Select RecordID from the list of available fields.
5. Click Insert Filter.
6. Select Equal to.
7. Select Value From Session.
8. Select Current Screen Active Record.
9. Click Save & Close.
10. Click Next.
11. Click Finish.
    

You’ll likely want to add a button and use the Refresh Report action to update the report as you select each Purchase Order. Use the Show Screen In Pop Up action if the report has a screen of its own, similar to the Print Preview button on the Invoice screen.

Hope that helps,