Hi Team,
Can any one help me how to approach my requirement explain below!
Table1: All invoices(Invoice Approved)
Table2: Invoice History table(Invoice Integrated)
Actually i create report by appending above mention tables and developed the report. and now i got requirement like in one table i have invoice name column and client column and Purchase order column like true/false for invoice name column in All Invoice table. But in second table invoice history table also have invoice name column and client column but there is no Purchase order column in the History table. in report I created two individual cards and displaying respective count in the card and added on button on top of the cards and while clicking on respective cards iam showing the details on invoice name and client and purchase order details in table visual like hide and show in the report. one card is (Invoice Approved) another one is (Invoice Integrated).
While i clicked on Invoice approved card iam displaying respective details in table visual and in table visual i added purchase order column in table it's is showing respective purchase order details in the table because it is belong to All invoice table.
While i clicked on Invoice Integrated card iam displaying respective details in table visual and in table visual i added purchase order column in table it's is showing respective purchase order details is showing empty field in the visual because it is belong to Invoice History Table there is no purchase order column.
Can any one help me to show those purchase order details in Invoice Integrated table also.
