Superscript in crystal report 10
![superscript in crystal report 10 superscript in crystal report 10](https://dwbicastle.files.wordpress.com/2015/05/crystal-report-migration5.png)
The Country field does not show in our report, so we are going to use that to sort:Ĭlick the arrow button. The field now appears in the Sort Fields section.Ĭhoose a sort direction, then click OK. However, if we scroll down, we can see all tables that are in our data source. These may or may not appear on our report. To sort by fields that don't appear on a report, go to Report>Report Sort Expert again.Īs we learned in the last section, we see all the fields in our report listed at the top of the Available field section. You can also sort by fields that don't appear on your report as long as those fields appear in your data source. Sorting by Fields that Aren't on a Report You then use the sort arrows to tell Crystal Reports which field to sort first, second, and so on.Ĭlick OK when you are finished. To tell Crystal Reports to sort by one field, then the next, you add both fields to the Sort Fields section pictured below. Crystal Reports does not know this until you tell it. Of course, you and I know that if the last names are the same, that you would then sort them by first name.
SUPERSCRIPT IN CRYSTAL REPORT 10 HOW TO
However, if you had multiple customers with the surname of Smith, Crystal Reports would not know how to sort those. We can also sort by more than one data field. Sometimes you may need to do that in order to get an accurate sort.įor example, if you had a field that contained customer surnames, and you sorted the surnames in ascending order, your customers would be sorted from A to Z based on their last name. In the last section, we sorted by one data field.
![superscript in crystal report 10 superscript in crystal report 10](https://cf-images.us-east-1.prod.boltdns.net/v1/jit/3663210762001/66a54b41-055a-49ef-9266-3a3995227a11/main/1280x720/26m53s100ms/match/image.jpg)
We want to sort in ascending order, so we put a check next to Ascending in the Sort Direction section. We will find that field in the Available Fields section. Click to select it, then click the arrow button to move it to the Sort Fields section.Īs you can see, it now appears in the Sort Fields section. We want to sort our records by the customer. Some of these are also in the report, so you will see them twice.Ĭhoose a field from your report that you want to sort by. In the Record Sort Expert dialogue box, you will see the fields that are in your report.īelow that, you'll see all tables listed in our data source. To sort data in your report, go to Report>Record Sort Expert. You can also sort it in descending order, which means from largest to smallest (Z to A or 9 to 1). You can sort it in ascending order, which means from smallest to largest (A to Z or 1 to 9). Whenever you add a field to a report, the records in that field appear in the order that they were inserted into the database. When you sort data in a report, you put it in a custom order so you can better analyze and find the data you need.Ĭrystal Reports gives you two ways to sort data.