Displaying all entries of group by column

[kcog123]

Hi,

If i have something like group by state and have details...

State Detail
AK 1
2
3
AL 2
5
6
I should get
AK 1
AK 2
AK 3
AL 2
AL 5
AL 6
even though it's grouped by state for filtering purpose in Excel.
How can i do that in report studio? Not excel.

Thank You.

 

[blom0344]

Looks to me that grouping defies the purpose. If you do not group then you have the right output for filtering in Excel..

Ties Blom

 

[drlex]

Unless the grouping is required for other columns. I don't use reportnet, but when I have a similar requirement in Impromptu, I just add a calculated column with the definition of the grouping column - this gives a column with filled rows for excel use.


soi là, soi carré

 

[kcog123]

Thanks drlex.
That's exactly what i need and it solved my problem.
thanks again.