Generating a GROUP BY in report if Object not included in query

[Maiden]

Hi

Does anyone know how to generate a GROUP BY in a report SQL which runs in the background due to the fact that the group by object has not been included in the Query?

Cheers
InDistress

 

[blom0344]

Hello Maiden,

Your question is a bit kryptic, but there is always the possibility of overriding the SQL that is generated by the universe(structure) by modifying the SQL statement in the Query panel (use SQL-button). After modification mark the "Do not generate SQL before running". When you now run the report you will force BO to accept the modified SQL-statement. But beware, if you change the query again but dragging in more objects or modify prompts, you will lose the override and BO will switch back to the universe generated SQL