Report builder

Yahoo Archive
1
Take a look at the PartMtl table and filter on MtlPartNum to get the PartNum
(where used).
-Todd C.

-----Original Message-----
From: Fredy Venczel [mailto:fvenczel@...]
Sent: Wednesday, September 18, 2002 8:31 AM
To: Vantage (E-mail)
Subject: [Vantage] report builder



I'm a novice when it comes to Report Builder. Can anyone let me know if this
is possible? I like to create a report where I can select a range of active
purchased parts and then see where they are used. I can figure out the first
part but is it possible to get the "where used"? If it's possible can some
point me in the right direction. I know vantage has a where used report but
I don't want to enter in part by part.

thanks


Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=234081.2377872.3808768.2225242/D=egroupweb/S=17050071
83:HM/A=1225247/R=0/*http://ad.doubleclick.net/clk;4547223;7007303;y?http://
www.ameriquestmortgage.com/welcome.html?ad=Yahoo01>

<http://us.adserver.yahoo.com/l?M=234081.2377872.3808768.2225242/D=egroupmai
l/S=:HM/A=1225247/rand=421365061>

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]
2
I have not used report builder before and just starting from scratch. Does
anyone out there have work instructions or how to use information for report
builder? I have printed the online help, but anything and everything would
be great.
Thanks in advance for the help!

Kimberly Maxwell
Westwood Precision, Inc.
PH: 425-347-1303 Ext. 41
Fax: 425-353-8945
email: kimberly.maxwell@...
www.westwoodprecision.com
3
Kim,

I would strongly suggest going to a report builder class. It is very good
and you will get alot out of it.

Mark Pladson at Epicor does a great job.

Wayne Katzenberger

-----Original Message-----
From: Kimberly Maxwell [mailto:kimberly.maxwell@...]
Sent: Thursday, October 26, 2000 3:39 PM
To: vantage@egroups.com
Subject: [Vantage] report builder


I have not used report builder before and just starting from scratch. Does
anyone out there have work instructions or how to use information for report
builder? I have printed the online help, but anything and everything would
be great.
Thanks in advance for the help!

Kimberly Maxwell
Westwood Precision, Inc.
PH: 425-347-1303 Ext. 41
Fax: 425-353-8945
email: kimberly.maxwell@...
www.westwoodprecision.com



We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
4
Ditto on Mark at Epicor. He has some great tips for improving speed of RB
reports. Class is worth it just for performance improvements. Example
adding Company to joins has cut several of my reports from 2-3 minutes to
6-7 seconds. Plus you will get insights into Vantage DB structure that
won't be in any written guide.
-Todd C.

-----Original Message-----
From: Wayne Katzenberger [mailto:wkatz@...]
Sent: Thursday, October 26, 2000 3:43 PM
To: vantage@egroups.com
Subject: RE: [Vantage] report builder


Kim,

I would strongly suggest going to a report builder class. It is very good
and you will get alot out of it.

Mark Pladson at Epicor does a great job.

Wayne Katzenberger

-----Original Message-----
From: Kimberly Maxwell [mailto:kimberly.maxwell@...]
Sent: Thursday, October 26, 2000 3:39 PM
To: vantage@egroups.com
Subject: [Vantage] report builder


I have not used report builder before and just starting from scratch. Does
anyone out there have work instructions or how to use information for report
builder? I have printed the online help, but anything and everything would
be great.
Thanks in advance for the help!

Kimberly Maxwell
Westwood Precision, Inc.
PH: 425-347-1303 Ext. 41
Fax: 425-353-8945
email: kimberly.maxwell@...
www.westwoodprecision.com



We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)



eGroups Sponsor
<http://click.egroups.com/1/9661/13/_/411782/_/972593067/>


<http://adimg.egroups.com/img/9661/13/_/411782/_/972593067/WarningHome468x60
2E.gif>

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)




[Non-text portions of this message have been removed]
5
At 04:38 PM 10/26/2000 , you wrote:
>I have not used report builder before and just starting from scratch. Does
>anyone out there have work instructions or how to use information for report
>builder? I have printed the online help, but anything and everything would

I too prefer printed documentation. You may have noticed the "DynaText"
online help viewer leaves a lot to be desired, esp for printing any of the
manuals. It doesn't know how to print contents or indexes, or even pickup
a correct page number unless you print from page one.

As of Progress ver 9.1, you can get the manuals in PDF format; a much
better tool for viewing and printing. Sure, some of the development tools
and administrative stuff are new and improved with 9.1, but the Report
Builder and other fundamentals are pretty much unchanged. See:
http://www.progress.com/v9/documentation/start.htm
The Report Builder Tutorial and User's Guide can get you up to speed, IF
you have used similar tools, or have some in house help, and can understand
the Vantage Data Dictionaries. Otherwise, as someone else said, Epicor's
classes have gotten good reviews.

-Wayne Cox
6
Wayne,

Do you think the same holds true for Vantage ?

Todd Anderson

-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Thursday, October 26, 2000 3:54 PM
To: vantage@egroups.com
Subject: Re: [Vantage] report builder


At 04:38 PM 10/26/2000 , you wrote:
>I have not used report builder before and just starting from scratch. Does
>anyone out there have work instructions or how to use information for
report
>builder? I have printed the online help, but anything and everything would

I too prefer printed documentation. You may have noticed the "DynaText"
online help viewer leaves a lot to be desired, esp for printing any of the
manuals. It doesn't know how to print contents or indexes, or even pickup
a correct page number unless you print from page one.

As of Progress ver 9.1, you can get the manuals in PDF format; a much
better tool for viewing and printing. Sure, some of the development tools
and administrative stuff are new and improved with 9.1, but the Report
Builder and other fundamentals are pretty much unchanged. See:
http://www.progress.com/v9/documentation/start.htm
<http://www.progress.com/v9/documentation/start.htm>
The Report Builder Tutorial and User's Guide can get you up to speed, IF
you have used similar tools, or have some in house help, and can understand
the Vantage Data Dictionaries. Otherwise, as someone else said, Epicor's
classes have gotten good reviews.

-Wayne Cox



eGroups Sponsor
<http://click.egroups.com/1/9630/13/_/411782/_/972594017/>


<http://adimg.egroups.com/img/9630/13/_/411782/_/972594017/target(apparel)46
8x60.gif>

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
7
At 05:11 PM 10/26/2000 , you wrote:
>Do you think the same holds true for Vantage ?

Do you mean about the printed documentation? Vantage's online help is
pretty good for "what's this field" sort-of questions, or searching for topics.

But I would like to have a LOT more documentation on the "behind the
scenes" theory of operation. Job Costing, for example, we know little
about after almost a year of live operation. Out new cost accountant will
be trying to figure it out, mostly via empirical testing I suspect. Uuh
Ohh... hope there's nothing in the contract about reverse engineering
we'll be violating trying to figure it out ! :)

-Wayne
8
Company should be included in every join from the start. Reports
won't be correct without it if there are more than two companies
in your db. Plus that will save having to redo every report in
the evenr that you add one. And as you state... this speeds up
many reports because an index may be utilized.

Todd Caughey wrote:
>
> Ditto on Mark at Epicor. He has some great tips for improving speed of RB
> reports. Class is worth it just for performance improvements. Example
> adding Company to joins has cut several of my reports from 2-3 minutes to
> 6-7 seconds. Plus you will get insights into Vantage DB structure that
> won't be in any written guide.
> -Todd C.
>
> -----Original Message-----
> From: Wayne Katzenberger [mailto:wkatz@...]
> Sent: Thursday, October 26, 2000 3:43 PM
> To: vantage@egroups.com
> Subject: RE: [Vantage] report builder
>
> Kim,
>
> I would strongly suggest going to a report builder class. It is very good
> and you will get alot out of it.
>
> Mark Pladson at Epicor does a great job.
>
> Wayne Katzenberger
>
> -----Original Message-----
> From: Kimberly Maxwell [mailto:kimberly.maxwell@...]
> Sent: Thursday, October 26, 2000 3:39 PM
> To: vantage@egroups.com
> Subject: [Vantage] report builder
>
> I have not used report builder before and just starting from scratch. Does
> anyone out there have work instructions or how to use information for report
> builder? I have printed the online help, but anything and everything would
> be great.
> Thanks in advance for the help!
>
> Kimberly Maxwell
> Westwood Precision, Inc.
> PH: 425-347-1303 Ext. 41
> Fax: 425-353-8945
> email: kimberly.maxwell@...
> www.westwoodprecision.com
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> <http://www.egroups.com/files/vantage/>
> (Note: If this link does not work for you the first time you try it, go to
> www.egroups.com, login and be sure to save your password, choose My Groups,
> choose Vantage, then choose Files. If you save the password, the link above
> will work the next time you try it.)
>
> eGroups Sponsor
> <http://click.egroups.com/1/9661/13/_/411782/_/972593067/>
>
>
> <http://adimg.egroups.com/img/9661/13/_/411782/_/972593067/WarningHome468x60
> 2E.gif>
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> <http://www.egroups.com/files/vantage/>
> (Note: If this link does not work for you the first time you try it, go to
> www.egroups.com, login and be sure to save your password, choose My Groups,
> choose Vantage, then choose Files. If you save the password, the link above
> will work the next time you try it.)
>
> [Non-text portions of this message have been removed]
>
>
> We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)
9
Try the Controller's Workshop class from Epicor. It goes into great detail
about where $ go relating to every type of transaction done in Vantage.
Nora Story

-----Original Message-----
Wayne wrote:

But I would like to have a LOT more documentation on the "behind the
scenes" theory of operation. Job Costing, for example, we know little
about after almost a year of live operation. Out new cost accountant will
be trying to figure it out, mostly via empirical testing I suspect
10
Afternoon:

I am trying to write a Report Builder report to compare job costs to the selling price on the sales order. This is for a particular customer over a certain period of time. I have my joins as follows:

orderdetail to jobprod by company, order number, line number
jobprod to jobmatl by company and job number
jobprod to joboper by company and job number

All joins are inner joins. The correct information is shown in all of the fields I selected (actual costs of matl, labor, burden, and subcontract). I created a total aggregate field for each individual cost column resetting on job number. Here's my problem. The report shows all the detail lines in multiple. That is (in my case 35, 7 operations x 5 materials) the number of operation lines times the number of material lines. The aggregate total is the sum of all 35 lines. I have tried putting the lines in a group footer but that didn't help. Does anyone have any suggestions? I am a digest user so if you want to respond directly, feel free.

Thanks,
Mel Warniment, so called report writer
Gilson Screen Inc.


[Non-text portions of this message have been removed]
11
Welcome to report building, what you have is called an A-B A-C join. This
doesn't work effectively in Progress and most other SQL databases. The
easiest way out is to use the jobasmbl table for your cost. Your labor,
burden, matl and sub costs are all rolled up in one neat little area.
Otherwise you need to use preprocessed agregate counts and divide subtotals
by counts. It gets so ugly it I should not even mention it. Luckily in this
case you have an out. Your other solution is to export to ddf tables and use
Foxpro, it support A-B A-C joins. Hope this helps or someone comes up with a
better idea.

-----Original Message-----
From: gilsonscreen@... [mailto:gilsonscreen@...]
Sent: Thursday, November 02, 2000 3:28 PM
To: onelist
Subject: [Vantage] report builder


Afternoon:

I am trying to write a Report Builder report to compare job costs to the
selling price on the sales order. This is for a particular customer over a
certain period of time. I have my joins as follows:

orderdetail to jobprod by company, order number, line number
jobprod to jobmatl by company and job number
jobprod to joboper by company and job number

All joins are inner joins. The correct information is shown in all of the
fields I selected (actual costs of matl, labor, burden, and subcontract). I
created a total aggregate field for each individual cost column resetting on
job number. Here's my problem. The report shows all the detail lines in
multiple. That is (in my case 35, 7 operations x 5 materials) the number of
operation lines times the number of material lines. The aggregate total is
the sum of all 35 lines. I have tried putting the lines in a group footer
but that didn't help. Does anyone have any suggestions? I am a digest user
so if you want to respond directly, feel free.

Thanks,
Mel Warniment, so called report writer
Gilson Screen Inc.


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



We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
12
Mel
There is a report called Sales Vs Costs-Closed Jobs.Prl I uploaded to
the Vantage group files a couple of weeks ago. Take a look at it, maybe
it will work for you.
Dennis
----- Original Message -----
From: gilsonscreen@...
To: onelist
Sent: Thursday, November 02, 2000 2:27 PM
Subject: [Vantage] report builder


Afternoon:

I am trying to write a Report Builder report to compare job costs to the selling price on the sales order. This is for a particular customer over a certain period of time. I have my joins as follows:

orderdetail to jobprod by company, order number, line number
jobprod to jobmatl by company and job number
jobprod to joboper by company and job number

All joins are inner joins. The correct information is shown in all of the fields I selected (actual costs of matl, labor, burden, and subcontract). I created a total aggregate field for each individual cost column resetting on job number. Here's my problem. The report shows all the detail lines in multiple. That is (in my case 35, 7 operations x 5 materials) the number of operation lines times the number of material lines. The aggregate total is the sum of all 35 lines. I have tried putting the lines in a group footer but that didn't help. Does anyone have any suggestions? I am a digest user so if you want to respond directly, feel free.

Thanks,
Mel Warniment, so called report writer
Gilson Screen Inc.


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


eGroups Sponsor


We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)



[Non-text portions of this message have been removed]
13
If you link to the JobAssembly Table (instead of the joboper and jobmatl)
and put a filter to only select assembly 0 and then create a calculated
field to add LLA to TLA for each labor, material, subcontracting and burden,
this will give you the total job cost.
14
I could use a little help on report builder. I'm trying to find a
field that has total burden costs for a quote. The only table I've
found with a field like that is "QuoteCst". I tried using that table
but the report doesn't work when joined to that table. (I don't think
that table contains any data).
Any suggestions?
Thanks for your help.
Rick
15
I'm a novice when it comes to Report Builder. Can anyone let me know if this
is possible? I like to create a report where I can select a range of active
purchased parts and then see where they are used. I can figure out the first
part but is it possible to get the "where used"? If it's possible can some
point me in the right direction. I know vantage has a where used report but
I don't want to enter in part by part.

thanks