Sorting report by various criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a comprehensive report which I would like to sort. Each record header
is titled 'interfaces' and within each interface lists 'data elements'. I
need to sort the data elements by whether they have a 'gap' or not, then by
different explanations from the same filed such as 'derived data' then
'default value'. Anything that does not meet this criteria should be at the
top of the report. I hope this is clear. Thanks you
 
This is not clear. When asking about sorting a report, we need to know
information about fields and if you want the user to be able to change the
sort field order at run-time. Terms like "record header" make no sense.
 
Sorry, I will try again. Once created, the report will not need to be
changed at any time.
I have a table called 'interfaces' which lists 220 different interfaces. I
also have another table called 'data elements' which lists 1300 different
elements. Each interface contains at least 1 data element (some contain 50).
So my hope is that the report will list all interfaces and the related data
elements. The important thing in this report is for me to sort the data
elements by different criteria.

Each data element has different defining fields such as whether it has a gap
or not, and an explanation of the element. The gap field is a yes/no, the
explanation is a choice of 6 different explanations. So I need to sort the
report firstly by no gap and no explanation, then by gap, then by
explanation.

Can I write an 'if' statement in the sorting expression field?

I appreciate your help.
 
It isn't clear if you want to "sort" or "filter". Your use of "criteria"
always suggests filtering your records displayed in your report. However,
you also use the word "sort" several times which means "to display records
in a specific order".

You can set the sorting and grouping level control sources to an expression.
This could be a field name or an expression like:
=IIf([Gap]=Yes AND [Explanation]="Yada", 1, 2)
 
Back
Top