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

obscuregirl · Sep 21st, 2006, 06: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, 08: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, 10:06 AM

Thanks, that's working great now!

Sep 21st, 2006, 06: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, 08:20 AM	#2
bmahler Frenzied Member Join Date: Oct 05 Location: Somewhere just west of the Atlantic Posts: 1,565	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, 10: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
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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