Print Page | Close Window

Sort on formula field

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9198
Printed Date: 29 Apr 2024 at 5:37am


Topic: Sort on formula field
Posted By: aekelund
Subject: Sort on formula field
Date Posted: 23 Feb 2010 at 7:13am

The issue I am having is I have a formula field that calculates a value based on the sum fields in a group.  I am trying to get the report to sort based on this formula field (without any success).  I have tried everything that I can think of to try and sort based on this field can any one please help me. Below is the forumla that I used for my calculation.

IF Sum ({viewAssy.hrsworked}, {viewassy.lineNumber}) = 0 Then 0
ELSE (Sum ({viewAssy.earnedHrs}, {viewassy.lineNumber})/Sum ({viewAssy.hrsWorked}, {viewassy.lineNumber}))*100
 


-------------
Andrew


Print Page | Close Window