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.
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.