Solved

Sort Datatable in Crystal Report

Posted on 2010-09-08
10
858 Views
Last Modified: 2012-06-22
Hi

I have created a datatable with 10 lines of data in it.

I then sort the datatable.
dtResult.DefaultView.Sort = "avgmp desc";

I then bind the datatable to a datagrdview.
The results display correctly in a datagridview.

However, if I display this datatable in a Crystal Report the results are unsorted.

Why? and how do I order it for the report?
0
Comment
Question by:elmbrook
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 2
10 Comments
 
LVL 8

Expert Comment

by:kingjely
ID: 33633485

Hi there,
Put the field on the report,
Click the record sort expert  a-z button up the top..
Then add your {Table.avgmp} field in and choose 'Descending.'

Does this work?


0
 
LVL 8

Expert Comment

by:kingjely
ID: 33633500

Otherwize

Add your {Table.avgmp} field.

Then
Go to Group Expert, Add {Table.avgmp} field as a Group and choose 'Options' and Choose 'Origional Order'
Then righ click and suppress the group GH1#{Table.avgmp}.

Kj
0
 

Author Comment

by:elmbrook
ID: 33633524
Hi King

Yes that did work. Never realised you could sort it from the report... My bad.

However, Can I do this programically? Before I display the results I have 3 different sorting options for the user.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 8

Accepted Solution

by:
kingjely earned 0 total points
ID: 33633578
Hi is okay,
I'm sure you can do it in C# but im not too sure how..

I do my sorting programatically in crystals,

By 3 different sort options, do you mean Asc, Desc, Orig order,
Or 3 different sort options fields, as in,  by UNITS, PRICE, DATE ?



0
 

Author Comment

by:elmbrook
ID: 33633593
Hi King

I figured it out myself.

The code to sort is below:
                FieldDefinition fd;
                fd = cryRpt.Database.Tables[0].Fields[_sortfield];
                cryRpt.DataDefinition.SortFields[0].Field = fd;
                cryRpt.DataDefinition.SortFields[0].SortDirection = CrystalDecisions.Shared.SortDirection.DescendingOrder;

Where _sortfield is my field to sort on. as in Units, Price, Date.

Thank you for pointing me in the right direction. I will credit the points to you anyway.
0
 
LVL 12

Expert Comment

by:rgn2121
ID: 33633594
This is VB.Net code, but it should give you an idea of programmatically sorting...

'ReportDocument.SetParameterValue("Sort Criteria", "My Sort Field")
'Dim crSortField As CrystalDecisions.CrystalReports.Engine.SortField
'ReportDocument.DataDefinition.SortFields(1).SortDirection = CrystalDecisions.Shared.SortDirection.DescendingOrder
 You could do without the parameter if you aren't going to offer dynamic sorting to the end user.  I have a web link that talks about this if I can find it...
0
 
LVL 8

Expert Comment

by:kingjely
ID: 33633597

If you want to see how it works,
By 3 different sort options, do you mean Asc, Desc, Orig order,

Make a NEW parameter called {?SORTORDER}
'save and close'

Then
In your group expert where you have your group {Table.avgmp} go to options, check Use formular X2

put this formular in;

If {?SORT} = 'ASC' then crAscendingOrder else
if {?SORT} = 'DESC' then crDescendingOrder else
crOriginalOrder;

Refresh your report and type in ASC, or DESC or leave it blank.

So thats how you order it for the report  ;)  
0
 
LVL 8

Expert Comment

by:kingjely
ID: 33633601
Hi rgn2121 and i gave you the answers in VB and Crystals and u also got it,
I'm not sure if you ment to award No POint or not, but we did help!
0
 
LVL 8

Expert Comment

by:kingjely
ID: 33633607
If you ment to it's okay, atleast you got the answer for both now
0
 
LVL 8

Expert Comment

by:kingjely
ID: 33633671
haha no worries, is a bit wierd?!

Thanks,
Kj
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question