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