Sortable column headers in a cross tab

[Former Member]

Hi,

the requirement:

To have a cross tab report that have its sortable columns, that is a user can click on the column header to sort data either ascending or descending

the problem:

I can't bind a sort control to the cross tab column headers

I'm using Crystal Reports 2008

is there any way to get this report to work?

your fast reply is more than appreciated,

Thanks in advance

[Former Member · Accepted solution]

Hi Yusuf

You can apply a formula for sorting on column headers by the following way:

1. Select the column. Click on Group options.

2. In the Common tab check the box for"Use a formula as Group Sort order" and click on X-2 button to open the formula editor.

3. Write the formula with the conditions required.

You can also customize the group names from the Options tab.

Hope this helps!!!

Regards

Sourashree

[Former Member · Accepted solution]

Thanks Sourashree,

But the point is the report should allow the user to click on any column inside that cross tab to perform sorting on that column just like when using a sort control on a non-crosstab column

[Former Member · Accepted solution]

is there a way to have the cross tab columns bound to sort control?

[dc_chuang · Accepted solution]

According to the Crystal 2008 help:

• Sort controls cannot be used in sub-reports

• Sort controls cannot be created within a cross-tab or an OLAP grid