[QODBC-Desktop] sp_report Output Returns Blank RowData and RowDataType When QB Enterprise "Activate Categories" Is Enabled
Problem Description:
After upgrading to QuickBooks Enterprise 2023 or later, running any sp_report stored procedure through QODBC may return blank RowData and RowDataType columns in the result set, even though the data is visible in the QuickBooks Desktop UI.
This was first reported with sp_report SalesByItemSummary, but the same behavior can affect other sp_report stored procedures when QuickBooks has the "Activate categories" preference enabled.
Affected products: QODBC Desktop, QuickBooks Enterprise 2023 and later Expected outcome: After disabling "Activate categories" in Company Preferences, RowData and RowDataType columns return populated data through QODBC.
Symptoms:
RowData and/or RowDataType columns are blank (empty strings) for all rows in the sp_report result set.
- The issue started after upgrading to QuickBooks Enterprise 2023 or later; it did not exist in prior QuickBooks versions (e.g., QB 2022).
- The data is visible in the QuickBooks Desktop UI; the problem is isolated to the QODBC query output.
- The issue affects both MS Excel Power Query and the QODBC Test Tool (32-bit and 64-bit).
- Note: In the QuickBooks Desktop UI, clicking "Hide Category" on a report makes it display data in the old non-grouped format - but this toggle is not available through the Intuit SDK.
Cause:
QuickBooks Enterprise 2023 introduced a new preference called "Activate categories" under Edit → Preferences → Items & Inventory → Company Preferences → CATEGORIZE ITEMS. When this option is enabled (the default in QB 2023+), the QuickBooks SDK stops returning data for RowData and RowDataType fields to sp_report queries.
This is a QuickBooks-level change, not a QODBC bug. QODBC accesses data through the QuickBooks SDK, so it can only return whatever fields the SDK exposes. Intuit has not exposed any SDK parameter or option to toggle "Activate categories" from external applications.
Environment:
| Product | Version / Detail |
| QODBC Desktop |
All versions (affected by QB-side behavior) |
| QuickBooks Enterprise |
2023, 2024 and later - when "Activate categories" is enabled |
| Data Source Tools |
MS Excel (Power Query), QODBC Test Tool (32-bit and 64-bit) |
Solution:
- Open QuickBooks Desktop as the company administrator.
- Navigate to Edit → Preferences → Items & Inventory → Company Preferences.
- Locate "CATEGORIZE ITEMS" near the bottom of the page.
- Uncheck "Activate categories". If the checkbox is grayed out, you may need to contact your QuickBooks Administrator or Intuit Support to change this setting.
- Close QuickBooks completely - ensure no
qbw32.exe or qbw.exe processes are running in Task Manager.
- Restart the QODBC Test Tool (or reopen your Excel/Power Query connection).
- Re-run your sp_report query. The RowData and RowDataType columns should now return populated data.
SQL Examples:
After disabling "Activate categories," run your report query normally - no query changes are required:
sp_report sp_report SalesByItemSummary SHOW RowData, RowDataType, ItemFullName, TxnType, Date, Amount PARAMETERS DateMacro = 'ThisYear'
sp_report sp_report SalesByItemDetail SHOW RowData, RowDataType, ItemFullName, TxnType, RefNumber, Amount PARAMETERS DateMacro = 'ThisQuarter'
Additional Notes:
- "Activate categories" cannot be toggled via SDK. The QuickBooks "Hide Category" toggle available on reports in the UI is not exposed through the Intuit SDK, so it cannot be controlled programmatically from QODBC. There is no sp_report parameter to disable category grouping at the report level.
- This affects QB Enterprise 2023+ only. QuickBooks Desktop 2022 and earlier do not have the "Activate categories" preference, so RowData/RowDataType always returned data in those versions.
- The setting is per-company file. You may have different results across company files depending on whether each file has "Activate categories" enabled or disabled.
- If you need category data, the QuickBooks UI's "Hide Category" toggle lets you view the old-style report without grouping. For QODBC consumers, disabling the preference is the only current workaround.
Related Articles:
Understanding sp_report Stored Procedures in QODBC QODBC Desktop and QuickBooks SDK Data Access Model Troubleshooting Blank Columns in QODBC Reports
Keywords:
RowData RowDataType sp_report SalesByItemSummary Blank Columns Activate Categories QB Enterprise 2023 QB Enterprise 2024 Company Preferences QuickBooks SDK Categorize Items Report Output Excel Power Query
Support Tickets: TAF-804-59796
|