10 Replies Latest reply on Oct 4, 2017 1:58 PM by Souvik Manna

    Filtering data from Union Report

    Souvik Manna

      Hi,

       

      I have a scenario where I am building a report that does union of two reports - "Open Purchase Order" and "Closed Purchased Order" - built from two different subject areas.

       

      "Closed Purchase Order" has a column "Received Date" and also a filter on this column as "is prompted".

       

      "Open Purchase Order" does not have this column and instead has a hard coded date value.

       

      From the dashboard, when I do not select any value for "Received Date", both the reports returns records which is expected.

       

      But when I select some date value for "Received Date" on dashboard, "Closed Purchase Order" report is filtered as per the date, while all the records from "Open Purchase Order" reports are returned.

       

      I want to put some restriction so that when a "Received Date" is passed from dashboard, union report will return only the valid records from "Closed Purchase Order" report and no record from "Open Purchase Order".

       

      Any idea how I can achieve this?