The whole IT department (me) and that's all. Far too much danger letting
non-IT persons write reports. Had a VP-Finance once write an inventory
report in Excel that was wrong but not obviously. He left and a few years
later, after many audits, his successor discovered the valuation problem and
had to write down $250K of inventory. Roughly equal to the company net
profit that year. Not his fault and the auditors didn't ever catch it but
he got fired anyway. Far too easy to write a report and "believe" the
results without enough testing and verification. One wrong join and you can
be badly deceived.
Speaking of errors I think I was wrong about needing to pass memo fields
through an aggregate. Was thinking of function results (like
Report-Filter).
-Todd C.
-----Original Message-----
From: Tony Meschini [mailto:tmeschini@...]
Sent: Wednesday, September 26, 2001 1:14 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] "contains" in report builder
How many employees in your companies know how to write reports in report
builder and do you have company classes to train ?
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, September 26, 2001 11:20 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] "contains" in report builder
As a memo field you would have to run it through an aggregate function (I
use Minumum) on the record level. The use INDEX for the string. Filter if
-----Original Message-----
From: Paul Siebers [mailto:paul.siebers@...]
Sent: Wednesday, September 26, 2001 11:08 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] "contains" in report builder
How would I build a RB filter which examines a memo field like
Part.PurComments on whether it contains a given word within the string?
Placement of the word within the string varies, so unfortunately I couldn't
use a simple "starts with"....
TIA,
Paul Siebers
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
< http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/itapeorng4_11_12.gif
<http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/itapeorng4_11_12.gif> >
< http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/1111.jpg
<http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/1111.jpg> >
< http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/orgline.gif
<http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/orgline.gif> >
Start here...
< http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/clear.gif
<http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/clear.gif> >
Height:
3 4 5 6 7 8 ft 0 1 2 3 4 5 6 7 8 9 10 11in
< http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/clear.gif
<http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/clear.gif> >
Weight:
lbs. kg.
< http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/clear.gif
<http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/clear.gif> >
< http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/3333.gif
<http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/3333.gif> >
<
http://us.adserver.yahoo.com/l?M=210544.1579876.3135161.1261774/D=egroupmai
<http://us.adserver.yahoo.com/l?M=210544.1579876.3135161.1261774/D=egroupmai
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/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> > .
[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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=210544.1579876.3135161.1261774/D=egroupweb/S=17050071
83:HM/A=776675/R=0/*http://ads.track-star.com/adspace.ts?ts=1;2;217;107_220_
105_264> Lose 20 lbs by November 12th
<http://us.adserver.yahoo.com/l?M=210544.1579876.3135161.1261774/D=egroupmai
l/S=1705007183:HM/A=776675/rand=457712853>
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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
non-IT persons write reports. Had a VP-Finance once write an inventory
report in Excel that was wrong but not obviously. He left and a few years
later, after many audits, his successor discovered the valuation problem and
had to write down $250K of inventory. Roughly equal to the company net
profit that year. Not his fault and the auditors didn't ever catch it but
he got fired anyway. Far too easy to write a report and "believe" the
results without enough testing and verification. One wrong join and you can
be badly deceived.
Speaking of errors I think I was wrong about needing to pass memo fields
through an aggregate. Was thinking of function results (like
Report-Filter).
-Todd C.
-----Original Message-----
From: Tony Meschini [mailto:tmeschini@...]
Sent: Wednesday, September 26, 2001 1:14 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] "contains" in report builder
How many employees in your companies know how to write reports in report
builder and do you have company classes to train ?
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, September 26, 2001 11:20 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] "contains" in report builder
As a memo field you would have to run it through an aggregate function (I
use Minumum) on the record level. The use INDEX for the string. Filter if
> 0.-Todd C.
-----Original Message-----
From: Paul Siebers [mailto:paul.siebers@...]
Sent: Wednesday, September 26, 2001 11:08 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] "contains" in report builder
How would I build a RB filter which examines a memo field like
Part.PurComments on whether it contains a given word within the string?
Placement of the word within the string varies, so unfortunately I couldn't
use a simple "starts with"....
TIA,
Paul Siebers
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
< http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/itapeorng4_11_12.gif
<http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/itapeorng4_11_12.gif> >
< http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/1111.jpg
<http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/1111.jpg> >
< http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/orgline.gif
<http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/orgline.gif> >
Start here...
< http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/clear.gif
<http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/clear.gif> >
Height:
3 4 5 6 7 8 ft 0 1 2 3 4 5 6 7 8 9 10 11in
< http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/clear.gif
<http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/clear.gif> >
Weight:
lbs. kg.
< http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/clear.gif
<http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/clear.gif> >
< http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/3333.gif
<http://us.a1.yimg.com/us.yimg.com/a/di/dietsmart/3333.gif> >
<
http://us.adserver.yahoo.com/l?M=210544.1579876.3135161.1261774/D=egroupmai
<http://us.adserver.yahoo.com/l?M=210544.1579876.3135161.1261774/D=egroupmai
>l/S=1705007183:HM/A=776687/rand=954210413>
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/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> > .
[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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=210544.1579876.3135161.1261774/D=egroupweb/S=17050071
83:HM/A=776675/R=0/*http://ads.track-star.com/adspace.ts?ts=1;2;217;107_220_
105_264> Lose 20 lbs by November 12th
<http://us.adserver.yahoo.com/l?M=210544.1579876.3135161.1261774/D=egroupmai
l/S=1705007183:HM/A=776675/rand=457712853>
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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]