BAQ help Blank Title 64441

Yahoo Archive
1
It doesn't look like the normal Crystal report... it doesn't have the logo, it appears to just be a system generated report.

--- In vantage@yahoogroups.com, "P" <pklein@...> wrote:
>
>
> If you already have a VAntage report - and it is a crystal report - you can create a new report style that is more user friendly and exports easier to a spreadsheet.
>
>
>
>
> --- In vantage@yahoogroups.com, "bryandavis1980" <bryandavis1980@> wrote:
> >
> > Hello,
> > I am trying to create change a report to a more user friendly format, something that can be neatly exported to excel. Anyway from reading some of the posts I read that the easiest way to do this is to create a BAQ then generate a report from there. Well I am in the process of creating the BAQ but I get a little lost when it comes to picking what tables I need in Phrase Builder. It's for Count Variance Report and these are the following fields I am looking for, just not sure what tables they live in or if I am even going in the right direction. Thanks for your help!
> >
> > Part Number
> > Dimension
> > Lot Number
> > Bin
> > Tag
> > Expected Qty UM
> > Expected Value
> > Counted Qty UM
> > Counted Value
> > Variance Qty UM
> > Variance Value
> >
>
2
I know I have seen this addressed before, but I cannot find it..



I have my sales rep list, and I want to break it down in my BAQ. I
figured that I could use a calculated field to break it up into pieces I
can use. I am new to progress, and don't know what functions to use to
break "INT~BSC~GRE~PAY" into pieces. Something similar to the excel
"LEFT()" function.. I cannot seem to find anything on this...



Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************





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



You can use this string and just change the number based on the rep1,rep2,
etc. and the depending on what table the table name from OrderHed.



Entry(1,OrderHed.SalesRepList,"~~")





Stevev



-----Original Message-----
From: Matt Caldwell [mailto:matt@...]
Sent: April 30, 2008 2:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ help



I know I have seen this addressed before, but I cannot find it..

I have my sales rep list, and I want to break it down in my BAQ. I
figured that I could use a calculated field to break it up into pieces I
can use. I am new to progress, and don't know what functions to use to
break "INT~BSC~GRE~PAY" into pieces. Something similar to the excel
"LEFT()" function.. I cannot seem to find anything on this...

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso <http://www.kerusso.com> com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

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





[Non-text portions of this message have been removed]
4
> I have my sales rep list, and I want to break it down in my BAQ. I
> figured that I could use a calculated field to break it up into pieces I
> can use. I am new to progress, and don't know what functions to use to
> break "INT~BSC~GRE~PAY" into pieces. Something similar to the excel
> "LEFT()" function.. I cannot seem to find anything on this...

The closest thing I can find that does this is

ENTRY(item_nbr, text_string, delim)

ENTRY(2, "INT~BSC~GRE~PAY, "~") would return "BSC"

So if you know which number you want in the list, then you're golden. If you
want to expand the list and "link" it to records then you're SOL.

Mark W.
5
Perfect! It worked!



Thanks!



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of vantage
Sent: Wednesday, April 30, 2008 2:09 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ help



Matt,

You can use this string and just change the number based on the
rep1,rep2,
etc. and the depending on what table the table name from OrderHed.

Entry(1,OrderHed.SalesRepList,"~~")

Stevev

-----Original Message-----
From: Matt Caldwell [mailto:matt@... <mailto:matt%40kerusso.com>
]
Sent: April 30, 2008 2:04 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ help

I know I have seen this addressed before, but I cannot find it..

I have my sales rep list, and I want to break it down in my BAQ. I
figured that I could use a calculated field to break it up into pieces I
can use. I am new to progress, and don't know what functions to use to
break "INT~BSC~GRE~PAY" into pieces. Something similar to the excel
"LEFT()" function.. I cannot seem to find anything on this...

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso <http://www.kerusso.com> com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

[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]
6
Matt, use MATCHES
You don't need to break the string down at all

Here's a sample of a query I use:

for each OrderHed where ( OrderHed.SalesRepList MATCHES 'dist04' OR OrderHed.SalesRepList MATCHES 'e199' OR OrderHed.SalesRepList MATCHES 'e201' OR OrderHed.SalesRepList MATCHES 'e347') no-lock , each Customer where (OrderHed.Company = Customer.Company and OrderHed.CustNum = Customer.CustNum) no-lock by OrderHed.OrderNum.

But you actually build the query in the BAQ through a GUI.
on 1st tab of BAQ, click the Phrase Builder button
In the criteria grid, you set the AndOr column on entries 2 and beyond to OR, CompOp column to MATCHES and the Constant column you enter the possible sales IDs.
In my example above,
the salesreplist field for an order might be: "dist04~e199~~~'
and that would match.



----- Original Message ----
From: Matt Caldwell <matt@...>
To: vantage@yahoogroups.com
Sent: Wednesday, April 30, 2008 2:03:32 PM
Subject: [Vantage] BAQ help


I know I have seen this addressed before, but I cannot find it..

I have my sales rep list, and I want to break it down in my BAQ. I
figured that I could use a calculated field to break it up into pieces I
can use. I am new to progress, and don't know what functions to use to
break "INT~BSC~GRE~ PAY" into pieces. Something similar to the excel
"LEFT()" function.. I cannot seem to find anything on this...

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso com
************ ********* ********* ********* ********* ********* *********
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
************ ********* ********* ********* ********* ********* *********

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




____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

[Non-text portions of this message have been removed]
7
Matt, You will need to update the filter when using the Entry to add the if
then statement as shown below. If you do not you will find your server log
file with many errors as the Entry command hits the files that do not have
any rep on them. Just change both of the values from 1 to 2 and so on for
the reps



If Num-Entries(OrderHed.SalesRepList, "~~") >= 1 then Entry(1,
OrderHed.SalesRepList, "~~") else ""



Steve





-----Original Message-----
From: Matt Caldwell [mailto:matt@...]
Sent: April 30, 2008 2:16 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ help



Perfect! It worked!

Thanks!

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of vantage
Sent: Wednesday, April 30, 2008 2:09 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] BAQ help

