Lee - I tested it here and got the same thing, in 407A and 408B. Short of
calling tech support and maybe getting them to fix it in the next release I
don't know of anything you can do. I've seen this before and was told by
support that if a person can see the filter in a standard/prebuilt report
then you should be able to do the same in report designer.
If you don't call support on this please let me know and I will. This needs
fixed.
Short term you could possibly add two option fields for TranType and do a
greater than - less than or maybe on date range and if your using Crystal
maybe create a prompt for tran types and filter it there.
If you do find a way to do this I sure would appreciate a heads up.
Dale Dalton
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Lee Ingalls
Sent: Thursday, January 21, 2010 10:30 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage BAQ Report Designer Filter using PartTran
adapter
Yes it is.
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Dale Dalton
Sent: Thursday, January 21, 2010 11:24 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Vantage BAQ Report Designer Filter using PartTran
adapter
Is the field you want to filter on in the BAQ "Display Columns" list?
_____
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
LeeI
Sent: Thursday, January 21, 2010 10:17 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vantage BAQ Report Designer Filter using PartTran
adapter
I want to add a filter to a report in the BAQ report Designer. The table
and
field exists in the BAQ, but its not available as an option to add to the
filter.
Additionally, I can open my report form in developer mode/customization
and
see the PartTranAdapter in the Object Explorer - Adapter Tab...
Looking for insight on how to add a PartTran.TranType filter to the BAQRD
form.
Regards, Lee Ingalls
Andronaco Industries
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
calling tech support and maybe getting them to fix it in the next release I
don't know of anything you can do. I've seen this before and was told by
support that if a person can see the filter in a standard/prebuilt report
then you should be able to do the same in report designer.
If you don't call support on this please let me know and I will. This needs
fixed.
Short term you could possibly add two option fields for TranType and do a
greater than - less than or maybe on date range and if your using Crystal
maybe create a prompt for tran types and filter it there.
If you do find a way to do this I sure would appreciate a heads up.
Dale Dalton
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Lee Ingalls
Sent: Thursday, January 21, 2010 10:30 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage BAQ Report Designer Filter using PartTran
adapter
Yes it is.
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Dale Dalton
Sent: Thursday, January 21, 2010 11:24 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Vantage BAQ Report Designer Filter using PartTran
adapter
Is the field you want to filter on in the BAQ "Display Columns" list?
_____
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
LeeI
Sent: Thursday, January 21, 2010 10:17 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vantage BAQ Report Designer Filter using PartTran
adapter
I want to add a filter to a report in the BAQ report Designer. The table
and
field exists in the BAQ, but its not available as an option to add to the
filter.
Additionally, I can open my report form in developer mode/customization
and
see the PartTranAdapter in the Object Explorer - Adapter Tab...
Looking for insight on how to add a PartTran.TranType filter to the BAQRD
form.
Regards, Lee Ingalls
Andronaco Industries
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]