1 Reply Latest reply: Dec 4, 2015 12:32 PM by Massimo Grossi RSS

    Count Rows in Ad Hoc Report

    Cassandra Baqir

      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?