How to enable Group By in report level
1 October, 2014
Hi,
I want to get a "Group By" clause added in to my report SQL? I tried putting a section to the report for the column I want to be Grouped by, but the Group By clause didn't get added to the report SQL.
Thanks
Shanika
I want to get a "Group By" clause added in to my report SQL? I tried putting a section to the report for the column I want to be Grouped by, but the Group By clause didn't get added to the report SQL.
Thanks
Shanika
Hello Shanika,
Does this information on Grouping from the Yellowfin Wiki assist at all?
Please let me know.
Kind Regards,
Danny
Does this information on Grouping from the Yellowfin Wiki assist at all?
Please let me know.
Kind Regards,
Danny
Hi Danny,
What I am actually after is getting the SQL "GROUP BY" after the WHERE clause in SQL query.
The only way I could get this in to report SQL query was by giving an aggregate function for the relavent column. Unfortunately this pulls in all other columns in the SELECT clause in to the Group BY whcih is not what I wanted. I want to be able to have the desired column only in the "GROUP BY". For example :
SELECT BOOKING NUMBER, NAME, FARE FROM BOOKING
WHERE
GROUP BY BOOKING NUMBER
-Shanika
What I am actually after is getting the SQL "GROUP BY" after the WHERE clause in SQL query.
The only way I could get this in to report SQL query was by giving an aggregate function for the relavent column. Unfortunately this pulls in all other columns in the SELECT clause in to the Group BY whcih is not what I wanted. I want to be able to have the desired column only in the "GROUP BY". For example :
SELECT BOOKING NUMBER, NAME, FARE FROM BOOKING
WHERE
GROUP BY BOOKING NUMBER
-Shanika
Hello Shanika,
We might need some more information from you to understand what you're trying to achieve.
If possible, could you show us your report tables as they stand presently without aggregation / Group By applied, and if you are able to show us a mockup of how you would like the information displayed?
Kind Regards,
Danny
We might need some more information from you to understand what you're trying to achieve.
If possible, could you show us your report tables as they stand presently without aggregation / Group By applied, and if you are able to show us a mockup of how you would like the information displayed?
Kind Regards,
Danny