Skip to Content
avatar image
Former Member

Problems with the CrossTable Function "Sort"

Hello,

I have a Problem with the "nice" crosstabfunction of the DesignStudio.

When I create from a datasource the crosstab and enable the function for sorting it is only possible to sort the first column.

The other columns get the sign into the Header for the sort function, too. But if I click on it, it won't work and sort nothing.

I'm sure with the old Version of SAP Design-Studio (1.2) it has worked!

Now we are using 1.4 and u can only sort the first column?????

Do I anything wrong? I set only the value for the crosstab (Sorting enabled) on true.

Thank you for help.

Greets,

André

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Apr 22, 2015 at 02:07 PM

    Hi Andre - I can sort more than just my first column; I am using a BEx Query against 1.4 SP2

    Are you using a BEx Query as a datasource and 1.4 SP2?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 23, 2015 at 08:47 AM

    Hi Andre

    I am using Design Studio 1.4 SP2 and I am able to sort other columns too.

    If possible, you may share screenshot for the properties of Crosstab and the script to enable sorting ( which might be same for me too), so that others may a look at it.

    Regards

    Rahul Kumar

    Add comment
    10|10000 characters needed characters exceeded

    • It looks like you have the Key and Text setting for the member display on the 2nd and 3rd columns - if you want to only sort by text, perhaps switch the setting in the Edit > Initial View > Member Display > Text and Key

  • avatar image
    Former Member
    Aug 21, 2015 at 08:27 AM

    Hi Andre,

    did you find a solution for this ?

    We're facing exactly the same Problem after upgrade to DS1.5....

    Greets,

    Kai

    p.s.:  By Scripting the Datasource is also only sortable by the first member in the Query...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 03, 2016 at 01:51 PM

    Hi

    we're facing the same Problem  - DS 1.6, Datasource IDT, SQL_Server 10, Derived Tables.

    We have a crosstab only with dimensions (a "normal" table ).

    We can only sort the first Column, but all dimensions must be sortable. --> We can't sort it in idt because we receive an error-message, that it's not possible to use sort by/ group by in derived Tables.

    Regards,

    Franz

    Add comment
    10|10000 characters needed characters exceeded