Grouping in a BAQ?

Yahoo Archive
1
True...no grouping only default sorting.
But if you want to stay within the application, just pull the BAQ
into a dashboard. Then you can group, sum, average, sort, etc...


--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...>
wrote:
>
> There's no grouping in a BAQ query that I'm aware of. Handle that
> easily in Crystal Reports.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of brucewbrannan
> Sent: Thursday, February 12, 2009 9:48 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Grouping in a BAQ?
>
> Hello,
>
> I would like to know if it is possible to group in a BAQ. If I am
> working with labor entries, there may be several entries per day,
per
> employee. Is there a way to group an employees' entries by day in
a
> BAQ calculated field or does this have to be done in Crystal?
>
> I want to create a dashboard to show some charts but one of the
things
> I want to capture is % of direct hours vs. % of indirect hours and
the
> only way I can think of doing this is by grouping within the BAQ
(if
> possible) or doing it in Crystal.
>
> Thanks
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
2
Hello,

I would like to know if it is possible to group in a BAQ. If I am
working with labor entries, there may be several entries per day, per
employee. Is there a way to group an employees' entries by day in a
BAQ calculated field or does this have to be done in Crystal?

I want to create a dashboard to show some charts but one of the things
I want to capture is % of direct hours vs. % of indirect hours and the
only way I can think of doing this is by grouping within the BAQ (if
possible) or doing it in Crystal.

Thanks
3
There's no grouping in a BAQ query that I'm aware of. Handle that
easily in Crystal Reports.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of brucewbrannan
Sent: Thursday, February 12, 2009 9:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Grouping in a BAQ?

Hello,

I would like to know if it is possible to group in a BAQ. If I am
working with labor entries, there may be several entries per day, per
employee. Is there a way to group an employees' entries by day in a
BAQ calculated field or does this have to be done in Crystal?

I want to create a dashboard to show some charts but one of the things
I want to capture is % of direct hours vs. % of indirect hours and the
only way I can think of doing this is by grouping within the BAQ (if
possible) or doing it in Crystal.

Thanks



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links