Count records in Query

navuser1navuser1 Posts: 1,273Member
Dear Sir,

I have designed a simple Query in NAV 2016 Database. It gives me the Total Amount on the Basis of Grouping on Two Columns. I just want to know the total number of Row the query gives.

How do I get ?

Kindly reply.
Now or Never

Answers

  • navuser1navuser1 Posts: 1,273Member
    edited 2019-05-18
    I have attached the query structure as well as my code for review.
    rvodr054cg16.jpg

    Sample code
    CEWiseWIPGLGrouping.SETFILTER(CEWiseWIPGLGrouping.G_L_Account_No_Filter,GLAccFilter);
    CEWiseWIPGLGrouping.SETRANGE(Global_Dimension_1_Code_Filter,ShortCutDimCode1);
    CEWiseWIPGLGrouping.SETRANGE(Global_Dimension_2_Code_Filter,ShortCutDimCode2);
    CEWiseWIPGLGrouping.OPEN;
    WHILE CEWiseWIPGLGrouping.READ DO BEGIN
      MESSAGE('%1',CEWiseWIPGLGrouping.Count1);
    

    Now or Never
Sign In or Register to comment.