How to export as HTML

[Former Member]

Hello,

We are currently using crystal reports server (Version11.5) to schedule and deliver reports. What we would like to do is schedule reports to be generated on the Crystal reports server and then save the results to a file location where they can be viewed by an outside web application. What we are interested in is getting chart data out of these reports and putting the charts on a webpage. I see in the Crystal reports designer we can export to HTML and the chart is converted to a PNG image. This image is what we would like to put on a different website, however in Crystal reports server there is no option to export to HTML. I find this an odd limitation that you can manually export to HTML but you can't automate exporting to HTML through Crystal Reports server. Does anyone know if this truly is a limitation of Crystal Reports server or is there a way to configure it to allow this export option?

Thanks,

---Jeff

[Former Member]

Hi,

you can try to export your report in to HTML format through CMC.

Steps:

1. Export your crystal report in to prodcution repository in particular folder.

2. login in to CMC and select report from particular folder.

3. Right click selected report and select schedule option.

4. In schedule option set timings and what format it should post file,select HTML and give path where it should post your report file.

lets try with this option and let me know your update.

Thanks

Vivek.K

[Former Member]

Hello Vivek,

Thank you for your reply but unfortunately your solution will not work. The problem I am having is the in the CMC and in infoview there is no option to select HTML. I can select Crystal report, excel, PDF, text, and all the other export types but it doesnu2019t have HTML as an option. This appears to be a limitation of the version of Crystal reports server that we are using, but this seems like an odd limitation to me. The workaround I have come up with so far was to write our own report scheduler in .Net and run the reports from there. Then we can export to HTML without issues.

Regards,

---Jeff

[Former Member]

Hi Jeff

On the Business Objects section of the SAP Community Network > Code and Samples > Sample Reports

Page two of the list that i can see

Link: [;

Has some CRXI server samples. THey are JSP samples and some of them might give you an idea on how to go on opening and modifiying or exporting reports.

I use CR 2008 and the SDK for 2008 (I am not a developer so i'm afraid i cannot give you any coding help) allows developers to extend the number of export options available, so instead of the limited number you see now, you could make the text, csv or html options available. The same options that are available in the CR2008 designer.

Also...

Recently i needed to make XML available as an option in our .net viewer (2008)

I had to use an xslt file to transform the default cr 2008 xml schema

There is some doumentation in the help about this in 2008 (i dont know about cr 11) but most of the knowledge i needed was in xslt

The end result is that i was able to embed my version of the xml export into the report so that it became the default format when the report is exported from .net viewer (and also on our CMC) - and i can pick and choose the elements of the report that i want to export

Again i am not sure if that is available in cr xi but the nice thing about xslt is that you can decide which part of the report to export and it can be in html, text or xml format - all standard xslt stuff

Best regards

Patrick

[Former Member]

Hello Patrick,

Thank you for the suggestion. We do not use apache for our server so the java solution will not solve our issue. I'm guessing this must be a limitation of our version of Crystal Reports server and that this feature has been added in the 2008+ versions to export scheduled reports to HTML..

---Jeff