Skip to main content
Solved

How to Sort based on the Item parent class on a report


Forum|alt.badge.img

I am trying to solve this below problem on the Project quote form and seemed to be going in circles for some time now hence posting this.

I am trying to Print a project quote and group this based item classes. This is grouping correctly, however the issue I am having is to print the description of the parent item class description in the group header. This is currently printing child item class description.

Because the way the lines are being sorted the child item class is picked based on the line sequence.

The outcome I am expecting on this is the first image the item class should be Video conference equipment, second image should be source equipment.

Any suggestion would be appreciated. 

Following things I have tried are as below (Images as below)

  1. Different sorting used to sort based on Qty and Total amount.
  2. change groupings 

 

 

Grouping and sorting as below.

 

 

 

Best answer by nhatnghetinh

Hi @amitkaryekar 

You add Curyamount into the first Group

 

Best Regards,

NNT

View original
Did this topic help you find an answer to your question?

4 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+10
  • Captain II
  • 389 replies
  • July 26, 2024

Hi @amitkaryekar 

I see that Group "ProjectTask" is above Group "ItemClass" so the sort will prioritize Group "ProjectTask" first.

 

Best Regards,

NNT


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 10 replies
  • July 29, 2024

Thanks for your reply.

Understand the part of sorting priority, is it possible though that the to sort based on amount, as when i put the curyamount on for sort, When it is grouped by based on the Item class it picks item class of the zero dollar amount whose item class is called client supplied

What i will have to do sort based on Curyamount?


nhatnghetinh
Captain II
Forum|alt.badge.img+10
  • Captain II
  • 389 replies
  • Answer
  • July 29, 2024

Hi @amitkaryekar 

You add Curyamount into the first Group

 

Best Regards,

NNT


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 10 replies
  • August 1, 2024

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings