To register for an Internet.com membership to receive newsletters and white papers, use the Register button ABOVE.
To participate in the message forums BELOW, click here
VBForums  

VB Wire News
Part 10 of the Visual Basic .NET 2010 Express Tutorial Complete!
How to Use the Visual Studio Code Analysis Tool FxCop
Article :: Interview with Andrei Alexandrescu (Part 3 of 3)
Introducing Visual Studio LightSwitch
Visual Studio LightSwitch Beta 1 is Available



Go Back   VBForums > Visual Basic > Visual Basic .NET

Reply Post New Thread
 
Thread Tools Display Modes
Old Sep 29th, 2006, 04:08 AM   #1
obscuregirl
Lively Member
 
Join Date: Aug 06
Location: UK
Posts: 96
obscuregirl is an unknown quantity at this point (<10)
Resolved [RESOLVED] [2005] Changing the format of a number field in Crystal Report (again!)

Hi

This is linked to a previously resolved thread that I posted. (http://www.vbforums.com/showthread.p...10#post2629010)

Basically I have hardcoded parameter field that is a year e.g. 2004, with hardcoded values. I've tried setting it up as a Number so that I can manipulate it as a number in the Record Selection Formula e.g. 2004 + 1. The problem I'm having is that the Parameter Field Editor converts 2004 to 2,004.00!

In the previous thread, bmahler kindly gave me an answer to use the custom format to force the parameter to be something like 2004. I did this and it worked in the report preview. But I have just tried running it through my application and it is showing up as the 2,004.00 format again!!! Any ideas anyone?
obscuregirl is offline   Reply With Quote
Old Nov 17th, 2006, 08:36 AM   #2
obscuregirl
Lively Member
 
Join Date: Aug 06
Location: UK
Posts: 96
obscuregirl is an unknown quantity at this point (<10)
Re: [2005] Changing the format of a number field in Crystal Report (again!)

I've found the answer elsewhere, the formula to use is ToText({fieldname},0,"")
obscuregirl is offline   Reply With Quote
Reply

Go Back   VBForums > Visual Basic > Visual Basic .NET


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 05:21 AM.





Acceptable Use Policy

Internet.com
The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.