Report generation with cocoon
Hi, This must be a well known scenario. I have some data obtained from database which has to be displayed in a html. I used esql to get data. In the html page(with data as tables) I have to place a hyperlink which when linked should generate a excel file using the same data. Is there a way I can re use the resultset without quering the database again? Or can I use this html page as input to my excel generation? Can someone suggest how I can do this. Thanks, Anna. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Report generation with cocoon
On Thu, Mar 04, 2004 at 01:37:43PM -0500, Anna Bikkina wrote: > Hi, > > This must be a well known scenario. > > I have some data obtained from database which has to be displayed in a html. I > used esql to get data. In the html page(with data as tables) I have to place > a hyperlink which when linked should generate a excel file using the same > data. > > Is there a way I can re use the resultset without quering the database again? > Or can I use this html page as input to my excel generation? > > Can someone suggest how I can do this. Have you taken a look at xReporter? http://xreporter.cocoondev.org/ If you do not want to use it, you could extract the code its Cocoon presentation layer uses to do the excel output format generation. However, it is a very nice tool so you might consider using it directly. --Tim Larson - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Report generation with cocoon
Other than xreporter is there a way I can do this. I do not want to introduce xreporter because I have only one report and I dont want to add complexity to my existing application. I have a xsp file that generates output which has to be converted to html(thats working) . I need the same resultset obtained in the xsp file to generate a excel if the user requests. Is there a way I can avoid quering the database again? If no, is there a way I can use the html ouput(built with the result data from database) as input to my excel generation. Please reply.. Thanks, Anna. On Thursday 04 March 2004 03:00 pm, Tim Larson wrote: > On Thu, Mar 04, 2004 at 01:37:43PM -0500, Anna Bikkina wrote: > > Hi, > > > > This must be a well known scenario. > > > > I have some data obtained from database which has to be displayed in a > > html. I used esql to get data. In the html page(with data as tables) I > > have to place a hyperlink which when linked should generate a excel file > > using the same data. > > > > Is there a way I can re use the resultset without quering the database > > again? Or can I use this html page as input to my excel generation? > > > > Can someone suggest how I can do this. > > Have you taken a look at xReporter? > http://xreporter.cocoondev.org/ > > If you do not want to use it, you could extract the code its Cocoon > presentation layer uses to do the excel output format generation. > > However, it is a very nice tool so you might consider using it directly. > > --Tim Larson > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Report generation with cocoon
Store the result in the session, by using one or more of the session transformers. http://cocoon.apache.org/2.1/userdocs/transformers/writedomsession-transform er.html One pipeline genereates the result, stores it in the session and generates the HTML. Another pipeline reads the result from the session and generates the Excel version. Askild - Anna Bikkina wrote: > Other than xreporter is there a way I can do this. I do not > want to introduce > xreporter because I have only one report and I dont want to > add complexity to > my existing application. > > I have a xsp file that generates output which has to be converted to > html(thats working) . I need the same resultset obtained in > the xsp file to > generate a excel if the user requests. Is there a way I can > avoid quering the > database again? If no, is there a way I can use the html > ouput(built with the > result data from database) as input to my excel generation. > > Please reply.. > > > Thanks, > Anna. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]