1 Reply Latest reply: Mar 20, 2012 2:38 PM by Brandon Apperson RSS

    how can i store a total no of rows of a straight table in a variable?

    Sushil Kumar

      Hi All,

       

      I have a straight table. i want to store the no of rows in a variable. how can i achieve this?

       

       

      Thanks

      Sushil

        • Re: how can i store a total no of rows of a straight table in a variable?
          Brandon Apperson

          One way you could work around this is to create a variable in the script:

           

          If you had a table named table.

          Let a = NoOfRows('table')

           

          A more complicated way that doesnt involve the script involves the use of a macro.

           

          Create a new variable called NoOfRows, leave the definition blank.

           

          Open up the macro menu and type in the following:

           

          sub temp

           

          set obj = ActiveDocument.GetSheetObject("CH01*")

          ActiveDocument.Variables("NoOfRows").SetContent obj.GetRowCount, true

           

          end sub

           

          *Note that you will name this the object ID of whatever your straight table is.

           

          Now open up settings->Document properties...->OnAnySelect**->Add Actions...->External->Run Macro->Macro name is temp then apply down the list.  Now whenever you make a selection it will store the number of rows from "CH01" or whatever your straight table is into the variable NoOfRows.

           

          **Keep in mind you can change when the macro gets run for your preferences by defining the same thing for OnOpen, etc..

           

          I have attached a working .qvw for additional support

           

          Hope this helps!