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

Drill down report in HTML

edited August 2005 in Server
Hello

I have a complicated task I now need to perform with report builder - a
drill down report in HTML!

I have a report that produces several charts - one chart for each day in the
month

I need the user to be able to click on one of these charts and a new report
get generated

Essentially every chart in the report needs to be turned into a link.

I assume I have to modify the HTML that is generated?

Is there any way that I can modify the HTML on the report Server, not the
webtier?

Also, I am not sure how I would find each chart within the HTML?

Cheers

Paul

Comments

  • edited August 2005

    ReportBuilder's built-in drill down report feature is not supported for
    server based reports.

    The WebTier receives TppPage objects from the server and uses the TrsXHTML
    device to generate the XHTML.

    Server --> Page.DrawCommands[] ---> WebTier ---> XHTML ---> Web Browser

    Anything that you do with XHTML needs to be done in the WebTier. You could
    modify the XHTML before it is sent to the browser. Try generating some
    reports and then from the Web Browser, perform a View | Source on the XHTML.
    Perhaps that will provide some clue as to how you might identify the chart.



    --
    Nard Moseley
    Digital Metaphors Corporation
    http://www.digital-metaphors.com



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited August 2005
    Ok thats a shame, but I will see what I can do,

    Its a real shame that I cant get to the HTML at the server lol

    Do I have any control on the filenames of the temporary images generated by
    report builder for each chart on my report?

    I am going to have to search through the HTML for each picture and place a
    link around the tag for the image, but each link is going to be different as
    the graphs are all for different days.

    Cheers

    Paul

    PS - Please can you respond to my zooming question asap as this one is
    causing me big problems at the moment

  • edited August 2005

    The image names are generated internally by the webtier and cannot be
    customized. For each report there is an Report\Images\ImageDirectory.txt
    stored in the web cache. It contains the names of the images.

    One option might be to put a label in the report that appears prior to each
    chart. Then you search the html for the label text.




    --
    Nard Moseley
    Digital Metaphors Corporation
    http://www.digital-metaphors.com


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited September 2005
    Nard, i'm looking for a similar problem/solution.

    But, how can we access the XHTML code ??


  • edited September 2005

    The WebTier.ProcessWebRequest method that is called from the web module
    returns the XHTML string that is sent to the web browser. The HTML response
    string may have references to other XHTML pages that reside in the WebTier's
    cache files that are stored on the hard drive.


    --
    Nard Moseley
    Digital Metaphors Corporation
    http://www.digital-metaphors.com



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.