Grouping in section report

Grouping in section report

Posted by: christy on 24 March 2018, 8:32 am EST

• 

  christy

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 24 March 2018, 8:32 am EST - Updated 30 September 2022, 6:24 pm EST

  when am trying to add grouping for a field gender ,its not getting grouped.it showing the field value again

  

  1920×1040 78.6 KB

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 25 March 2018, 11:55 pm EST

  Hello,

  In a section report, data is grouped in the order in which it is fetched in the raw form. Therefore, for best results, while setting the SQL query in your report data source, order the data by the grouping field. For example., SELECT * FROM Table ORDER BY Gender.

  Hope it helps.

  Thanks,
  
  Mohit