Wednesday, March 7, 2012

Report Builder - A filter is required

Using Report Builder, I am querying a table that has:

85,000 rows
5 columns

The report will run with only 4 of the columns, but when I add the 5th (data type is nvarchar(1024)), I get an error message that says:

Cannot run this report.
A filter must be specified.

When I add a filter on that 5th column, it will run.

Does anyone know if there is a record limit in Report Builder? Is there some sort of governor that I can modify?

Thanks in advance!I think I figured this out. The entity in my model had a property called "InstanceSelection" with the value of "MandatoryFilter." I cannot completely explain what this property does, but I changed the value to "List" and fixed the problem.

I don't know why the filter was mandatory only when the 5th column was there.

No comments:

Post a Comment