0

Getting data from different companies together in one list

Jet Reports Historic Posts

July 21, 2010 18:34

None

Follow

I have a NAV-Database with several companies. Now I want the Ressource-table-entries of two companies in one list sorted after a certain field.

Is there are way to get this two NL-Rows-Formulars together with jetreports and sort them in one list. I have tried several things to get them with two NL-Functions in one normalized table and I put a sorted Excel-table over them. But the excel-table-feature obviously not works with jet formulars and the table-formatting is always gone after calculating the report and getting back to design mode?

Any suggestions in this community to this topic?

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts July 29, 2010 18:50

  Hi Michael,
  
  You will need to create the lists from each company and then union them together in order to get a combined list.
  
  Step 1:
  Create the lists from each company. I would try using NL(Filters) to create your lists.
  
  Step 2:
  Use an NP(Union) to compbine the lists.
  
  Step3:
  Place the NP(Union) inside an NL(Rows) to list out the results.
  
  It will look something like this:
  
  =NL(Rows,NP(Union,B2,B3))
  Where B2 and B3 contain the NL(Filter) functions.
  
  I hope this helps!