RB and Quote Mod Fields

Marty, what you want to do is join QuoteHed to QuoteDtl, then from QuoteDtl
go to both QuoteQty and QuoteAsm, then from QuoteAsm to both QuoteOpr and
QuoteMtl. The QuoteCst table is a temp table used for internal
calculations. If memory serves me correctly the total numbers aren't stored
in the quotes, they are calculated. This means that you will have to
recreate the formulas in Report Builder.

Hope this helps,

Ted Kitch
ted@...

-----Original Message-----
From: Marty Kuphall [mailto:marty.kuphall@...]
Sent: Saturday, January 18, 2003 9:21 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RB and Quote Mod Fields

Is there a way to pull into RB the fields that display when you go into
quote
entry\line\worksheet? Specifically, I'm trying to pull in the fields that
display in the Costs column (Burden, Labor, Material, etc.) of the Worksheet
screen. There is a QuoteCst table which, according to the Data Dictionary,
has
the fields but I'm having trouble joining to it. Perhaps I'm missing the
correct
join sequence. I'm hoping I do not have to create the formulas in RB that
are
used to generate these numbers.

Any guidance is appreciated!

--
Marty Kuphall
Controller
Ultra Tool & Mfg., Inc.

Ph. 262-703-0455
Fx. 262-703-0468

marty.kuphall@...






Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/M=241773.2861420.4212388.1925585/D=egroupweb/S=17050071
83:HM/A=1394045/R=0/*http:/www.hgtv.com/hgtv/pac_ctnt/text/0,,HGTV_3936_5802
,FF.html> HGTV Dream Home Giveaway


<http://us.adserver.yahoo.com/l?M=241773.2861420.4212388.1925585/D=egroupmai
l/S=:HM/A=1394045/rand=127306789>

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!
<http://docs.yahoo.com/info/terms/> Terms of Service.


[Non-text portions of this message have been removed]
Is there a way to pull into RB the fields that display when you go into quote
entry\line\worksheet? Specifically, I'm trying to pull in the fields that
display in the Costs column (Burden, Labor, Material, etc.) of the Worksheet
screen. There is a QuoteCst table which, according to the Data Dictionary, has
the fields but I'm having trouble joining to it. Perhaps I'm missing the correct
join sequence. I'm hoping I do not have to create the formulas in RB that are
used to generate these numbers.

Any guidance is appreciated!

--
Marty Kuphall
Controller
Ultra Tool & Mfg., Inc.

Ph. 262-703-0455
Fx. 262-703-0468

marty.kuphall@...