You mean like using the character format option on the String function?
STRING(52.32,'>>.99') produces a string of "52.32". >> = blank when zero for left of decimal point. .99 is the right of decimal precision. If the field was previously used without formatting you might need to manually reduce the string character width in the Format... option on the field and also select Match Format.
-Todd C.
-----Original Message-----
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com]On Behalf Of Mark Howard
Sent: Tuesday, October 25, 2005 8:07 AM
To: '
vantage@yahoogroups.com'
Subject: RE: [Vantage] Report builder help- try not to show 0 on a report
That is better but still have problem with the field now being a text field
format and have the length as 10 so if I have a figure like 53.32 it shows
as 52.3200000 10 characters or 1234.56 shows as 1234.56000 how do you trim
but still leave .00 at the end of a whole number
Regards,
Mark Howard
Jaws Buckets & Attachments
10 Willingdon st
Brisbane
Australia
-----Original Message-----
From: Shirley Graver [mailto:
shirleyg@...]
Sent: Tuesday, 25 October 2005 8:41 PM
To:
vantage@yahoogroups.com
Subject: [SPAM++++] RE: [Vantage] Report builder help- try not to show 0 on
a report
Hi Mark,
Add as part of your calculation string((integer(debit *
100))/100) and you'll get your two digit decimal as a string. Depending on
how touchy the "rounding" issue is you may have to add the "ROUND" function
to the calculation.
Shirley Graver
Rubber Associates Inc.
_____
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf Of
Mark Howard
Sent: Monday, October 24, 2005 6:23 PM
To: '
vantage@yahoogroups.com'
Subject: [Vantage] Report builder help- try not to show 0 on a report
I'm writing a G/L report and am creating a debit and credit column.
Firstly I want the - transaction amount to show a number without the
negative sign and secondly data that is 0.00 to be blank...
Please help!!
So far
IIF(TransAmt <= 0 , (TransAmt - TransAmt - TransAmt) , 0 ). The only way
with my knowledge to change the - amount to a positive number was to do the
above
The next problem I have is anything 0 is showing up with 0.00 which I just
want blank
So I tried to do a string command to take out the 0
iif(string (debit)="0","",string (debit)) this work ok but now If format of
a field is say 9 character wide and the number is say 32.42 it shows a
32.42000 or 4432.10 show as 4432.100
Tried converting them back to numbers and I get the 0.00 entry's back
Regards,
Mark Howard
Jaws Buckets & Attachments
10 Willingdon st
Brisbane
Australia
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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
SPONSORED LINKS
Manufacturing
<
http://groups.yahoo.com/gads?t=ms <
http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing> &k=Manufacturing+software&w1=Manufacturing
+software&w2=Membership+database+software&w3=Database+mortgage+software&
+w4=P
da+database+software&w5=Database+management+software&w6=Database+marketi
da+database+ng+s
oftware&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software
Membership
<
http://groups.yahoo.com/gads?t=ms <
http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufac> &k=Membership+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
turing+twar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+marke
ting+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software
Database
<
http://groups.yahoo.com/gads?t=ms <
http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufactu> &k=Database+mortgage+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
ring+are&
w4=Pda+database+software&w5=Database+management+software&w6=Database+marketi
ng+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda
<
http://groups.yahoo.com/gads?t=ms <
http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+> &k=Pda+database+software&w1=Manufacturing+
software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pd
a+database+software&w5=Database+management+software&w6=Database+marketin
a+database+g+so
ftware&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software
Database
<
http://groups.yahoo.com/gads?t=ms <
http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufac> &k=Database+management+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
turing+twar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+marke
ting+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management
ting+software
Database
<
http://groups.yahoo.com/gads?t=ms <
http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufact> &k=Database+marketing+software&w1=Manufact
uring+software&w2=Membership+database+software&w3=Database+mortgage+soft
uring+ware
&w4=Pda+database+software&w5=Database+management+software&w6=Database+market
ing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software
_____
YAHOO! GROUPS LINKS
* Visit your group "vantage <
http://groups.yahoo.com/group/vantage> "
on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:
vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<
http://docs.yahoo.com/info/terms/> .
_____
Tracking #: 53F7B937ED71CE4FA316A7A7951327FB50E56DEA
[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
Yahoo! Groups Links
--
Scanned by ISheriff
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
_____
YAHOO! GROUPS LINKS
* Visit your group " vantage <
http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:
vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]