[RESOLVED] [2005] Changing format of a Parameter Field in Crystal Report

obscuregirl · Sep 21st, 2006, 07:07 AM

Hi

I have logged this on the Crystal Forum but I'm not getting any answers there so thought I'd try this one!

I'm trying to set up a report (through Visual Studio 2005) that has a 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!

Is there any way of forcing the format to be 2004?

Thanks.

bmahler · Sep 21st, 2006, 09:20 AM

Why not pass in the date parameter when generating the report instead of hardcoding it.

Otherwise, if you ar using a number you can set a custom format to remove the comma and decimal places like so...

Set the decimals to 1
the rounding to 1 and uncheck the thousands seperator and you number should be 2004

obscuregirl · Sep 22nd, 2006, 11:06 AM

Thanks, that's working great now!

Sep 21st, 2006, 07:07 AM	#1
obscuregirl Lively Member Join Date: Aug 06 Location: UK Posts: 96	[RESOLVED] [2005] Changing format of a Parameter Field in Crystal Report Hi I have logged this on the Crystal Forum but I'm not getting any answers there so thought I'd try this one! I'm trying to set up a report (through Visual Studio 2005) that has a 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! Is there any way of forcing the format to be 2004? Thanks.

Sep 21st, 2006, 09:20 AM	#2
bmahler Frenzied Member Join Date: Oct 05 Location: Somewhere just west of the Atlantic Posts: 1,564	Re: [2005] Changing format of a Parameter Field in Crystal Report Why not pass in the date parameter when generating the report instead of hardcoding it. Otherwise, if you ar using a number you can set a custom format to remove the comma and decimal places like so... Set the decimals to 1 the rounding to 1 and uncheck the thousands seperator and you number should be 2004 __________________ Boooya Visual Studio 2008 Professional Don't forget to use [CODE]your code here[/CODE] when posting code Don't forget to rate helpful posts! If you're question was answered please mark your thread [Resolved] Code Contributions: PHP PHP Image Gallery v1.0 • PHP Image Gallery v2.0 VB 2005 Find Computers on a network • Simple License Encryption • SQL Server Database Access dll • Use Reflection to Return Crystal ReportDocument • Silently Print PDF • Generic Xml Serailizer Useful Links: (more to come) MSDN (The first and foremost) • MSDN Design Guidelines • API Reference • Inno Setup Compiler • Inno Setup Preprocessor • ISTool - Fairly easy to use GUI for creating inno setup projects • Connection Strings • NAnt -Automated Builds • Cruise Control .NET - Frontend for automated builds

Sep 22nd, 2006, 11:06 AM	#3
obscuregirl Lively Member Join Date: Aug 06 Location: UK Posts: 96	Re: [2005] Changing format of a Parameter Field in Crystal Report Thanks, that's working great now!

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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