Count records in Query

navuser1

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.

navuser1

I have attached the query structure as well as my code for review.


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);