Desired Grouping Field Not Available (1 Viewer)

NearImpossible

Registered User.
Local time
Today, 12:36
Joined
Jul 12, 2019
Messages
225
Hello all,

I have a select query to return all data based on a checkbox, which works great.

The fields being returned are as follows: OrderID, Facility, Description, OrderDate, PurchNum, InvoiceDate, InvoiceNum

I am trying to make a report to group on the Facility, however whenever I run the Report Wizard, that option isn't available for grouping, nor if I make a report and try to do the grouping under the properties, its not listed their neither, any thoughts??

Edit: Forgot the OrderID column, which is set as the Identity field on the SQL Side
 

Attachments

  • Report Wizard.PNG
    Report Wizard.PNG
    17.7 KB · Views: 90
  • Properties.PNG
    Properties.PNG
    7 KB · Views: 91

theDBguy

I’m here to help
Staff member
Local time
Today, 10:36
Joined
Oct 29, 2018
Messages
21,358
Hi. Can you post the SQL statement for your query? Is the missing field available for sorting?
 

NearImpossible

Registered User.
Local time
Today, 12:36
Joined
Jul 12, 2019
Messages
225
Hi. Can you post the SQL statement for your query? Is it available for sorting?

Code:
SELECT *
FROM EquipmentOrders
WHERE EquipmentOrders.[Awaiting Payment]=1
 

theDBguy

I’m here to help
Staff member
Local time
Today, 10:36
Joined
Oct 29, 2018
Messages
21,358
Code:
SELECT *
FROM EquipmentOrders
WHERE EquipmentOrders.[Awaiting Payment]=1
Hi. Thanks. Can you post a screenshot of the table EquipmentOrders in Design View? What is the Data Type for the Facility field?
 

NearImpossible

Registered User.
Local time
Today, 12:36
Joined
Jul 12, 2019
Messages
225
Hi. Thanks. Can you post a screenshot of the table EquipmentOrders in Design View? What is the Data Type for the Facility field?

Please see attached, apparently its an issue with the nvarchar(Max) type as nvarchar(50) types show
 

Attachments

  • Table.PNG
    Table.PNG
    9.6 KB · Views: 89
  • Query Return.PNG
    Query Return.PNG
    7.7 KB · Views: 96

theDBguy

I’m here to help
Staff member
Local time
Today, 10:36
Joined
Oct 29, 2018
Messages
21,358
Please see attached, apparently its an issue with the nvarchar(Max) type as nvarchar(50) types show
Hi. That's correct. You can't group or sort on long text or memo fields. Sorry.
 

Users who are viewing this thread

Top Bottom