Problems Get number of records

[#1]

Hi,

I've a problem counting records. I need show a table when the result is less than 1.000.000 records. I was trying but it was imposible somebody can help me please.

[jonathandienst]

Hi

If you are asking for help in counting the records in your model (or table?, in script? ??) you need to provide more information about your model and your requirements and preferably a meaningful sample of your model.

Regards

Jonathan

[Anonymous]

well.. the way i understand this is..

you can have a column like a transaction id or a row number...

and the use it in the Layout -> conditional show option...

something like below..

IF(Count(TxID) <= 1000000, 1, 0)

this will hide the entire table box object itself.. you might have to figure out what to show when the result exceeds 1000000.

hope that helps..

[#4]

It Works. the problem it was the sintaxis 

IF(Count([CUPS]) <= 100, 1, 0) <> IF(Count(cups) <= 100, 1, 0)

thanks!!