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?

       

      Thanks,

      Cassandra