Ot crystal version 8

Shirley:

You CAN install office 97 on an XP box. You just have
uninstall any new version COMPLETELY before you can install
it. We do that here all the time. And as long as you have
a copy of office 2003, you technically have a copy of 97.
It's how we get around the issue of new computers with the
new version of office and the legacy of all of our access 97
databases we use here.

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of Shirley Graver
Sent: Thursday, June 02, 2005 1:13 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT CRYSTAL VERSION 8


I tried all of the suggestions, the only problem is that
it's an access97
data base and I'm on Office 2003. (I have a legal Office
97 disk but all my
machines are XP so it won't install) My mail program also
won't let go of
it to let me tinker. Oh Well, what I'm doing works well
enough. I've
uploaded my list of spam domains, 7700 in a text file for
any mail host that
allows filtering on domains. I also have an excel sheet
with all the IP's
in the world cross referenced with the country of
residence, but that's 40
megabytes. If anyone wants a copy of that I'll need to
RAR it up and send
it in pieces.

Shirley

Tracking #: 1F8902AE9CE1CE43A0DCCC94D1AFCFF5D8DBCD58


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



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

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.



[Non-text portions of this message have been removed]
Is is just me or are the alerts and BAM pretty worthless without
writing a specific alert app for each one? I keep tweaking my BAM
and general Alerts without any ability to show true tangible feed
back. The best I can get looks like the following:

===== RMA STATUS CHANGE ========
Jill 16:10:46 Open: Open -> Closed

I can see that a user has closed a RMA, but what one?

-----------------------------------------------------------

Even the canned alerts in vista only show limited information.
Here's an alert I get from Global Alerts when a RFQ Response has been
received.

RFQ Number (2129 ) Line Number (1 ) from Vendor (Robinson Steel ) has
been received.

Part Number ( ) Source ( ) ( ).

This RFQ number means nothing to anyone except the person filling RFQ
requests, Vendor name is good, Part number or originating quote #
does not pass through.

---------------------------------------------------------

I need help. Whether you have an alert program that I could use in
the BAM or have had better luck setting up alerts, please email me.
My mail host (SLMAIL) keeps an ACESS database of email traffic. I've been
using Crystal to scan that data base for SPAM addresses. I've been
filtering out the "good" traffic so that only (mostly) the "bad" traffic
shows when I run the report. I then export that list to excel, clean it up
a bit more then cut and paste all the " bad " addresses into my blacklist.
( I can also generate wildcards for the "rotators" ). It all takes about 3
or 4 minutes once or twice a day. It seems to be effective; I've gone from
about 150 spam's a day for 24 users to about 5 spam's for a day for 24
users.

My question is I've bumped into a size limit in Crystal's record selection:
I get about 100 "{MessageTraffic.SenderDomain} <> "customer.COM" before
Crystal pukes and says "TOO COMPLEX" Is there a better way to configure the
filter so that I can add to my hearts content. As a reward I'll share my
black list :-)

{@DATE} >= CurrentDate
and
{MessageTraffic.SenderDomain} <> "inhouseaddress.org"
AND
{MessageTraffic.SenderDomain} <> "customer.COM"
AND
{MessageTraffic.SenderDomain} <> "customer.COM"
AND
{MessageTraffic.SenderDomain} <> "customer.COM"



Shirley Graver
Sys Admin
Rubber Associates.

Tracking #: 513E24F59D7FDF4083C0B166772F4897A26A68F3


[Non-text portions of this message have been removed]
Use an Access database/Excal Spreadsheet to store the names in. The you can
limit the data to those that are not in Access/Excel.


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

Just a thought, you might able to create a parameter field that uses
import pick list (a text file of your filter list) and then use the
parameter field to conditionally suppress a section. I have never
actually tried this. I did something similar years ago using a dynamic
array formula that Crystal provided. Are you importing your blacklist
into Exchange? I just started Exchange 2003 last weekend and I think it
has that filtering capability?

Have fun.

Dan Shallbetter
States Electric Mfg.


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Shirley Graver
Sent: Wednesday, June 01, 2005 1:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] OT CRYSTAL VERSION 8


My mail host (SLMAIL) keeps an ACESS database of email traffic. I've
been
using Crystal to scan that data base for SPAM addresses. I've been
filtering out the "good" traffic so that only (mostly) the "bad" traffic
shows when I run the report. I then export that list to excel, clean it
up
a bit more then cut and paste all the " bad " addresses into my
blacklist.
( I can also generate wildcards for the "rotators" ). It all takes
about 3
or 4 minutes once or twice a day. It seems to be effective; I've gone
from
about 150 spam's a day for 24 users to about 5 spam's for a day for 24
users.

My question is I've bumped into a size limit in Crystal's record
selection:
I get about 100 "{MessageTraffic.SenderDomain} <> "customer.COM" before
Crystal pukes and says "TOO COMPLEX" Is there a better way to configure
the
filter so that I can add to my hearts content. As a reward I'll share
my
black list :-)

{@DATE} >= CurrentDate
and
{MessageTraffic.SenderDomain} <> "inhouseaddress.org"
AND
{MessageTraffic.SenderDomain} <> "customer.COM"
AND
{MessageTraffic.SenderDomain} <> "customer.COM"
AND
{MessageTraffic.SenderDomain} <> "customer.COM"



Shirley Graver
Sys Admin
Rubber Associates.

Tracking #: 513E24F59D7FDF4083C0B166772F4897A26A68F3




*




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

How about,
Making a subreport and creating an SQL statement like this:

You can create another table that holds the set of complete values. For
example, create a table called CheckList with one field called RollNo.
Then add records 1,2,3,4,5,6,7,8,9,10. Now, you can use this SQL
statement
to return the missing values:

SELECT RollNo
FROM CheckList
WHERE CheckList.RollNo NOT IN (SELECT RollNo FROM MyTable)

(this is courtesy of Raymond)

Just a thought,

John Mansfield
General Sheet Metal
I tried all of the suggestions, the only problem is that it's an access97
data base and I'm on Office 2003. (I have a legal Office 97 disk but all my
machines are XP so it won't install) My mail program also won't let go of
it to let me tinker. Oh Well, what I'm doing works well enough. I've
uploaded my list of spam domains, 7700 in a text file for any mail host that
allows filtering on domains. I also have an excel sheet with all the IP's
in the world cross referenced with the country of residence, but that's 40
megabytes. If anyone wants a copy of that I'll need to RAR it up and send
it in pieces.

Shirley

Tracking #: 1F8902AE9CE1CE43A0DCCC94D1AFCFF5D8DBCD58


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