Wrox Programmer Forums
|
Reporting Services SQL Server Reporting Services. Please specify which version.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Reporting Services section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 22nd, 2008, 07:08 PM
Registered User
 
Join Date: Jul 2003
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Default Field Values

Is there a way to set default values for a numeric field? I have several fields that sometimes are null. I want the nulls to show as zero. I tried iif(value is null, 0.00 , value) but it gives an error on the “null” word. I tried “IsNull”, “IsNothing” and “IsNumeric” all with the same error.

Any ideas?
 
Old February 19th, 2008, 05:52 PM
Registered User
 
Join Date: Jul 2003
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

OK, I figured it out. isnull(field,0) will put in a zero if the field is null.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Programmatically update field default value srcLakeJake Access VBA 6 October 26th, 2007 01:29 PM
Default values in XMLSchema johnnyclock BOOK: Beginning XML 3rd Edition 0 February 3rd, 2006 06:06 PM
Default values? Raymie_C Access VBA 2 May 16th, 2005 11:48 AM
Default Values davest Access VBA 2 October 19th, 2004 05:57 AM
Field Default lryckman Access 1 August 13th, 2003 07:13 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.