#Error displayed when null data

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

#Error displayed when null data

Author

Topic

sqlbug
Posting Yak Master

201 Posts

Posted - 2010-08-17 : 15:41:57

I have this report where I need to format the data to a precision based on the parameter. Plus I need to make sure when data is exported to excel - it is not exported as text.
At the same time, I need to allow null data. So I am using something like:


=IIf(Fields!DATA_VALUE.Value >= 0 And Fields!DATA_VALUE.Value < 9980,FormatNumber(Fields!DATA_VALUE.Value,Fields!AMETH_PRECISION.Value)*1.000,Nothing)

But it comes up with #Error in all the null fields - that I don't think is appropriate.
Any ideas how to fix it?
Thanks.

X002548
Not Just a Number

15586 Posts

Posted - 2010-08-17 : 16:00:46

is this reporting services?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

sqlbug
Posting Yak Master

201 Posts

Posted - 2010-08-17 : 16:08:43

It's a SQL Report (2005) sitting on a ASP .NET page using a ReportViewer control.
Thanks.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources