I have created a nice report which shows me all orders from a certain day including the soled items. I start my report with the Sales header. I would like to sort the orders by country. I know I can do this by alphabet, but I would like to have a certain order withing the sorting rules.
1. I would first like to see all orders fron the Netherlands, then Belgium, then Germany, then Austraia, then Swiss, then France, then Luxembourg and then the US. All the other countries should be listed at last.
2. I prefer to have every country execpt the ones mentioned above, placed in one groep; Rest of the World.
I hope this is possible.
Kind regards
I have enclosed the report, it's in Dutch.
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi,
There is currently no way to create a custom sort order the way you have specified. You have a few options for how you want to do this. All of the options I can think of involve making multiple copies of rows 5-13 on your report. Since you know what order you want the country codes in, you could create an NL function which simple replicates those country codes in cell D5 like this:
=NL("Rows=9",{"NL","BE","DE","AU","SE","FR","LB","US"})
Sorry my formula is in English, but I think you will understand. Then you can create a separate copy of rows 5 - 13 on your report below which retrieves the rest of the country codes where the country code is not equal to those listed above. The real problem with all of the ways to do this I can think of is that your report currently also has a report option which can be used to filter for country codes, and this approach would not allow you to filter for specific country codes. I don't know how important that report option is to you; currently you just have it set to <>'' and of course you could make that work, but I'm not sure how you could create this report in a way to use this custom sort and allow you to filter for specific country codes in the report options. Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
Thanks for looking into my problem. I have tried working with this, but unfortunately it is not the solution I was hoping for. Though your answer that it aint possible at this time, is an answer I can work with. Unfortunately not sattisfying!
Please sign in to leave a comment.