Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7
This is the forum to discuss the Wrox book Professional SQL ServerReporting Services by Paul Turley, Todd Bryant, James Counihan, George McKee, Dave DuVarney; ISBN: 9780764568787
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 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
  #1 (permalink)  
Old January 7th, 2005, 05:49 AM
Registered User
 
Join Date: Jan 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default iif Statement giving me a headache!

Hi Guys & Gals,

I'm creating a matrix report and have an iif statement that is giving me a headache and I just KNOW it's something simple! Please help

Code:
=iif(Sum( Fields!loadsIn.Value) = ""," ","(" + Sum(Fields!loadsIn.Value).ToString() + ")")
I get an error "The value expression for the textbox ‘loadsIn’ contains an error: Input string was not in a correct format."


Similar Threads
Thread Thread Starter Forum Replies Last Post
SelectedValueChanged event is giving me a headache SQLScott Pro Visual Basic 2005 1 January 2nd, 2008 06:46 PM
Can I make this a IIF Statement Corey Access VBA 1 November 3rd, 2006 08:40 AM
IIF Statement golden Access 2 August 3rd, 2004 01:32 AM
IIF Statement golden Access 3 July 12th, 2004 07:49 PM
IIF Statement Question fastcorvette Access 8 October 31st, 2003 11:01 PM





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