Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Crystal Report Index

Posted on 2012-09-20
Medium Priority
Last Modified: 2012-10-01
I've created an index using these instructions in my report:

This works but my list is in page# order  I want it to be in Alphabetical order..
it is like this:
Reeds   3
Double Reeds 6
Reed Guards 7
Clarinet Mouthpices 8

I want it like this:
Clarinet Mouthpieces 8
Double Reeds 6
Reeds  3
Reed Guards 7

Can I do this?
Question by:mschirad
  • 2
LVL 101

Accepted Solution

mlmcc earned 2000 total points
ID: 38419778
The instructions you followed build a Table of COntents which is expected to be in page order.

To get them in alphabetical order you will have to "sort" the strings.

You can use SPLIT to create an array from the string
Sort the array then use JOIN to rejoin the array into a single string

I will try to develop a formula later.

LVL 101

Expert Comment

ID: 38451481
Were you able to get the index built?


Author Comment

ID: 38451490
I sorted like you suggested.  So, in my report all of the headings are now in alpha order which then of course the Table of Contents is in the same order.

This might work out.


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

577 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