0

Different companies in different sheets

Jet Reports Historic Posts

August 11, 2009 13:21

None

Follow

Hi there!

I need your help with a new report I have to create:

There is this Navision database with 70-80 companies and I have to filter a number of these companies to different sheets. e.g. 20 in first sheet, 15 in second, 40 in third and 5 in the last.

I always use an options sheet for ease of use by the user to enter the filter criteria. So, my first attmempt was to provide different company filters for each sheet (lookup) which linked to the rows-companies for each sheet. This does not work…moreover, the biggest group with 40 companies is not accepted (maybe because of a limitation of characters).

I used these:

per sheet –> =NL("Rows","Company","Name",,,,,,,,,,,,,,,,,,,"Name",Options!$D$10) where the cell in options sheet contains the list of companies separated by shift pipe '|' (company1|company2|company3)

for the big group I used four cells of the same code, to accept the length of characters in company names
–> =NL("Rows","Company","Name",,,,,,,,,,,,,,,,,,,"Name",Options!$D$12)
=NL("Rows","Company","Name",,,,,,,,,,,,,,,,,,,"Name",Options!$D$13)
=NL("Rows","Company","Name",,,,,,,,,,,,,,,,,,,"Name",Options!$D$14)
=NL("Rows","Company","Name",,,,,,,,,,,,,,,,,,,"Name",Options!$D$15)



Filtering Company or Company= does not work and receive #VALUE!
Eventhough I receive no error message like #VALUE! when I use Name filter, the function works like there is no filter and extracts the information from all companies in database.



Using Jet Reports 7.1.0 build 1812

Any help will be really appreciated :)

Thanks in advance!

• Facebook
• Twitter
• LinkedIn

7 comments

• 
  Jet Reports Historic Posts August 12, 2009 10:32 Official comment

  Putting the Company name between single quotes will also work xxxx|'Company (Demo)'

• 0
  
  Jet Reports Historic Posts August 11, 2009 13:33

  Can you post the report so we can see what you are really trying/doing…

• 0
  
  Jet Reports Historic Posts August 11, 2009 13:51

  Of course

  • JET Invoice DB_LT_V1_IK_1.2.xls
• 0
  
  Jet Reports Historic Posts August 11, 2009 14:09

  If the companies are not going to change, this option may work for you - or at least give you somewhere to start.

  • Example.xls
• 0
  
  Jet Reports Historic Posts August 11, 2009 14:23

  If the companies are not going to change, this option may work for you - or at least give you somewhere to start.

  
  Thanks for the input. That is an interesting way to build sheets but when I used it the company filter still does not work: each sheet extracts ALL companies information
• 0
  
  Jet Reports Historic Posts August 12, 2009 09:48

  OK I think I found the solution…
  
  The initial formula used is fine. The problem is with two companies in the filter that contain paranthesis () in the name. I will ask the renaming of these two if there is no other solution to include these under the filter.
  
  Thanks for your prompt replies everyone :)

• 0
  
  Jet Reports Historic Posts August 13, 2009 08:53

  Thanks Sebastian!
  
  I will try that as well. ;)
  
  
  EDIT: worked like a charm :P