BAQ Report filtering (Ver 8.03)


(system) #1
<!-- #ygrps-yiv-1835624264 _filtered #ygrps-yiv-1835624264 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1835624264 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1835624264 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-1835624264 {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #ygrps-yiv-1835624264 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #ygrps-yiv-1835624264 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} #ygrps-yiv-1835624264 #ygrps-yiv-1835624264 p.ygrps-yiv-1835624264MsoNormal, #ygrps-yiv-1835624264 li.ygrps-yiv-1835624264MsoNormal, #ygrps-yiv-1835624264 div.ygrps-yiv-1835624264MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-1835624264 a:link, #ygrps-yiv-1835624264 span.ygrps-yiv-1835624264MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-1835624264 a:visited, #ygrps-yiv-1835624264 span.ygrps-yiv-1835624264MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-1835624264 p {

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1835624264 code
{
font-family:“Courier New”;}
#ygrps-yiv-1835624264 pre
{

margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-1835624264 tt
{
font-family:“Courier New”;}
#ygrps-yiv-1835624264 span.ygrps-yiv-1835624264cat
{}
#ygrps-yiv-1835624264 span.ygrps-yiv-1835624264ct
{}
#ygrps-yiv-1835624264 span.ygrps-yiv-1835624264HTMLPreformattedChar
{

font-family:Consolas;}
#ygrps-yiv-1835624264 p.ygrps-yiv-1835624264attach, #ygrps-yiv-1835624264 li.ygrps-yiv-1835624264attach, #ygrps-yiv-1835624264 div.ygrps-yiv-1835624264attach
{

margin-right:0in;

margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-1835624264 p.ygrps-yiv-1835624264bold, #ygrps-yiv-1835624264 li.ygrps-yiv-1835624264bold, #ygrps-yiv-1835624264 div.ygrps-yiv-1835624264bold
{

margin-right:0in;

margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1835624264 p.ygrps-yiv-1835624264green, #ygrps-yiv-1835624264 li.ygrps-yiv-1835624264green, #ygrps-yiv-1835624264 div.ygrps-yiv-1835624264green
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-1835624264 p.ygrps-yiv-1835624264replbq, #ygrps-yiv-1835624264 li.ygrps-yiv-1835624264replbq, #ygrps-yiv-1835624264 div.ygrps-yiv-1835624264replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1835624264 p.ygrps-yiv-1835624264ad, #ygrps-yiv-1835624264 li.ygrps-yiv-1835624264ad, #ygrps-yiv-1835624264 div.ygrps-yiv-1835624264ad
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1835624264 p.ygrps-yiv-1835624264underline, #ygrps-yiv-1835624264 li.ygrps-yiv-1835624264underline, #ygrps-yiv-1835624264 div.ygrps-yiv-1835624264underline
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1835624264 span.ygrps-yiv-1835624264yshortcuts
{}
#ygrps-yiv-1835624264 p.ygrps-yiv-1835624264ad1, #ygrps-yiv-1835624264 li.ygrps-yiv-1835624264ad1, #ygrps-yiv-1835624264 div.ygrps-yiv-1835624264ad1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1835624264 p.ygrps-yiv-1835624264ad2, #ygrps-yiv-1835624264 li.ygrps-yiv-1835624264ad2, #ygrps-yiv-1835624264 div.ygrps-yiv-1835624264ad2
{

margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1835624264 p.ygrps-yiv-1835624264underline1, #ygrps-yiv-1835624264 li.ygrps-yiv-1835624264underline1, #ygrps-yiv-1835624264 div.ygrps-yiv-1835624264underline1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-1835624264 span.ygrps-yiv-1835624264yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1835624264 span.ygrps-yiv-1835624264yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-1835624264 span.ygrps-yiv-1835624264EmailStyle36
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-1835624264 .ygrps-yiv-1835624264MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-1835624264 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-1835624264 div.ygrps-yiv-1835624264WordSection1
{}
#ygrps-yiv-1835624264
_filtered #ygrps-yiv-1835624264 {
}
_filtered #ygrps-yiv-1835624264 {

font-family:Symbol;}
_filtered #ygrps-yiv-1835624264 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-1835624264 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1835624264 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1835624264 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1835624264 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1835624264 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1835624264 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1835624264 {

font-family:Wingdings;}
#ygrps-yiv-1835624264 ol
{margin-bottom:0in;}
#ygrps-yiv-1835624264 ul
{margin-bottom:0in;}
–>

On the BAQ report, you can add filters (besides those already in the BAQ). Usually these will only show key fields and/or fields that you select as BAQ Search fields in your BAQ itself…

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of ckrusen1@…
Sent: Thursday, November 07, 2013 8:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Report filtering (Ver 8.03)

 

 

My final report will have a filters for the fields FiscalYear and FiscalPeriod.  

 

Does the BAQ need to return all years and periods, and then the report filters the ones to be displayed?

 

Or is there a way to have the filter values the user enters when running the BAQ Report, flow through to the BAQ?

 

It seems like it should be the later.  But it appears that the Phrase Builder in the BAQ designer only allows constants (or a value from another field) for filter criteria.

 

Calvin


(system) #2
My final report will have a filters for the fields FiscalYear and FiscalPeriod.  

Does the BAQ need to return all years and periods, and then the report filters the ones to be displayed?


Or is there a way to have the filter values the user enters when running the BAQ Report, flow through to the BAQ?

It seems like it should be the later.  But it appears that the Phrase Builder in the BAQ designer only allows constants (or a value from another field) for filter criteria.

Calvin