Hi,
Has anyone a suggestion how i do a nl function over different companies, i want to return pieces of different items in any company sorted by pieces.
With Kind reegards
Date
Votes
10 comments
-
Jet Reports Historic Posts by pieces you mean stock?
If so, the best way i think is this one:
NL(..;;;;;"first database";"first company")+NL(..;;;;;"second database";"second company")+…
I think that's the best way to obtain what you need. -
Jet Reports Historic Posts thanks, that works for me.
sorry about my english, im working on it. :)
with kind regards -
Jet Reports Historic Posts No problem, always feel free to add your comments/questions here!
Most of us don't speak English as a primary language. -
Jet Reports Historic Posts NL(..;;;;;"first database";"first company")+NL(..;;;;;"second database";"second company")+…
I found something similair in the doc, and for me the result is very strange: the first row just shows "#VALUE!", the following rows show data - but only from one of the companies (i think, it is the last).
(by the way: i get no further error message besides the "#VALUE!")
Question: can you put "only" such a term into a cell (after =) or do you have to put somthing like np("union"…) around ? -
Jet Reports Historic Posts Maybe you could upload your report so that we can have a look at it.
About sorting by a calculated sum: Jet Reports provides a nice example report when you install Jet Reports. It is in C:\Program Files\JetReports\Reports\Navision and called Jet Sort by Sum.xls
About the language: the common language on this forum is English, so please keep on posting in English. But if you want to add something in German to clarify things, please do so. Some of us do speak German too.
Schone Grusse aus Holland! ;) -
Jet Reports Historic Posts Sorry, please ignore my previous post - it was based on just scanning a - very specific - example from the doc (the pdf-help-file). I just recognized that there they really wanted to add numbers from different sources.
Well, my basic problem is (and i think this is what this thread was about): How can i create a list containig data from more than one company ?
Lets say, i want a list of all vendors of two companies - with (e.g.) name and address.
And, oops, i just found the - very simple - solution: I can place several "independent" queries just below each other, so in design mode e.g. row three contains <company1>, row four holds <company2> etc.
(I did not expect this to work as during the report creation rows four and following are - in a way - completely overwritten with "duplicates" of row three) -
Jet Reports Historic Posts And to take it one step further…
If you enter this in - e.g. - Cell D5:=NL("Rows";"Company";"Name")you would get a function that generates a row for each company in your database.
Then you could add something like this on the same row:=NL("Rows";"Item";;"Company=";$D5)which will give you a link to the Item Table for each company and generates for each Item record. -
Jet Reports Historic Posts Hey Guys,
Just wanted to put "my two cents in" as they say.
Jet Reports recommends that you do NOT put 2 or more NL("Rows") on the same row. This can cause designers to get unexpected results. In the example Hans gave, this would indeed work correctly. However, what we at Jet Reports recommend is
Cell D5=NL("Rows=2","Company","Name")Cell E6=NL("Rows","Item",,"Company=",D5) -
Jet Reports Historic Posts Thanks Sherman, I've seen lots of reports using 2/more NL Rows in a line, but I always tend to put them under eachother so you can see the hierarchy well.
Could it have any impact on performance?
Or would that be minimal? -
Jet Reports Historic Posts Hi,
I've got the same problem like "aschommer"I found something similair in the doc, and for me the result is very strange: the first row just shows "#VALUE!", the following rows show data - but only from one of the companies (i think, it is the last).
(by the way: i get no further error message besides the "#VALUE!")
I'm working with two companies in the same database.
With some tables i've no problem , but with some there is the problem "aschommer" described.
Even when then first company is in an other worksheet then the second company. :shock:
I tried several reports, but I can't get the reason for this.
Any idea?
wirh kind regards from germany
Please sign in to leave a comment.