Is there an easy way in Reporting service to handle dbull in dataset
I am using the local mode of the new reportviewer control, when I feed the dataset to the report, if there are some dbull column, an exception will be thrown.
To those string column, I can set NULLVALUE property to empty, but to other datatype, like integer, datetime, money, what should I do
Thanks
dbnull
Hot Topic
- Win200K and MS SQL data retreival ?
- how to create sql server 2005 instance(after uninstalling sql server express)
- redirecting errors
- How to invoke C# code from SSIS? Can we script in C# for Script Task?
- Trigger Problem
- Failed to generate a user instance of SQL Server
- Adding SDF data into a Listview - C#
- Select - 4 hours
- Is Ad hoc reporting compatible with Web Applications
- Linking Oracle Servers
SQL Server
- What is up with Defaults in 2005????
- Connections to SQL Server Files (*.mdf) require SQL Server Express 2005
- SQL Server Reporting Services
- Sharepoint Report Viewer - Parameter Rendering Bug
- What is up with Defaults in 2005????
- Stored Procedure
- steps and design considerations for building a data warehouse
- what's happening to this?
- Importing unicode data from Oracle Database
- 1 GB memory limitation for SQL 2005 Express edition
dbnull
Kate O
Krishnan MSFT
If this solves your problem, please mark the question answered. Thanks. :)
renz2k7
If I use BindingDatasource.datasource = ds.tables(0), (BindDatasource is bound to ReportViewer), I will have exception if any field is null.
But if I use
BindingDatasource.datasource = ds
BindingDatasource.datamember = "Table1"
I don't get exception any more.
Don't why, but it works like charm.
Wei
New Guy
-- Robert