How to use Group By in BAQ?

Can “Group By” be used in a BAQ?
If yes, anyone knows how to use Group By in BAQ?
Thanks.

This is very much discussed in depth in the Ice Tool Guide and Customization Guide as well as the epicor Help.
I recommend starting there

1 Like

Thanks a lot, Jose.
We can not use the Group By directly for BAQ designer?

You can… How to do it is outlined in the several manuals mentioned above and the epicor help

Thanks Jose. I got it. One more question. Can the group by results go to the BAQ SSRS report using the BAQ?

The results of the BAQ is what is available in the report

1 Like

groupings are handled in your SSRS report, they are not passed through.

1 Like

That is what I guessed. When I looked at the Query phase, there was no GROUP BY in the SQL scripts.

So we can add group by directly after the SQL statement generated by BAQ report designer? Or need more adjustment? Thanks.

image

image

4 Likes

Thanks, Banderson.

Thank you for the actual answer instead of trying to find random guides.

3 Likes