Export Drill-down reports to HTML.

rbuser

I am facing a problem that was probably seen by a lot of people. I wish to
export a report to HTML that has drill-down sub-reports. What is the best
approch to this situation?

I can imagine, that using JavaScript, it is possible to get the behavior of
drill-down component in HTML (I have seen a number of sites do this). This
seems like the best thing. Are there any 3rd party HTML devices that have
this functionality?

Another approch might be to expand the report before doing the export, but
this breaks a bit the idea of a drill-down.

Thanks in advance for any advice...

--
Yoav Abrahami
R&D Software Engineer
T-Soft - The Essence of Network Knowledge
---------------------------------------------------------------------
Tel: +972 (0)9-971-3148 (Direct)
Tel: +972-(0)9-971-3131 (Main)
Fax: +972-(0)9-971-3133
E-mail: yoav@tsoft-tele.com
www.tsoft-tele.com

digitalmetaphors

Using the Report Server Edition 7.02 and the new Custom Parameters feature,
it should be possible to create a drill down behavior where the client
report can send parameters back to the server so that the report on the
server can regenerate the pages and send them back to the client in support
of drill down. It would require some coding on your part and we have not
coded an example of this, but it should be doable now with Custom Parameter
support in RB 7.02. This would be a cool demo for sure!


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Hi Jim,

What you are suggesting is a cool feature (and I think you should add it as
a built in feature. I have seen a number of systems with reporting
capabilities where this is the best selling feature). However, I think of
another feature.
I think about an export to one file, that includes the drill-down
components. pressing on a drill-down component will open or close the
drill-down (just like in the default viewer). I know it can be done using
DHTML (I can give you pointers, if you are interested).
The two features are different, becouse my idea does not require the user to
have an open connection to the server or database, allowing to send a report
by email to someone not having RB infrastructure installed.

Yoav.

digitalmetaphors

We haven't researched it to evaluate the different options to accomplish
this technically. If you have a suggestion for an approach then feel free to
send a simple example or your ideas to support@digital-metaphors.com


Cheers,

Jim Bennett
Digital Metaphors