Community
Showing results for 
Search instead for 
Do you mean 
Reply

Report, Detail Section, Sort

Avid Listener
Posts: 43
Country: United States

Report, Detail Section, Sort

Hi,

 

I'm looking for a statement that says, sort the detail section chronologically by a date field.

 

Report format is pretty simple.  Showing Opportunity detail for a Contact.

 

There is only one opportunity per contact.  I am able to add in the product detail in the detail section.  Now I just need to sort by a custom field equal to date_received and want to sort chronologically within the detail section?

 

Anybody know how to do this?

 

Thanks,

 

Michael

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Report, Detail Section, Sort

Typically I  would tel you to add sections to the report to add the sorting that you want. However, if I understand what you are trying to do with the report, you won't be able to accomplish that. You can only globally sort the report by fields in the base field for the report, contact, company, group or opportunity.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Avid Listener
Posts: 43
Country: United States

Re: Report, Detail Section, Sort

Thanks, Roy,

 

You're right, that won't work.  It appears that the opp. products detail live in their own world.  So, the sort would have to be an expression in the section properties.  Any idea how i might go about writing that?

 

Thanks,

 

Michael

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Report, Detail Section, Sort

The products are in a separate table, it'a not an issue of an expresstion.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Avid Listener
Posts: 43
Country: United States

Report, Detail Section, Product Detail, Sort

Does anybody know how to sort by a custom date field added to the Product Detail Section of an Opportunty?

 

If you do not know how to do it, or don't want to share the answer,  please do not respond.

 

Thanks,

 

Michael