0

Report with outstanding amounts accross companies

Jet Reports Historic Posts

December 03, 2011 11:08

None

Follow

Our customertable is shared across all companies. I want to create report with all the outstanding amount for an customer for every company.

It must like below:

customer 1234 Company A € 500.00
customer 1234 Company B € 250.00
customer 1234 Company C € 450.00
customer 5678 Company B € 350.00
etc.

I know how to create an report with all the amouts in colums but now i want it in rows.

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts December 07, 2011 09:13

  D4 = NL("Rows=2","Customer","No.")
  D5 = "=$D4"
  E5 = NL("Rows","Company","Name")
  F5 = NL("First","Customer","Outstanding Orders","Company=",$E5,"No.",$D5)