BAQ Report Filters

Yahoo Archive
1
The BAQ test results are run from the BAQ designer, not the BAQ
Report designer. Therefore, the BAQ test results are only limited to
the criteria setup in the Phrase Builder wizard, and are oblivious to
the filter settings on a BAQ Report.

My problem was with the output of the BAQ Report. Records not
matching the filters were still showing up.

It turns out that the field I selected for filtering was in a table
linked as an outer join. After fixing the joins, all is well.

Thanks,


Calvin



--- In vantage@yahoogroups.com, "Dale Dalton" <daled@...> wrote:
>
> Calvin - Yes. The BAQ retrieval is based on the BAQ filters. Take
a look at
> the BAQ test results. The information displayed is what CR would
get.
>
>
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Calvin Krusen
> Sent: Wednesday, September 17, 2008 9:22 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BAQ Report Filters
>
>
>
> Do the filters in BAQ Report limit the data retrieved by the BAQ
and
> sent to the Crystal Report (CR) engine?
>
> Or do they simply provide a field to pass to CR, then requiring CR
to
> limit the records to match the filter?
>
> Calvin
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
Do the filters in BAQ Report limit the data retrieved by the BAQ and
sent to the Crystal Report (CR) engine?

Or do they simply provide a field to pass to CR, then requiring CR to
limit the records to match the filter?

Calvin
3
They compile an xml file that only contains the data limited by your filter.



Daniel

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Calvin Krusen
Sent: Wednesday, September 17, 2008 10:22 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Report Filters



Do the filters in BAQ Report limit the data retrieved by the BAQ and
sent to the Crystal Report (CR) engine?

Or do they simply provide a field to pass to CR, then requiring CR to
limit the records to match the filter?

Calvin





[Non-text portions of this message have been removed]
4
> Do the filters in BAQ Report limit the data retrieved by the BAQ and
> sent to the Crystal Report (CR) engine?
>
> Or do they simply provide a field to pass to CR, then requiring CR to
> limit the records to match the filter?

Hi Calvin,

I suspect that it limits the records retrieved. It's easy enough to verify.
Run your BAQ report with one filter then run it again with another filter.
Check the file size and or content of the XML files in your Report folder
(under your username) and let everyone know the results.

Mark W.
5
Calvin - Yes. The BAQ retrieval is based on the BAQ filters. Take a look at
the BAQ test results. The information displayed is what CR would get.



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Calvin Krusen
Sent: Wednesday, September 17, 2008 9:22 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Report Filters



Do the filters in BAQ Report limit the data retrieved by the BAQ and
sent to the Crystal Report (CR) engine?

Or do they simply provide a field to pass to CR, then requiring CR to
limit the records to match the filter?

Calvin





[Non-text portions of this message have been removed]