I have a very simple report, that pulls from a sample database with no NULL values. I have the report working fine, and have added a parameter and a filter to filter by user name.
I would like the option of running the report for all names. I changed the "AllowNull" value to true. When I try to run the report, I get the following error:
An error has occurred while processing Report 'talksafe1':
Object cannot be cast from DBNull to other types
How do I run both filtered and unfiltered data? Again, I have no NULL values in my database, it only contains 4 records.
=Fields.Manager = =Parameters.ManagerPrm.Value
AllowBlank = True
AllowNull = True
DataSource = SQLDatasource1
DisplayMember = Fields.Manager
ValueMember = Fields.Manager
Name = ManagerPrm
Text = Select Manager
Type = String
Visible = True
I would like the option of running the report for all names. I changed the "AllowNull" value to true. When I try to run the report, I get the following error:
An error has occurred while processing Report 'talksafe1':
Object cannot be cast from DBNull to other types
How do I run both filtered and unfiltered data? Again, I have no NULL values in my database, it only contains 4 records.
=Fields.Manager = =Parameters.ManagerPrm.Value
AllowBlank = True
AllowNull = True
DataSource = SQLDatasource1
DisplayMember = Fields.Manager
ValueMember = Fields.Manager
Name = ManagerPrm
Text = Select Manager
Type = String
Visible = True