BAQ Report Designer Filter Issue

Yahoo Archive
1
If your have the table in the BAQ you should see the option to add this to the BAQ report Desinger filter.
You are going to new filter once you create the new BAQ deisner....correct?
 
I have done several and have not had an issue.  I do know there is a know issue with multiple sorts in the BAQ report dsigner.
 
 
On Thursday, April 3, 2014 3:13 PM, "jarradlayne@..." <jarradlayne@...> wrote:
  
<div id="ygrps-yiv-1113309481yiv7074370993ygrp-text">
  
  
  <div>Thanks for your response, I tried adding it to the BAQ Search tab but that did not remedy the issue.</div>

</div>
 


<div style="height:0px;color:rgb(255, 255, 255);"></div></div>
#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993 -- #ygrps-yiv-1113309481yiv7074370993ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-mkp #ygrps-yiv-1113309481yiv7074370993hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-mkp #ygrps-yiv-1113309481yiv7074370993ads {
margin-bottom:10px;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-mkp .ygrps-yiv-1113309481yiv7074370993ad {
padding:0 0;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-mkp .ygrps-yiv-1113309481yiv7074370993ad p {
margin:0;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-mkp .ygrps-yiv-1113309481yiv7074370993ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-sponsor #ygrps-yiv-1113309481yiv7074370993ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-sponsor #ygrps-yiv-1113309481yiv7074370993ygrp-lc #ygrps-yiv-1113309481yiv7074370993hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-sponsor #ygrps-yiv-1113309481yiv7074370993ygrp-lc .ygrps-yiv-1113309481yiv7074370993ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993activity span {
font-weight:700;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993activity span span {
color:#ff7900;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993activity span .ygrps-yiv-1113309481yiv7074370993underline {
text-decoration:underline;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 .ygrps-yiv-1113309481yiv7074370993attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 .ygrps-yiv-1113309481yiv7074370993attach div a {
text-decoration:none;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 .ygrps-yiv-1113309481yiv7074370993attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 .ygrps-yiv-1113309481yiv7074370993attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 .ygrps-yiv-1113309481yiv7074370993attach label a {
text-decoration:none;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 .ygrps-yiv-1113309481yiv7074370993bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 .ygrps-yiv-1113309481yiv7074370993bold a {
text-decoration:none;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 dd.ygrps-yiv-1113309481yiv7074370993last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 dd.ygrps-yiv-1113309481yiv7074370993last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 dd.ygrps-yiv-1113309481yiv7074370993last p span.ygrps-yiv-1113309481yiv7074370993yshortcuts {
margin-right:0;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 div.ygrps-yiv-1113309481yiv7074370993attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 div.ygrps-yiv-1113309481yiv7074370993attach-table {
width:400px;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 div.ygrps-yiv-1113309481yiv7074370993file-title a, #ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 div.ygrps-yiv-1113309481yiv7074370993file-title a:active, #ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 div.ygrps-yiv-1113309481yiv7074370993file-title a:hover, #ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 div.ygrps-yiv-1113309481yiv7074370993file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 div.ygrps-yiv-1113309481yiv7074370993photo-title a, #ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 div.ygrps-yiv-1113309481yiv7074370993photo-title a:active, #ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 div.ygrps-yiv-1113309481yiv7074370993photo-title a:hover, #ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 div.ygrps-yiv-1113309481yiv7074370993photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 div#ygrps-yiv-1113309481yiv7074370993ygrp-mlmsg #ygrps-yiv-1113309481yiv7074370993ygrp-msg p a span.ygrps-yiv-1113309481yiv7074370993yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 .ygrps-yiv-1113309481yiv7074370993green {
color:#628c2a;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 .ygrps-yiv-1113309481yiv7074370993MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 o {
font-size:0;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993photos div {
float:left;width:72px;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993reco-category {
font-size:77%;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993reco-desc {
font-size:77%;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 .ygrps-yiv-1113309481yiv7074370993replbq {
margin:4px;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-mlmsg select, #ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 input, #ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-mlmsg pre, #ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 code {
font:115% monospace;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-mlmsg #ygrps-yiv-1113309481yiv7074370993logo {
padding-bottom:10px;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-msg p#ygrps-yiv-1113309481yiv7074370993attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-reco #ygrps-yiv-1113309481yiv7074370993reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-sponsor #ygrps-yiv-1113309481yiv7074370993ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-sponsor #ygrps-yiv-1113309481yiv7074370993ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-sponsor #ygrps-yiv-1113309481yiv7074370993ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1113309481 #ygrps-yiv-1113309481yiv7074370993 #ygrps-yiv-1113309481yiv7074370993ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1113309481



2
Hello Group,

I have an issue regarding BAQ Report Designer filters. I've created a BAQ with quite a few tables, including OrderHed, OrderDtl, and OrderRel. I have OrderHed.OrderNum in the BAQ, however it is not available in the BAQ Report Designer filter list dropdown. I also created a testing BAQ with only OrderHed.OrderNum in it and created a test BAQ Report and no OrderHed.OrderNum was available in the BAQ Report filters. Has anyone else encountered this? Ordernum is in the display column and saved.

Version 9.05.700C

Thanks,
Jarrad
3

Often, many fields are not available in the filter.  However, I have noticed that most key fields are shown there – and this is a key field…One thing to try is to put the OrderNum in the BAQ Search tab (in the BAQ itself).  I had heard this somewhere and think it has worked on occasion – again, depending on the field…

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jarradlayne@...
Sent: Thursday, April 03, 2014 8:05 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Report Designer Filter Issue

 

 

Hello Group,

 

I have an issue regarding BAQ Report Designer filters. I've created a BAQ with quite a few tables, including OrderHed, OrderDtl, and OrderRel. I have OrderHed.OrderNum in the BAQ, however it is not available in the BAQ Report Designer filter list dropdown. I also created a testing BAQ with only OrderHed.OrderNum in it and created a test BAQ Report and no OrderHed.OrderNum was available in the BAQ Report filters. Has anyone else encountered this? Ordernum is in the display column and saved.

 

Version 9.05.700C

 

Thanks,

Jarrad

4
5
Thanks for your response, I tried adding it to the BAQ Search tab but that did not remedy the issue.