can excel view drill throughs in a pivot table

I'm building pivot tables in Excel 2000 based on data cubes from SQL 2000
Analysis Services. Is there anyway to view the drill down from the data
fields in a Excel pivot table? I try doubleclicking in a data field cell
and get a message saying that I can only get detail from rows or columns.
****************************************
*********
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
****************************************
*********Oh, the message you are receiving is because you are clicking on a cell and
Excel does not have native drillthrough capabilities. A good example of
modifying Excel (via VBA) to have drillthrough capabilities can be found at:
http://www.windowsitpro.com/SQLServ...0382/40382.html
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>
Blog at:: http://spaces.msn.com/members/denster/
"Andy S." <andymcdba1@.noreply.yahoo.com> wrote in message
news:%23WCO5Op9FHA.808@.TK2MSFTNGP09.phx.gbl...
> I'm building pivot tables in Excel 2000 based on data cubes from SQL 2000
> Analysis Services. Is there anyway to view the drill down from the data
> fields in a Excel pivot table? I try doubleclicking in a data field cell
> and get a message saying that I can only get detail from rows or columns.
>
> --
> ****************************************
*********
> Andy S.
> MCSE NT/2000, MCDBA SQL 7/2000
> andymcdba1@.noreply.yahoo.com
> Please remove "noreply" before replying.
> ****************************************
*********
>

can excel view drill throughs in a pivot table

I'm building pivot tables in Excel 2000 based on data cubes from SQL 2000
Analysis Services. Is there anyway to view the drill down from the data
fields in a Excel pivot table? I try doubleclicking in a data field cell
and get a message saying that I can only get detail from rows or columns.

*************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
*************************************************
Oh, the message you are receiving is because you are clicking on a cell and
Excel does not have native drillthrough capabilities. A good example of
modifying Excel (via VBA) to have drillthrough capabilities can be found at:
http://www.windowsitpro.com/SQLServe...382/40382.html
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>
Blog at:: http://spaces.msn.com/members/denster/
"Andy S." <andymcdba1@.noreply.yahoo.com> wrote in message
news:%23WCO5Op9FHA.808@.TK2MSFTNGP09.phx.gbl...
> I'm building pivot tables in Excel 2000 based on data cubes from SQL 2000
> Analysis Services. Is there anyway to view the drill down from the data
> fields in a Excel pivot table? I try doubleclicking in a data field cell
> and get a message saying that I can only get detail from rows or columns.
>
> --
> *************************************************
> Andy S.
> MCSE NT/2000, MCDBA SQL 7/2000
> andymcdba1@.noreply.yahoo.com
> Please remove "noreply" before replying.
> *************************************************
>

Can drill through reports display parameters

I have a top level report in which I am select a particular run. The id for
that run is passed to a child report which uses the id from that run to
generate a list of possible values to generate the drill through report. My
problem is that I seem to have to set both values from the top level report
and then the second report does not show the parameters. If I browse
directly to the second report then I have the option of entering parameters.
Should I be able to see parameters when drill into a reportI forgot to mention that when I am in the designer the parameters are always
visible, but when I deploy to website and try to browse the report, that is
when they ar not visible.
"slumley" wrote:
> I have a top level report in which I am select a particular run. The id for
> that run is passed to a child report which uses the id from that run to
> generate a list of possible values to generate the drill through report. My
> problem is that I seem to have to set both values from the top level report
> and then the second report does not show the parameters. If I browse
> directly to the second report then I have the option of entering parameters.
> Should I be able to see parameters when drill into a report|||I have the same problem but only with the latest CTP (Sept), it worked fine
in the June version.
"slumley" wrote:
> I forgot to mention that when I am in the designer the parameters are always
> visible, but when I deploy to website and try to browse the report, that is
> when they ar not visible.
> "slumley" wrote:
> > I have a top level report in which I am select a particular run. The id for
> > that run is passed to a child report which uses the id from that run to
> > generate a list of possible values to generate the drill through report. My
> > problem is that I seem to have to set both values from the top level report
> > and then the second report does not show the parameters. If I browse
> > directly to the second report then I have the option of entering parameters.
> >
> > Should I be able to see parameters when drill into a report