How to to custom sorting based on row values?

[cr2016]

Hi all,

I am a brand new user of crystal report and I am trying to do a custom sort of a report based on the row values.
eg:

Products
-------------
Television HD
Home Theatre type 1
Music system type 1
Television
Home Theatre type 2
Music system type 2

I want the report to be sorted like below:

Products
-------------
Television HD
Home Theatre
Television
Music system type 1
Home Theatre type 2
Music system


Please let me know how this can be achieved.

Thanks in advance!

[Ned Pepper]

You can force a sort order using a formula like...

if {TABLE.Products} = 'Television HD' then 'A'
else
if {TABLE.Products} = 'Home Theatre type 1' then 'B'
else
if {TABLE.Products} = 'Music system type 1' then 'C'
else
if {TABLE.Products} = 'Television' then 'D'
else
if {TABLE.Products} = 'Home Theatre type 2' then 'E'
else
if {TABLE.Products} = 'Music system type 2' then 'F'
else 'G'