Tuesday, March 20, 2012

required filter on Ad-hoc reports

When using the Report Builder in SQL 2005 some larger reports give me an
error message = filter required.
I assume this is somthing is a setting somwhere but where?
--
Peter
Peter.freeborn@.halliburton.comGo to Filter from the menu bar and select a column for the filter, you can
have prompt as well for the user to select the values.
I think, the Adhoc is designed in such a way that you need to set a filter,
because without filter it will be a long running query and will have great
effects on various things.
Amarnath
"Peter" wrote:
> When using the Report Builder in SQL 2005 some larger reports give me an
> error message = filter required.
> I assume this is somthing is a setting somwhere but where?
> --
> Peter
> Peter.freeborn@.halliburton.com

No comments:

Post a Comment