Matt,

You can use this string and just change the number based on the
rep1,rep2,
etc. and the depending on what table the table name from OrderHed.

Entry(1,OrderHed.SalesRepList,"~~")

Stevev

-----Original Message-----
From: Matt Caldwell [mailto:matt@kerusso. <mailto:matt%40kerusso.com> com
<mailto:matt%40kerusso.com>
]
Sent: April 30, 2008 2:04 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ help

I know I have seen this addressed before, but I cannot find it..

I have my sales rep list, and I want to break it down in my BAQ. I
figured that I could use a calculated field to break it up into pieces I
can use. I am new to progress, and don't know what functions to use to
break "INT~BSC~GRE~PAY" into pieces. Something similar to the excel
"LEFT()" function.. I cannot seem to find anything on this...

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso <http://www.kerusso <http://www.kerusso.com>
com> com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

[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]





[Non-text portions of this message have been removed]
8
Hello,
I am trying to create change a report to a more user friendly format, something that can be neatly exported to excel. Anyway from reading some of the posts I read that the easiest way to do this is to create a BAQ then generate a report from there. Well I am in the process of creating the BAQ but I get a little lost when it comes to picking what tables I need in Phrase Builder. It's for Count Variance Report and these are the following fields I am looking for, just not sure what tables they live in or if I am even going in the right direction. Thanks for your help!

Part Number
Dimension
Lot Number
Bin
Tag
Expected Qty UM
Expected Value
Counted Qty UM
Counted Value
Variance Qty UM
Variance Value
9
What version are you on? Inventory counts changes greatly from 8.03 to 9.05...


[Non-text portions of this message have been removed]
10
Currently running vista 8.03.409C

--- In vantage@yahoogroups.com, "Lisser, Jennifer" <Jennifer.Lisser@...> wrote:
>
> What version are you on? Inventory counts changes greatly from 8.03 to 9.05...
>
>
> [Non-text portions of this message have been removed]
>
11
If you already have a VAntage report - and it is a crystal report - you can create a new report style that is more user friendly and exports easier to a spreadsheet.




--- In vantage@yahoogroups.com, "bryandavis1980" <bryandavis1980@...> wrote:
>
> Hello,
> I am trying to create change a report to a more user friendly format, something that can be neatly exported to excel. Anyway from reading some of the posts I read that the easiest way to do this is to create a BAQ then generate a report from there. Well I am in the process of creating the BAQ but I get a little lost when it comes to picking what tables I need in Phrase Builder. It's for Count Variance Report and these are the following fields I am looking for, just not sure what tables they live in or if I am even going in the right direction. Thanks for your help!
>
> Part Number
> Dimension
> Lot Number
> Bin
> Tag
> Expected Qty UM
> Expected Value
> Counted Qty UM
> Counted Value
> Variance Qty UM
> Variance Value
>