Help in expression

[#1]

Dear All ,

I have two table one consist of order and other consist of invoice.

I have joined them through left join order to invoice.

I have ten reports where i need only order details but there is one final report which required invoice wise details.

So, there are many orders which are pending fopr invoicing.

Please let me know how to avoid them pivote table.

as i have tried invoice_id<>'' in expression but doesnt work for this.

Plerase help .

Thanks in advance .

[jagan · Accepted solution]

Hi,

I think you want to display only Invoices which has InvoiceID.  For this use invoice_id as Dimension and select "Suppress When Value is Null" option in Dimension tab for invoice_id field.

This will suppress all Null values.

Hope this helps you.

Regards,

Jagan.

[#3]

Thanks a lot jagan

With Regards

Pramod Kumar

[jagan]

Hi,

Close this discussion by selecting "Correct Answer", if it solves your problem, it helps others to find solution for similar problem.

Regards,

Jagan.