Can't vouch for the syntax of the Progress procedure part but when RB barfs
on a calculated field due to "Invalid Operation" I almost always find that
it is due to lack of a space between things. In this case I would be really
suspicious about the '2'or'3'or'4' where I would try a space between the
single-quotes and the or's. Also between the " and the + near the end of
the second line. Just a guess.
-Todd C.
-----Original Message-----
From: vtaeroman [mailto:
brento@...]
Sent: Friday, October 18, 2002 6:36 AM
To:
vantage@yahoogroups.com
Subject: [Vantage] Progress procedure to run Report Builder
I am having a problem with the filter statement in the Progress
procedure that runs Report Builder.
I have successfully used this procedure before to run reports that
have a simple filter statement. The filter statement I am using now
is as follows:
strRBFilter = "LaborDtl.Company = 'VTAERO' AND (LaborDtl.PayrollDate
>= " + STRING(Date2_rb) + " AND LaborDtl.PayrollDate <= "+ STRING
(Date1_rb) + ") AND LaborDtl.ActiveTrans = 'No' AND LaborDtl.JCDept
= '2'or'3'or'4'or'5'or'8'or'11'or'12'or'15'or'16'".
The error I am getting now is " RB Filter contains an error at Offset
136: Invalid operation". I have tried removing what appears to be
the problem statement only to get the error at a different offset.
I was told the offset refers to the character position in the string
with the numbering starting with the the first character after the
opening ". Is this correct and can anyone tell me what could be
wrong with my syntax?
Any help would be appreciated.
Brent O'Donnell
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=237459.2482214.3895589.2146399/D=egroupweb/S=17050071
83:HM/A=1278097/R=0/*
http://www.verisign.com/cgi-bin/go.cgi?a=b3087010792600
4000>
<
http://us.adserver.yahoo.com/l?M=237459.2482214.3895589.2146399/D=egroupmai
l/S=:HM/A=1278097/rand=840953398>
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]