drill-down in excel format

dear all,

anyone know how to make a report using RS to create a drill-down with chart in excel format?

meaning i need a report showing in chat format in excel. and then i also able to drill-down the report. and the chat figure will change follow the drill.

Hello,

The Excel renderer generates charts as static images, not as Excel charts. If you want live Excel charts that update when you change the source data, you should use SoftArtisans OfficeWriter (http://officewriter.softartisans.com).

-Chris

|||

tat is a tools to generate report right?

i not looking for a tools, but i looking a way to settle it. because i got the reporting service at my company already. management will not spend other fund to buy other software.

so any walkaround?

|||

There is no workaround without a third-party tool. The native Excel renderer always exports charts as static images. Even if the Excel renderer did export real Excel charts, Excel itself doesn't support the notion of hyperlink actions when clicking on parts of a chart.

-Chris

|||

so this mean only can use the third-party tool to read data from the database directly?

so in this case the microsoft RS is not able to use. am i right?

|||

Now I'm confused about what your goal is. What exactly is your requirement? Can you please explain it again?

I thought you were trying to export charts to Excel that you can click on and be drilled through to different targets depending on where in the chart you clicked.

What do you mean "read data from the database directly"?

-Chris