hello pooja mohan

First of all, Thank you for the great work you are doing.

I have a requirement to display a report inside a web browser,
This report should be called from a JSP with parameters ,
Then the report is created on the fly from the
data source based on the parameters passed and displayed in the browser.

I am allowed to use Crystal Reports,JSP, Apache Tomcat for the purpose,

Currently I have installed Crystal Enterprise 8, Crystal Developer Edition 8.5,
the OS is windows 2000 professional,

I have gone through every bit of your answers in the forum,
I have only minimum knowledge in Microsoft related products,


1. How to create reports instantly on the request ?

If I am right these reports should already be existing in the IIS before we call them.
2. Where do I put in the apache ?
I tried creating aliases, but this was trying to download the report
rather than opening, I have configured Crystal Configuration Manager according to file
Virtual Directories and Path Mapping

Thank you once again, look forward to your reply

regards
dhinesh

Thank you for appreciating my efforts.

Answer 1. Crystal Reports Add-Ins for Microsoft Excel and Access make creating reports from existing Microsoft data a snap.Also,one can create reports “on the fly” from within one’s application using report creation at runtime APIs or the drag-and-drop interface of the Crystal Embeddable Designer Control.

 Yes,after creating one’s reports,their true or virtual path should be mapped on to the IIS/Apache.

 Answer 2.  I would suggest that you go through posting "Crystal Reports and Apache" Author-Amit Lonkar and "Apache and Crystal Report -Useful Information" Author-Pooja M. J to find an answer to this query.

Pooja M.,
http://home.attbi.com/~pooja.mohan

Thanks for the prompt response
I was able to call crystal reports thru JSP and I got it displayed in the browser,

1. Is there way to make the preview tab invisible
2. Can you provide me with more details such as sites for Crystal Embeddable Designer Control creating to create reports at runtime.

Thanks
regards
dhinesh

Answer 1 : In order to remove the "Preview" tab from the ActiveX Viewer when you are running reports through the URL command line you must run the reports through an HTML page containing the ActiveX Viewer code.

1. Preview the report in the ActiveX Viewer.
2. Right-click on the gray area around the viewer and select "View Source" from the menu.
3. Keeping this file open, save it with an .HTML extension to a virtual directory on the web server.
4. Add the parameter:
<PARAM NAME="DisplayTabs" VALUE=0>
  (the VALUE = 0 disables the "Preview" tab and VALUE = 1 enables it)
to the existing list of parameters in the ActiveX Viewer's source code as seen below:
<PARAM NAME="DisplayTabs" VALUE=0>
<PARAM NAME="EnableDrillDown" VALUE=1>
<PARAM NAME="EnableExportButton" VALUE=1>
<PARAM NAME="DisplayGroupTree" VALUE=1>
<PARAM NAME="EnableGroupTree" VALUE=1>
<PARAM NAME="EnableAnimationControl" VALUE=1>
<PARAM NAME="EnablePrintButton" VALUE=1>
<PARAM NAME="EnableRefreshButton" VALUE=1>
<PARAM NAME="EnableSearchControl" VALUE=1>
<PARAM NAME="EnableZoomControl" VALUE=1>
<PARAM NAME="EnableSearchExpertButton" VALUE=0>
<PARAM NAME="EnableSelectExpertButton" VALUE=0>
5. Now edit the line, "CRViewer.ReportName=" to point to the location of the report:
For example: CRViewer.ReportName = "http://<web_server_name>/reportname.rpt"
6. Call this HTML page through a browser and the report will be displayed in the ActiveX Viewer without the "Preview" tab being displayed.

Answer 2 : Please refer to www.google.com to find more details related to Crystal Embeddable Designer Control.

Pooja M.,
http://home.attbi.com/~pooja.mohan