June CTP - How to inspect for Empty String

Thanks for your response but neither option work. I did confirm that Len(field.Value) is 0 by displaying on the report. For some reason when used in the IIf function, the comparison, Len(field.Value) = 0 fails.

[211 byte] By [KKaps] at [2007-12-16]

«« display checkbox in datagrid for database cols with Y/N values
»» VS 6 to .NET 2003 Migration

# 1

System.String.IsNullOrEmpty(Fields!Variable.Value) also does not evaluate to true when the string is empty.

KKaps at 2007-9-9 >

top of Msdn Tech,SQL Server,SQL Server Reporting Services...

# 2

Try using =Iif(field.value=""

EdLehman-Msft at 2007-9-9 >

SQL Server

Sql stored procedure call hangs from .net
Obtaining destination e-mail address
Named Pipes Provider: Could not open a connection to SQL Server [2]
change distributor ?
Problem with SQL Server 2000 DTS Package:Column Delimiter not found
Problem in Context connection of CLR Trigger
Scripting in C#?
Which sql statement is more efficient
Problems with Lookup task and dates
Login failed for user <<domain>>\<<server name>>$

SQL Server Reporting Services

ANN:Dundas Chart for Reporting Services now in Beta
Express Versus Standard Footprint
Login failed for user '<<domain>>\<<server>>$'.
Blank pages in report preview
HELP!!!! - Report parameter "Read Only"
Is it possible to use ssas as datasource for report builder in june ctp?
Get value of 10 textboxes to decide footer color
Parameterized Connect String
Specifying todays date in Subscription Parameters
Report manager was not working please help me

SQL Server Hot Topic

Named Pipes Provider: Could not open a connection to SQL Server [2]
Problems with Lookup task and dates
Login failed for user '<<domain>>\<<server>>$'.
Blank pages in report preview
xmla files
GACing components
Full Text "And Not" Fails
sys.objects vs. sysobjects in master..sp_ stored procs

SQL Server New Topic

ANN:Dundas Chart for Reporting Services now in Beta
OLE DB Destination issue in ForEach Data Flow
[Time].&[2007].&[2] vs.[Time].[2007].[SEMI2]
Modifying graph range
Using SProc to expose attributes to Data Flow stream
Default Value of Parameter using expression - ERROR!
executing dmx query (prediction join) in ssis does not process all rows, works in SSMS
Unhandled Exception...Please check the version of the database

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

June CTP - How to inspect for Empty String document under SQL Server Reporting Services classified...

June CTP - How to inspect for Empty String

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified