my first week with QV was great and i found a lot of help here in the community so thank everyone for that
I fixed all the problems my report had except one that is not even a real problem but just an annoying thing ^^.
Description: The report is about Requisition's - Purchuase Orders - Invoices - Payments.
Requisitions Purchuase Orders and Invoices are perfect and i visualize all the needed data perfectly.
Instead in the payments part i have all the payments, even the one's not linked to any requisition or purchuase order (random example electricity invoice).
This falses my result when there is no selection made.
The aggregation system of QV at this point does something wird. Group all this invoices without project in a project " - " and shows the amount of the invoice, the invoice_id but not the invoice_num (even if is present in oracle) and marks it again with a " - ".
I cant make a SQL condition on the script like where project_id = NULL because in the table i use is not valorized and all the project_id are null so the query wont return anything.
Does anyone have an idea on how i can exclude this data from my report. A script condition will be even better so the data is not loaded at all.