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 February 10th, 2005, 01:15 PM
Authorized User
 
Join Date: Jul 2003
Location: Juarez, Chihuahua, Mexico.
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Tere
Default Sort order Question

HI!!
I am using CR 8
How can I sort a report by a formulate column?

I have a report like this

group Header1 Sale %Sale Formulate example:
----------------------------
 LOPEZ 10 16.6% (10/60)*100
 ALTAVISTA 20 33.3%
 HENEQUEN 5 8.3%
 TORRES 25 41.6%
----------------------------
group Footer1 60


I want to show the information sort by %Sale column this column is a formulate: sale/sum(sale,group1)*100

group Header1 Sale %Sale Formulate example:
----------------------------
 TORRES 25 41.6%
 ALTAVISTA 20 33.3%
 LOPEZ 10 16.6% (10/60)*100
 HENEQUEN 5 8.3%
 ----------------------------
group Footer1 60

When I uses the Sort Order Icon I don't have the option of do that, how can I sort the report using this column?

  #2 (permalink)  
Old February 14th, 2005, 03:18 PM
Authorized User
 
Join Date: Dec 2004
Location: flushing, ny, USA.
Posts: 80
Thanks: 0
Thanked 0 Times in 0 Posts
Default

if ur %Sale is a formula fld, hen u can sort ur report on formula. in the sorting expert, select this formula.if by chance if u can'r see this formula, try to create again and then sort.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic sort order or sort datatype kapy_kal XSLT 2 September 18th, 2007 02:10 PM
How to sort order in local language. surjit singh .NET Framework 2.0 2 July 21st, 2007 01:54 AM
sort recordset in different order pablohoney Classic ASP Databases 0 December 29th, 2005 08:32 PM
Access 2K Sort Order rgerald Access VBA 0 August 12th, 2004 10:37 AM
document node order vs sort node order. ladyslipper98201 XSLT 2 June 5th, 2003 11:06 AM





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