Excel Drill-Down Report

How can I create a Drill-Down Report for Excel ?
I've created a report with several Lists. The visibilty of the lists depends
on a Parameter:
For Example:
=Parameters!managementsummary.Value.ToString() = "0"
This works fine for HTML and other outputs but not for excel. I always get a
RenderingError. Perhaps someone can help me.If you use tables and set the drill down visibility (ToggleItem
property) at group level rather than cell level, the export to excel
automatically recreates the drill down using 'Groups and Outlines'.
Chris
Karpo wrote:
> How can I create a Drill-Down Report for Excel ?
> I've created a report with several Lists. The visibilty of the lists
> depends on a Parameter:
> For Example:
> =Parameters!managementsummary.Value.ToString() = "0"
> This works fine for HTML and other outputs but not for excel. I
> always get a RenderingError. Perhaps someone can help me.|||Found the Error...was the matrix...a self calculated row
"Karpo" wrote:
> How can I create a Drill-Down Report for Excel ?
> I've created a report with several Lists. The visibilty of the lists depends
> on a Parameter:
> For Example:
> =Parameters!managementsummary.Value.ToString() = "0"
> This works fine for HTML and other outputs but not for excel. I always get a
> RenderingError. Perhaps someone can help me.