Sorting and Grouping question

[MooSki]

Hi guys,

I hope you can answer this one that has been bugging me all day. (I'm in the UK, hence the strange timestamp.)

I have a main report that has a drill though on a "Request Number". This request is actually a questionnaire that has a series of 45 questions, split into 7 specific sections. On the drill through report I have added a calculated field called "Quest Section" that shows what section that question appears in, based on the Question Number. To make things look nice, I have grouped the "Quest Sections" together, but when doing this, these are then automatically sorted, knocking out the sort order of the question numbers on the report. I get something like this...

Section Qu # Description

Closure 42 Did you...?
43 When did....?
44 Why did...?
45 Name some....?
Comms 01 Which....?
02 Have you....?

etc

when clearly what I want is the QU # in order, but showing the section first, as above.

Normally, I would have liked the "Section" to have been part of the data, but it isn't, so I have a CASE statement to determine this.

Any ideas how to get around this? Am I missing something really, really obvious?

Kind regards,
Mooski.

 

[blom0344]

Applying a section enforces an implicit sort. Data will be lined up according to the value of the section members.
The only way to adjust this is to apply a custom sort on the section members to influence the order in which they are shown..

Ties Blom