Desired Grouping Field Not Available (1 Viewer)

NearImpossible

Registered User.
Local time
Today, 07:56
Joined
Jul 12, 2019
Messages
177
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

theDBguy

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

NearImpossible

Registered User.
Local time
Today, 07:56
Joined
Jul 12, 2019
Messages
177
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
Local time
Today, 05:56
Joined
Oct 29, 2018
Messages
10,824
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?
 

theDBguy

I’m here to help
Local time
Today, 05:56
Joined
Oct 29, 2018
Messages
10,824
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 (Users: 0, Guests: 1)

Top Bottom