Drill down report in HTML
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
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
This discussion has been closed.
Comments
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
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
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
But, how can we access the XHTML code ??
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