Hello, I want to make a top 10 list from a particular table. In this table I have the field Number (unique), description … I have to find a way to count the different numbers. When I find one count = 1, a second count2 = 1, again the first count = 2 … Anyone good advice ? thx
Hi. I am not quite sure what you are after but you should probably be looking at temporary table to do this. How? Define the temporary table as the same type you are working with, select properties from the variable (Globals/locals) and put temporary as true. Then you can insert data into this table and work with it, but it will never be inserted into the database (just exist in the client memory). If you can explain better how your data is then I will be happy to assist you.
Hey, take a look at the standard reports 111 - Debitor - Top 10 Liste, 311 - Kreditor - Top 10 Liste and 711 Artikel - Top 10 Liste. Regards Fred
Sorry, if I was not clear in my question. I want to make a top 10 of our little system here. Which person has the most questions. I have in my table where my report is based on following fields. Number, description… . I will ask my question again: How can I count the same numbers. Can I use an array ? how ? thx in advance.
I also don’t understand really what you want but i think you should set a filter on number and then count the records in table. Write this result into an temporary table and sort this temp. table by the counts from the other table. Hope this helps
If i understand you rigth, you have a table similar to the following : Number integer primarykey Person code Question text and you have NO list of all persons which are in this table. Are you only interested in the top 10 of users with most questions or is better to have a full list and only print out the first 10 ?
It is the same for me. I just want to be able to understand it, so what is the easiest ? Thx for your help.
For simple understanding of this take the comment of Friedhelm and have a look inside these reports. if you need your own programmed solution then lets discuss later