Desired Grouping Field Not Available (1 Viewer)

NearImpossible

Registered User.
Local time
Yesterday, 18:03
Joined
Jul 12, 2019
Messages
186
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
Staff member
Local time
Yesterday, 16:03
Joined
Oct 29, 2018
Messages
11,189
Hi. Can you post the SQL statement for your query? Is the missing field available for sorting?
 

NearImpossible

Registered User.
Local time
Yesterday, 18:03
Joined
Jul 12, 2019
Messages
186
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
Yesterday, 16:03
Joined
Oct 29, 2018
Messages
11,189
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
Staff member
Local time
Yesterday, 16:03
Joined
Oct 29, 2018
Messages
11,189
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