i have loaded a table and i want calculate the records without using count function?how in ui level?

[#1]

i have loaded a table and i want calculate the records without using count function?how in ui level?

[MayilVahanan]

Hi

Try like this

1. Load *, 1 as Records from tablename;

Sum(Records) as expression

2. Load RowNo() as Records from tableName;

     Max(Records) as expression

3. There is a system fields, u can use it that also.

[MarcoWedel]

NoOfRows()

[ashfaq_haseeb]

Or use this macro

Sub CountRow

set chart = ActiveDocument.GetSheetObject("CH01")

set v = ActiveDocument.Variables("RowsNum")

v.SetContent chart.GetNoOfRows,true

End Sub

Regards

ASHFAQ

[ecolomer]

=Max(RecNo())

=Max(RowNo())

[#6]

Hi Manoj

you can perform below steps

Load *, Number = take as the Table records

Sum(Records) use as expression

2. Load RowNo() as Records from TableName;

     Max(Records) as expression

[jagan]

HI,

Try like this

TableName

LOAD

*

FROM DataSource;

LET vRowsCount = NoOfRows('TableName');

Now in UI just use vRowsCount.

Hope this helps you.

Regards,

Jagan.