Skip to main content
Boyum Help Center Help Center home page
Boyum IT Solutions Community Submit a request
Sign in
  1. Boyum Help Center
  2. B1 Usability Package
  3. UF: SQL Report

FAQ - SQL Report

  • Created June 28, 2022 12:31

Q: When using Collapse Level, it seems the system ignores my ORDER BY.
A: This is an SAP limitation. Once Collapse level is used, they take over sorting as well and we (Boyum) have no influence over it :-(

Q: Is it possible to have Collapse Level Sub-totals?
A: No, SAP, unfortunately, does not support this :-(

Was this article helpful?

0 out of 0 found this helpful

Related articles

  • How to customize the SQL Report's 'Define Survey Variables' screen
  • SAP Limitation: Order by vs Collapse level
  • FAQ - Universal Functions - SQL Report
  • How can i do an LB: Macro from a SQL Report on the B1 Dashboard ?
  • Can we add SQL combined with text into a Message type universal Function?

Comments

0 comments

Please sign in to leave a comment.

Articles in this section

  • FAQ - SQL Report
  • How to customize the SQL Report's 'Define Survey Variables' screen
  • How can i do an LB: Macro from a SQL Report on the B1 Dashboard ?
  • SAP HANA - How to use DECLARE in a SQL report
  • SAP Limitation: Order by vs Collapse level
  • SAP Limitation - Not possible to add subtotal on collapsed report
  • SAP Limitation - Not possible to colorize cells in an SQL report
  • Charts: How to work with data aggregate and pie charts
  • Charts: How to work with date and years on the x-axis
  • Charts: How to work with export and print options

See all 20 articles

Boyum IT Solutions
Español (Latinoamérica)
Zendesk Theme by Zenplates