property is too long

[JohnE]

I have a situation in running a report. I go thru a listbox and select all
the locations (100+). I go thru a second listbox and select all the accts
(30+). This is actually building a where clause. This all worked last year
at year end but this year there are more locations and accts.

As the report begins to run, I get the following message;

"The setting for this property is too long."

Not sure what this is referring to or how to correct it.
Is there a limitation that I should know about?
How is this corrected?

Thanks... John

 

[Marshall Barton]

I have a situation in running a report. I go thru a listbox and select all
the locations (100+). I go thru a second listbox and select all the accts
(30+). This is actually building a where clause. This all worked last year
at year end but this year there are more locations and accts.

As the report begins to run, I get the following message;

"The setting for this property is too long."

Not sure what this is referring to or how to correct it.
Is there a limitation that I should know about?
How is this corrected?

Use a shorter where clause. We can't see your code unless
you post it here so can not determine which property is
being used.

There may be a different way to do what you wanr. For
example, use an "All" item instead of selecting every item
in the list, or maybe use the IN operator or ??? Once we
can see the code, maybe someone will get an idea.

 

[Paul Shapiro]

When I build a Where clause from a multi-select listbox, I include code that
omits any filtering if either no rows are selected in the listbox or all the
rows are selected. This wouldn't help if all but 1 rows are selected, but at
least in my case that doesn't happen. It's either a few rows or all rows.