Thanks, Troy, that did the job. Once again thanks to the group for
all the advice.
Martin Horton
Assistant Group IT Manager
PRD Holdings Ltd.
all the advice.
Martin Horton
Assistant Group IT Manager
PRD Holdings Ltd.
--- In vantage@y..., "Troy Funte" <tfunte@e...> wrote:
> Try the simple Crystal syntax of:
>
> If {Aptran.Doctramt} >= 0 Then "Invoice" Else "Credit Note"
>
>
> See if that works.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: marthorton2000
> To: vantage@y...
> Sent: Thursday, May 30, 2002 3:38 AM
> Subject: [Vantage] Re: Crystal Reports Errors
>
>
> The report I'd modified was chkprint. We currently don't have
the
> correct cheque stationary so I'd produced a two part cheque
print.
> All I needed was to run the Remittences. Basically this report
was
> just making use of the .dbf files that come out of Vantage. There
are
> no ODBC links there and the only formula I used was :
> IIF ({Aptran.Doctramt}>=0,"Invoice" ,"Credit Note" ). I've had
> problems with using formulae in Vantage before although they
produced
> a different error and we're more complex. I'm not sure how I
could
> rewrite this formula if I needed to? I couldn't think of a
better
> way to do it.
>
> Thanks for the feedback everyone. Epicor support wasn't too
helpful.
>
> Martin Horton
> PRD Holdings Ltd
>
> --- In vantage@y..., "Michael Miles" <mmiles@c...> wrote:
> > I had the same 515 error this week. Changed a few formulae on
our
> PO,
> > previewed and printed fine using Crystal 8.0 (Vantage 5.0).
When I
> tried it
> > from Vantage I would get 515.
> >
> > I reversed my changes one at a time until the error went away.
It
> ended up
> > being my use of Cdbl, I changed it to ToNumber and all was well.
> >
> > Annoying that what works in Crystal doesn't work in Vantage.
> > -----Original Message-----
> > From: marthorton2000 [mailto:martinh@p...]
> > Sent: Thursday, 30 May 2002 2:06 AM
> > To: vantage@y...
> > Subject: [Vantage] Crystal Reports Errors
> >
> >
> > We're currently implementing Vantage 5.1 and I've just
redesigned a
> > report for use within our company. It's nothing complex and
only
> has
> > three formula fields which just test to see if a number is
positive
> > or negative. The report works fine from within Crystal (v8.0)
but
> as
> > soon as I try to get Vantage to use it it gives me an Error 515
> > message. I'm 99% sure there is nothing wrong with the report
itself
> > as Crystal prints it ok. Vantage even give me the error
message and
> > I have Crystal Reports installed on my machine so that rules
out a
> > DLL problem. Any ideas anybody?
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> 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
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
> [Non-text portions of this message have been removed]