Query Sort failure on report

cft

Registered User.
Local time
Today, 18:23
Joined
Dec 31, 2001
Messages
52
In a query I have an Expression used to capture the parameter [Enter Month as Digit].
Expr2:[Enter Month as Digit]
This is taken from another expression:
Month[Received Date]
This is used to identify the Month the data was received.
The parameter [Enter Month as Digit] is to be used to populate a field in a report showing what month the data is from.

The problem is that in the query there is a field "Reason Code" that is sorted Descending by Count (to show how often a complaint code is applied to incoming calls). The Query fires off correctly and sorts the data according to the Count Descending instruction. If, for instance, the "Month as Digit" is entered as "6" for June data, the "6" shows up on each record.

The report is to show this "6" in a bound field (Bound to "Expr2:"). However, when the bound field exists in the report, the data sorts according to another field's alpha order, not the Descending Count of the Codes field, and the results are incorrect.

When I delete the bound field with the "6" parameter, the report sequences correctly. I need the report to show what parameter was used to collect the data from the table. What can I do to correct this frustration?
Any help will be appreciated.
 
I got it. The sorting should have been done from right-clicking on the detail section of the report, and from there going into Sort and Order criteria. I set the criteria up on the report, and did not have to depend on manipulating the query. My narrow focus on the query kept me from thinking of the report as the source of the correction.:)
 

Users who are viewing this thread

Back
Top Bottom