Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
| Search | Today's Posts | Mark Forums Read
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old August 27th, 2004, 06:37 AM
Registered User
 
Join Date: Aug 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Sorting based on formula in group footer

Hi there,

Please, pelase help me if you can - I've exhausted every resource to try and solve what should be such a simple problem!

I have a table that has Date, SKU, UnitsBought, UnitsSold.

I have a report that groups the data on SKU and sums the UnitsBought and UnitsSold fields in the group footer.

I then have formula called {@Sellthru} that divides the total UnitsSold by the total UnitsBought.

I need the report to sort the SKU goups based on that calculated sellthu but that formula field is not available in the group sort expert.

I have been told that I can do this with SQL expressions but I have no idea how to do this - please can anyone suggest a solution - I have been trying to make this work for 3days now and I really don't seem to be making any progress - I urgently need your help!

Many many thanks in advance...
Nikki x




Similar Threads
Thread Thread Starter Forum Replies Last Post
Footer Image Based on Current Page gothael ASP.NET 2.0 Basics 10 January 23rd, 2008 05:12 PM
Restart new group number in Group Footer sukarso Crystal Reports 2 October 13th, 2006 12:11 PM
sorting duplicates in group by Dean Lovell SQL Language 1 September 7th, 2005 01:30 PM
View records based on formula deepakbhota Crystal Reports 0 August 11th, 2005 08:35 AM
need to Dynamically group sorting ??? kspiderman Crystal Reports 3 May 24th, 2005 03:55 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.