Sorting and grouping in Report Studio

[backhandx]

Hi all,

I have a question regarding the grouping and sorting in Report Studio.
Actually, what this fucntionnality allows is to first group then to sort.

I wondering if it is possible to first sort then group the common sorted rows.

Exemple:

I have a table with two columns C1, C2 :

C1   C2
----------
a   1
----------
b   5
----------   
a   2
----------
c   4
----------
b   3
----------
b   6


I want to sort C2 first then group by C1 column.

C1   C2
----------
   1
a   
   2
----------
b   3
---------
c   4
----------

   5
b   ------
   6
----------   
Is this possible in report studio?

Thanks in advance.

[MFGF]

Hi all,

I have a question regarding the grouping and sorting in Report Studio.
Actually, what this fucntionnality allows is to first group then to sort.

I wondering if it is possible to first sort then group the common sorted rows.

Exemple:

I have a table with two columns C1, C2 :

C1   C2
----------
a   1
----------
b   5
----------   
a   2
----------
c   4
----------
b   3
----------
b   6


I want to sort C2 first then group by C1 column.

C1   C2
----------
   1
a   
   2
----------
b   3
---------
c   4
----------

   5
b   ------
   6
----------   
Is this possible in report studio?

Thanks in advance.

Grouping always takes precedence over sorting, so you're going to need to group C2 then C1 in that order. You will not be able to prevent C1 values from displaying on every row, though.

Cheers!

MF.

[backhandx]

It works good.

Many Thanks  :)