Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Sorting - Exporting from Sage 50 Post Reply Post New Topic
Author Message
abasmar
Newbie
Newbie


Joined: 16 Apr 2014
Location: Saudi Arabia
Online Status: Offline
Posts: 2
Quote abasmar Replybullet Topic: Sorting - Exporting from Sage 50
    Posted: 16 Apr 2014 at 10:17pm
Hello All,

Hope all is going well.

Im facing a problem with my report. I am using Sage 50 Pro 2013 to make invoices/quotes but i was surprised that the total amount in numbers, cannot be written in words.

So, a crystal report designer made me a report to export all infos from sage 50 and from the report itself it displays the amount number in words.

Now, all is great except for one problem, the report does not export and show the invoice made in Sage 50 as it is, it rather sorts the items by ascending or descending order, and i want it to show it as it is!

i don't use grouping, its only about the sorting, i don't want to sort it numerically or alphabetically, i just want to show it as it is on sage 50.

Any help please? i can email you the report if necessary. please advise.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 18 Apr 2014 at 5:02am
is there a grouping on the report. if so, go to 'change group' and set the order to original order, or something like that...it should be obvious when you look at the options.

at least that is the first thing that I would do. The other would be to inspect the data and see if it is coming out in a sorted order or not.
IP IP Logged
abasmar
Newbie
Newbie


Joined: 16 Apr 2014
Location: Saudi Arabia
Online Status: Offline
Posts: 2
Quote abasmar Replybullet Posted: 18 Apr 2014 at 5:18am
Hello,

Thanks for replying.

There is no grouping in the report. And when i checked from "Sort Expert", none of the fields is added to be ordered in ascending or descending order and yet it still comes out in a different order than the original one in the invoice i make on Sage 50 software
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 18 Apr 2014 at 5:27am
hmmm...

try looking at the Record sort expert and removing anything that you find there.

it's a thought
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.030 seconds.