I am trting to create a report with the following:
-Articlenumber
-Articlename
-Catalogue nr
-alternative number
-Available stock
-Turnover 2007
-Turnover 2008
This is no problem and I receive a nice report. But we have three different catalogue's, 1,2,3 and I want to sort them so I have an overview per catalogue. I know that for sorting a report I can use the "+ or -" symbols, but in this case I don't know where to place them. I cant place them in the NF-funtion ( in this case the on Catalogue nr ), can I?
I hope someone can show me what I am doing wrong. I have uploaded my file so you can see for your self.
Date
Votes
6 comments
-
Jet Reports Historic Posts Hallo en welkom! ;)
Your sorting should be defined when fetching the records, so in your NL function.
C5 should become:=NL("Rijen","Artikel",,"Webomschrijving","1","+Catalogus web","*")
So you add the field you want to sort on as a filter field, but with a filter on "*" because you want to fetch all records.
It could be interesting here to look into the "NL Sheets"/"NL Bladen" functionality.
PS: be aware that the reference in F5 isn't right -> should refer to C5 instead of C1
Lots of succes and don't be afraid to ask! -
Jet Reports Historic Posts Thank you very much Jan, it worked.
No idea how the mistake in F5 was made, but thanks for your attention. -
Jet Reports Historic Posts I still do have a question. Currentlly I am working on a new project where i want to use Jet for. I want to see the turnover per country for 2007 and 2008. I am now at the point that I manage to create this file, but all the countries are mixed. I rather see it that Jet sorts the country's by name and even more nice would be that Jet creates a total per country for 2007 and 2008. Sure I can do the sorting by Excel, but thats not why we boutht Jet Reports :)
I am trying to work this out all morning and even with my training book I cant seem to figure out what I am doing wrong.
Any advice would be helpful. -
Jet Reports Historic Posts You should save the report in design mode and post it again, I can’t get your NL function.
For countries I like to start with sheets, and then have a “dashboard” sheet on the end.
Columns per country are nice too.
In this case it’s not so clear to me what you want to obtain?
You want the turnover but by what grouping? (ex product category, customer type,…?)
Anyway, it could look like this:
(nl(columns=2, country code)
BE TOTALS
2007 2008 2007 2008
(nl rows, ex product group)
Product group A
Product group B
Is it something like that you want? You should look into the NL(“Columns”).
If it’s what you’re looking for, I’ll be happy to work it out a little bit more.
If that’s a little cryptic, just let me know. -
Jet Reports Historic Posts I adjusted the file so you could see the NL function.
What I want to create is a file with the turnover per product per country. Beside the turnover I would like to see the total ammount of sold items per product for 2008.
I just sometimes can't see the logic between the posibilities in Jet and Nav. Especially between all tables. -
Jet Reports Historic Posts This should get you started :)
Edit: watch out, it's possible you have to convert it (regional settings/language)
Please sign in to leave a comment.