After I've been gone for three (3) weeks, I'd come back and go DUH!! too.
Have a nice vacation.
My comments were from an experience I had with a "Margin" report. Don't
exactly recall the details, but at least it was worth a shot.
Terry L. Williams I.S. Manager Chipsco, Inc. 9936 Liberty St. Ext.
Meadville, PA 16335
p.814-333-6331 x236 f.814-337-2548 c.814-671-8650 tlw@...
<mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, June 11, 2002 4:15 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB - ?????????? marks on report
Thanks but yes, the reset is OK and since I am subtracting the result would
have to be smaller.
One example line is
Billed Cost Margin Margin %
590.00 808.00 ????? -36.9% (a prototype job - expected to lose
money)
Margin should be -218.00
Many other such "negative" jobs correctly display, with neg sign. The % is
directly calculated from the Margin and it is correct. I tried changing the
format to designate "&" for unknown value instead of "?" and it still prints
????? so it can't be an unknown. I double checked all the links to be sure
I had left outers and I do. In all the agregates I ignore unknowns.
Lonnie - I did already try the string option - I get a string of ?????????
Terry - As shown above the Billed (Price) and Cost values are present and
correct and "something" is OK in Margin because the % is OK too. (% =
Margin / Billed * 100)
I changed the font (Arial to Courier) with no effect. I have also saved the
report to a PRL of its own with no effect either.
Maybe going away for 3 weeks will allow something to pop into my head. I'll
come back and go DUH!
Thanks for the ideas,
-Todd C.
-----Original Message-----
From: Michael D. Howard [mailto:mike@...]
Sent: Tuesday, June 11, 2002 2:14 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB - ?????????? marks on report
Hi Todd ...
You have the reset option on the aggregate set correctly? ... Maybe you're
getting a really huge number ...
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, June 11, 2002 1:23 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RB - ?????????? marks on report
OK, I've tried all the usual things to get rid of ?????????? appearing
instead of numbers. Very very simple report and I can' t figure out why I'm
getting question marks. Very randomly too. I have a very simple calculated
field called "Margin" which is Price - Cost. On the report both price and
cost print OK but margin prints as ???????. The field is formated as
->,>>>,>>9.99 so is far larger than needed when price is $800 and cost is
$500.
Price and Cost are both aggregate fields (in this case totalling for all
jobs for a part and reporting at part level). Both ignore unknowns and
zeros and I have verified that is not the case with the "raw" data where
?????? is showing up. I have printed all the component calculated fields
that go into Margin and none of them are ??????. I also use Margin in a
subsequent calculation of margin percentage (margin/price) and it displays
the correct number just fine. So I know there is a legitimate "value" there
but it is just not displaying.
Any other ideas I can check that cause question marks? I'm trying to get
this report done today so I can leave on vacation tomorrow.
Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.
[Non-text portions of this message have been removed]
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 http://docs.yahoo.com/info/terms/
< http://docs.yahoo.com/info/terms/>
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]
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
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Have a nice vacation.
My comments were from an experience I had with a "Margin" report. Don't
exactly recall the details, but at least it was worth a shot.
Terry L. Williams I.S. Manager Chipsco, Inc. 9936 Liberty St. Ext.
Meadville, PA 16335
p.814-333-6331 x236 f.814-337-2548 c.814-671-8650 tlw@...
<mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, June 11, 2002 4:15 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB - ?????????? marks on report
Thanks but yes, the reset is OK and since I am subtracting the result would
have to be smaller.
One example line is
Billed Cost Margin Margin %
590.00 808.00 ????? -36.9% (a prototype job - expected to lose
money)
Margin should be -218.00
Many other such "negative" jobs correctly display, with neg sign. The % is
directly calculated from the Margin and it is correct. I tried changing the
format to designate "&" for unknown value instead of "?" and it still prints
????? so it can't be an unknown. I double checked all the links to be sure
I had left outers and I do. In all the agregates I ignore unknowns.
Lonnie - I did already try the string option - I get a string of ?????????
Terry - As shown above the Billed (Price) and Cost values are present and
correct and "something" is OK in Margin because the % is OK too. (% =
Margin / Billed * 100)
I changed the font (Arial to Courier) with no effect. I have also saved the
report to a PRL of its own with no effect either.
Maybe going away for 3 weeks will allow something to pop into my head. I'll
come back and go DUH!
Thanks for the ideas,
-Todd C.
-----Original Message-----
From: Michael D. Howard [mailto:mike@...]
Sent: Tuesday, June 11, 2002 2:14 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB - ?????????? marks on report
Hi Todd ...
You have the reset option on the aggregate set correctly? ... Maybe you're
getting a really huge number ...
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, June 11, 2002 1:23 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RB - ?????????? marks on report
OK, I've tried all the usual things to get rid of ?????????? appearing
instead of numbers. Very very simple report and I can' t figure out why I'm
getting question marks. Very randomly too. I have a very simple calculated
field called "Margin" which is Price - Cost. On the report both price and
cost print OK but margin prints as ???????. The field is formated as
->,>>>,>>9.99 so is far larger than needed when price is $800 and cost is
$500.
Price and Cost are both aggregate fields (in this case totalling for all
jobs for a part and reporting at part level). Both ignore unknowns and
zeros and I have verified that is not the case with the "raw" data where
?????? is showing up. I have printed all the component calculated fields
that go into Margin and none of them are ??????. I also use Margin in a
subsequent calculation of margin percentage (margin/price) and it displays
the correct number just fine. So I know there is a legitimate "value" there
but it is just not displaying.
Any other ideas I can check that cause question marks? I'm trying to get
this report done today so I can leave on vacation tomorrow.
Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.
[Non-text portions of this message have been removed]
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 http://docs.yahoo.com/info/terms/
< http://docs.yahoo.com/info/terms/>
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]
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
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]