I need to show the Price page description for both the Cost page and the price page. After selecting the Price page description for the Cost page, I created a new join of Price page as Price_Price_Page, all unused fields show in the selection of add field from existing database column, but it seems once a field is used in a report, it cannot be used again. Any ideas?
Here is the sql I used.
)
left join price_page on (
invoice_line.cost_price_page_uid = price_page.price_page_uid
)
left join price_page AS price_price_page on (
oe_line.price_page_uid = price_page.price_page_uid
)