BASIC report builder question

Thanks, I think I'll be able to figure it out from here...It just takes awhile to remember stuff.

Lydia


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Shirley Graver
Sent: Tuesday, January 09, 2007 8:10 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BASIC report builder question



Lydia,
I've just uploaded my stable of Vendor performance reports, There is
also another .prl for Vendor performance by another member. You should be
able to modify them to suit your needs.

Shirley

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On Behalf Of
rfc822 Compliance issue From: added by system POTENTIAL SPAM
Sent: Monday, January 08, 2007 7:28 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] BASIC report builder question

Hi, All:

Well, I've been away for awhile and have forgotten a barrel of stuff about
report builder. I'm working on a Vendor Average Days Late Report. (Vantage
6.1). I'm trying to formulate an IIF statement that will exclude early
shipments (in this case, they are <0). We aren't going to ding anyone for
shipping early, only late.

So far, everything I put behind the beginning of my statement either doesn't
have a proper argument, or a complete one. Am I missing a total, a space,
commas, or brain cells?

Any ideas will be greatly appreciated.

IIF (RcvDtl.ReceiptDate - DueDate) <0,

Thanks,
Lydia
Canyon Engineering Products

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

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







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

Well, I've been away for awhile and have forgotten a barrel of stuff about report builder. I'm working on a Vendor Average Days Late Report. (Vantage 6.1). I'm trying to formulate an IIF statement that will exclude early shipments (in this case, they are <0). We aren't going to ding anyone for shipping early, only late.

So far, everything I put behind the beginning of my statement either doesn't have a proper argument, or a complete one. Am I missing a total, a space, commas, or brain cells?

Any ideas will be greatly appreciated.

IIF (RcvDtl.ReceiptDate - DueDate) <0,

Thanks,
Lydia
Canyon Engineering Products



[Non-text portions of this message have been removed]
Just off the top of my head.... What table is DueDate in?

--- In vantage@yahoogroups.com, "Lydia Coffman" <lcoffman@...> wrote:
>
> Hi, All:
>
> Well, I've been away for awhile and have forgotten a barrel of
stuff about report builder. I'm working on a Vendor Average Days
Late Report. (Vantage 6.1). I'm trying to formulate an IIF
statement that will exclude early shipments (in this case, they are
<0). We aren't going to ding anyone for shipping early, only late.
>
> So far, everything I put behind the beginning of my statement
either doesn't have a proper argument, or a complete one. Am I
missing a total, a space, commas, or brain cells?
>
> Any ideas will be greatly appreciated.
>
> IIF (RcvDtl.ReceiptDate - DueDate) <0,
>
> Thanks,
> Lydia
> Canyon Engineering Products
>
>
>
> [Non-text portions of this message have been removed]
>
Lydia,
Try IIF (RcvDtl.ReceiptDate - DueDate < 0,True, False)
I think you can shorten to IIF (RcvDtl.ReceiptDate - DueDate < 0) if you are
not going to define custom True or False parts.
If my memory serves.
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Lydia Coffman
Sent: Monday, January 08, 2007 7:24 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BASIC report builder question


Hi, All:

Well, I've been away for awhile and have forgotten a barrel of stuff about
report builder. I'm working on a Vendor Average Days Late Report. (Vantage
6.1). I'm trying to formulate an IIF statement that will exclude early
shipments (in this case, they are <0). We aren't going to ding anyone for
shipping early, only late.

So far, everything I put behind the beginning of my statement either
doesn't have a proper argument, or a complete one. Am I missing a total, a
space, commas, or brain cells?

Any ideas will be greatly appreciated.

IIF (RcvDtl.ReceiptDate - DueDate) <0,

Thanks,
Lydia
Canyon Engineering Products


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






[Non-text portions of this message have been removed]
Lydia,
I've just uploaded my stable of Vendor performance reports, There is
also another .prl for Vendor performance by another member. You should be
able to modify them to suit your needs.

Shirley

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
rfc822 Compliance issue From: added by system POTENTIAL SPAM
Sent: Monday, January 08, 2007 7:28 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BASIC report builder question



Hi, All:

Well, I've been away for awhile and have forgotten a barrel of stuff about
report builder. I'm working on a Vendor Average Days Late Report. (Vantage
6.1). I'm trying to formulate an IIF statement that will exclude early
shipments (in this case, they are <0). We aren't going to ding anyone for
shipping early, only late.

So far, everything I put behind the beginning of my statement either doesn't
have a proper argument, or a complete one. Am I missing a total, a space,
commas, or brain cells?

Any ideas will be greatly appreciated.

IIF (RcvDtl.ReceiptDate - DueDate) <0,

Thanks,
Lydia
Canyon Engineering Products


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






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