Hello dear community,
I have a problem with counting the records/members in a crosstab. I have 5 filter criteriums:
Project, OEsG, Costcenter, Group and VOS.
Example:
I filter project = '12345' or project = '56789' works fine, also the count works fine. (I made the count records in a TextBox, where I can see the number of rows). For example here I get a count of 1000 members. Now I want to filter a numeric range with the filter criterium 'VOS' between 300 and 400.
The members in the crosstab change to for example 500 records, but the count in the textbox is still showing 1000. And this only happens when I try to filter a range.
When I make the filter criterium VOS = 300, 310, 320, 320 ... 400, then it works fine.
-> The rows in the crosstab change to 500 AND also the count in the textbox changes to 500.
I only have the count problem, when I apply a range.
Can you help me please?
My code for the record count is like:
DS_1.reloadData();
DS_1.loadDataSource();
var getarray = DS_1.getMembers("_wHEBMOoLEeaB-JtworBC7A", 20000);
var membercount = getarray.length;
DS_1.setText("Number of Rows: " + membercount);
DS_1.setVisible(true);