Desired Grouping Field Not Available (1 Viewer)


Registered User
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



I’m here to help
Hi. Can you post the SQL statement for your query? Is the missing field available for sorting?

Users Who Are Viewing This Thread (Users: 0, Guests: 1)