add code to interact with a report
I need to produce an html report in a web application, where i must have the possibility to press a button (in the report produced) and do something, e.g. open another html report,etc..
My data is in xml. Is it possible to use xslt and do that? Alternatively what do i need to accomplish that?
thanks
[318 byte] By [
pink floyd] at [2007-11-19 1:32:08]

# 1 Re: add code to interact with a report
Why can't u try with JavaScript ?
Add a button in ur HTML file and Capture the OnClick event of that button
in JavaScript & do the rest as u need ..
I think this will help u right ....
Suresh ...
# 2 Re: add code to interact with a report
My data is in xml. Is it possible to use xslt and do that? Alternatively what do i need to accomplish that?
Sure, normally one would use xsl to transform the xml into html, this transformation can be preformed either on the client or on the server. Assuming that one xml document contains some sort of reference (any kind of reference) to another xml document, you can use xsl to transform it to an html anchor, or button.
khp at 2007-11-10 3:28:53 >

# 3 Re: add code to interact with a report
Why can't u try with JavaScript ?
Add a button in ur HTML file and Capture the OnClick event of that button
in JavaScript & do the rest as u need ..
I think this will help u right ....
Suresh ...
I'am sorry but why on earth would you do that ?, using javascript to extract data from an XML file and display it in html is an absolute pain, whereas xsl was pretty much designed for this. As far as creating buttons to open up other documents, thats easily done in html, using javascript will only complicate things.
khp at 2007-11-10 3:29:54 >

# 4 Re: add code to interact with a report
Yes Correct,
Xslt is the Best method to display the Xml data. I have tried it by opening the Xml file which has associated Xslt file. But i dont know how to achieve this when i click a command button in Vb and display the XMl data.
Actually what i need is, i have to convert the Sql server data into XMl file and apply the XSLt for that file and display it in Explorer. This process has to be done when i click a Command button in VB6.0. Is it a Correct method ?
Can anyone help me with sample code to solve my problem ?
Suresh ......
# 5 Re: add code to interact with a report
Actually what i need is, i have to convert the Sql server data into XMl file and apply the XSLt for that file and display it in Explorer. This process has to be done when i click a Command button in VB6.0. Is it a Correct method ?
Well if you want something displayed i a browser, the most obvious way to do that would be to have a http server take care of the Database -> XML generation, and preforably also the XML->HTML conversion.
As far as opening a web browser from a VB6 application goes, I am sure that is quite possible and have it point at a specific URL should also be very easy. But I'am not a VB kind of guy, so I won't figure that part out for you.
khp at 2007-11-10 3:32:04 >
