NearImpossible
Registered User.
- Local time
- Today, 08:57
- 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
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