Home Devices
New Blog Posts: Merging Reports - Part 1 and Part 2

Export Drill-down reports to HTML.

edited March 2003 in Devices
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

Comments

  • edited March 2003
    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


  • edited March 2003
    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.

  • edited March 2003
    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


This discussion has been closed.