Count Rows in Ad Hoc Report

[cbaqir]

I have an Ad Hoc report that I need to state how many rows are included in the file so that the user knows if it will exceed the max rows that Excel can handle (something like 1.048 m I think).

I tried creating a variable called vGetFields =GetFieldSelections(_Dimension, ' & ',100)

and then a Text Box: ='Number of Lines ' & Count(distinct $(vGetFields))

but it is not working as I intended. For example, if the Dimensions I have selected result in one row of data, it should read 1.

Any ideas?

Thanks,

Cassandra

[maxgro · Accepted solution]

maybe Gysbert's answer can help you

How to count rows from conditional chart table fields in text object