RB Filter question

Woo-hoo! That worked. I always thought it had to be enclosed in quotes.
Another little-known fact revealed.

Thanks a bunch!
Lydia

-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Monday, November 14, 2005 11:20 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] re: RB Filter question


Can you place the filter as VenterID = ? (do not enclose it with quotes)

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Lydia Coffman
Sent: Monday, November 14, 2005 1:11 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] re: RB Filter question


Hello, all:

I have a fairly simple DMR supplier report. It is grouped on the Vendor ID,
gives a total number of rejects, has a filter for a date range. I also have
a filter VendorID <> '?' to filter out our "internal" DMRs that are written
with NO VENDOR. If I remove that filter, my full report includes all
vendors AND our internal DMRs. I can't add CEP (Canyon Engineering
Products) as a vendor for internal DMRs, because accounting says "NO." So,
here is the tricky part: I want a list of only those internal DMRs, the
ones with '?' in the vendor ID. No way. If I change the filter to VendorID
= '?', I get no records found. VendorID = ' ' (space), no records found.
Vendor ID >= , or <= , same result. Is there any way to filter out the real
vendors?

Thanks in advance,
Lydia



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/links
Yahoo! Groups Links









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/links
Yahoo! Groups Links
Hello, all:

I have a fairly simple DMR supplier report. It is grouped on the Vendor ID,
gives a total number of rejects, has a filter for a date range. I also have
a filter VendorID <> '?' to filter out our "internal" DMRs that are written
with NO VENDOR. If I remove that filter, my full report includes all
vendors AND our internal DMRs. I can't add CEP (Canyon Engineering
Products) as a vendor for internal DMRs, because accounting says "NO." So,
here is the tricky part: I want a list of only those internal DMRs, the
ones with '?' in the vendor ID. No way. If I change the filter to VendorID
= '?', I get no records found. VendorID = ' ' (space), no records found.
Vendor ID >= , or <= , same result. Is there any way to filter out the real
vendors?

Thanks in advance,
Lydia
Can you place the filter as VenterID = ? (do not enclose it with quotes)

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Lydia Coffman
Sent: Monday, November 14, 2005 1:11 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] re: RB Filter question


Hello, all:

I have a fairly simple DMR supplier report. It is grouped on the Vendor ID,
gives a total number of rejects, has a filter for a date range. I also have
a filter VendorID <> '?' to filter out our "internal" DMRs that are written
with NO VENDOR. If I remove that filter, my full report includes all
vendors AND our internal DMRs. I can't add CEP (Canyon Engineering
Products) as a vendor for internal DMRs, because accounting says "NO." So,
here is the tricky part: I want a list of only those internal DMRs, the
ones with '?' in the vendor ID. No way. If I change the filter to VendorID
= '?', I get no records found. VendorID = ' ' (space), no records found.
Vendor ID >= , or <= , same result. Is there any way to filter out the real
vendors?

Thanks in advance,
Lydia



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/links
Yahoo! Groups Links