Drillthrough Max 1000 rows, any way to change?

#1

Is there anyway to change the max number of rows returned in a drillthrough?

#2

"Bill Jones" <wjones (AT) actcci (DOT) com> wrote

Quote:

Is there anyway to change the max number of rows returned in a
drillthrough?

DRILLTHROUGH statement supports MAXROWS clause. The default is 1000, but you
can change it to anything you want.
The documentation is available at
http://msdn.microsoft.com/library/de...dldml_8s50.asp

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Drillthrough Max 1000 rows, any way to change?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Drillthrough Max 1000 rows, any way to change? - 10-30-2003 , 09:13 AM

Re: Drillthrough Max 1000 rows, any way to change? - 11-04-2003 , 08:09 PM