Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i want to know the each table distinct count of rows in text object
how can i do this?
Thanks
Sony
This is a script function which can be used to create a variable to store the row count of each table and then displayed in the text box object on the front end
LET vNoOfRowsTable1 = NoOfRows('Table1');
and then display this in the text box object
May be do a distinct count of the unique identifier from each table... make sure that this field is not a key field which connects two tables...
but what is =Numofrows function gives?
and how to use that?
I believe it gives the number of rows in a particular chart when used on the front end... read here
This is a script function which can be used to create a variable to store the row count of each table and then displayed in the text box object on the front end
LET vNoOfRowsTable1 = NoOfRows('Table1');
and then display this in the text box object
Okay thanks sunny
can i use this in text object like this?
=$(NoOfrows) ? is this correct?
Well depending on your variable... you can do this vNoOfRowsTable1 or $(vNoOfRowsTable1)... one of the two should work....
thanks worked