Community
Showing results for 
Search instead for 
Do you mean 
Reply

Format Numbers in ACT Reports

Copper Elite Contributor
Posts: 405
Country: United States

Format Numbers in ACT Reports

We have a number field that is displaying as 100000. If we set the type to Number, it displays as 100,000.00.

 

We want 100,000. Is there a format command that can do this? Anybody have sample code? Thanks!

Geoffrey B. Boulden
Twelve/Three Marketing, Inc.
Buffalo, NY
ACT!
SageCRM
GoldMine
SQL Certifications
Platinum Elite Contributor
Posts: 14,384
Country: Australia
Copper Elite Contributor
Posts: 405
Country: United States

Re: Format Numbers in ACT Reports

Thanks Mike but thatarticle does not seem to apply to ACT 2011.

 

I dont have the options that are shown. The only option is Number and that puts 2 characters to the left. I was hoping that someone had a vbscript example. I can't seem to get one to work.

 

This report writer has a 1997 smell to it....

Geoffrey B. Boulden
Twelve/Three Marketing, Inc.
Buffalo, NY
ACT!
SageCRM
GoldMine
SQL Certifications
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Format Numbers in ACT Reports

I don't use the report writer ... but the article does list ACT! 2011 at the bottom

And I've just checked ... it's the same in 2011 and 2012
Platinum Elite Contributor
Posts: 6,663
Country: USA

Re: Format Numbers in ACT Reports

That KB document is valid for ACT! 2005 and later. However those properties use Windows system settings and can't be individually changed. To accomplish what you want you need to have the field added to the report template as you have done and then you need to hide the field (height and width aren't important just so they are a value greater than zero). Then you add a custom field to the template and use a Visual Basic script statement to display and format the field as currency with the desired decimal places.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Elite Contributor
Posts: 405
Country: United States

Re: Format Numbers in ACT Reports

Thanks Roy,

 

That makes perfect sense to me.

Geoffrey B. Boulden
Twelve/Three Marketing, Inc.
Buffalo, NY
ACT!
SageCRM
GoldMine
SQL Certifications