GuidesCRYSTAL REPORTS ON THE WEB - TUTORIAL 1

CRYSTAL REPORTS ON THE WEB – TUTORIAL 1

ServerWatch Staff
By ServerWatch Staff
Guides

ServerWatch content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More.




Vaijay

PROBLEM When displaying a crystal report using the
web report server the username and password needed to
logon to the database are to be supplied along with the report name.

(ex: )

The problem with this is, the user will be able to see the username and
password in the URL. To avoid showing the username and password in
the URL do the following.

 

SOLUTION

When displaying a crystal report using the web report server the username and password needed to logon to the database are to be supplied along with the report name.

PURPOSE: To display crystal reports on the
web(seagate crystal reports 6.0) using the web report server.
The following will show you how to display the crystal report without
displaying the username and password in the URL.
 
SCENARIO: One .html page — > “Report.html”
The “Report.html” page contains a pull-down menu containing report names
and a “GET REPORT” button. The user selects a report from the pull-down
menu and clicks on the “GET REPORT BUTTON”. The crystal report is then
displayed in the Cystal ActiveX Viewer.
 
PRE-REQUISITES: Create the crsytal reports shown in the
pull down menu in the “Report.html” page and save them in the same directory
that contains the “Report.html” file, on your web server.
 
SYSTEM REQUIREMENTS: Seagate Crystal Reports 6.0/7.0, IIS 4.0 and IE 4.0 or above. The
Crystal reports should be installed on the web server. Be sure to apply all the
patches supplied by Seagate if using the crystal reports 6.0

STEPS TO FOLLOW

STEP   1 Create the “Report.html” file. To do this,
simply copy the following code, paste it into a new file in a text-editor
(ex notepad,editplus etc.) and save the file as “Report.html”

Automation Server Demo>/TITLE> </p> <p> function OpenReport() <br /> { <br /> var RptName = document.DispRep.RptList.options[document.DispRep.RptList.selectedIndex].value; <br /> DispRep.METHOD = “POST”; <br /> DispRep.ACTION = RptName; <br /> <br /> DispRep.submit(); <br /> } </p> <p>

Report1.rpt
Report2.rpt
Report3.rpt
Report4.rpt
Report5.rpt

Here Report1.rpt … Report5.rpt are the crsytal reports that you want
to display on the web. yourusername and yourpassword are
the username and password values you use to log onto your database.
 
 
CAUTION Make sure that the “Report.html” and all the crystal reports
are in the same directory on your web server. Then launch the “Report.html”
page from your browser. Select a report and click on the “Get Report” button.
This will display the report in the ActiveX Viewer.

Get the Free Newsletter!

Subscribe to Daily Tech Insider for top news, trends & analysis

Latest Posts

Related Stories

ServerWatch is an established resource for technology buyers looking to increase or improve their data center infrastructure. ServerWatch’s reviews, comparisons, tutorials, and guides help readers make informed purchase decisions around the hardware, software, security, management, and monitoring tools they use to innovate for employees and customers.

Advertisers

Advertise with TechnologyAdvice on ServerWatch and our other data and technology-focused platforms.

Advertise with Us

Menu

Our Brands

Property of TechnologyAdvice.
© 2024 TechnologyAdvice. All Rights Reserved

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.