I am using crystal reports in visual studio 2005 to generate invoices. I want to sort different categories of products. I'm using group by on category field. How can i set a specified order in crystal reports for categories.
I have for example 3 categories namely 'Recipe', 'Plain Spices', and 'Horeca'….The crystal reports shows them in ascending or descending order but i want Recipe data at top, then Plain Spices and Horeca in the end…!!
How can I achieve this in my crystal report that has already been made??
Best Answer
To clarify the other answer - you need to change the sort order from ascending (or descending) to specified order. To do this: