asked on

Page prompts for user id and password everytime we want to view a report.

Hi,

I'm developing crystal reports from MyEclipse. I have created a web project that also contains crystal reports. When I want to view a report from my browser, I am prompted with a page that states, "The report you requested requires further information.", and below that is "Database Logon", where I am supposed to enter the user id and password to my database. After I enter the user id and database, the report will be displayed successfully. How do I remove this page that keeps asking for the user id and password? I have already specified the user id and password in the connection url. Thanks.

Mike McCracken

How did you specify it in the URL?

What version of Crystal?

mlmcc

killdurst

ASKER

My connection URL is "jdbc:sqlserver://localhost:1433;databasename=DB_MOM_RBS;user=sa;password=12qwaszx". Attached is a screen shot of the connection parameters.

The crystal report version is "Crystal Reports for Eclipse 1.0.4.v1094".
connectionParameters.jpg

Mike McCracken

That is how you connect to the database. How do you connect to the report. You have to pass the userid and password to the report.

mlmcc

killdurst

ASKER

Hmm... Sorry, I'm not exactly sure how I connected to the report. I have a report called "Report1.rpt", and then I have a JSP called "Report1-viewer.jsp". MyEclipse generated this automatically for me. This is the page I try to access on my browser. The content of this page is below. Hope this helps.

<%@ taglib uri="/crystal-tags-reportviewer.tld" prefix="crviewer" %>
<crviewer:viewer reportSourceType="reportingComponent" viewerName="Report1-viewer" reportSourceVar="Report1" isOwnPage="true">
<crviewer:report reportName="Report1.rpt" />
</crviewer:viewer>

Open in new window

ASKER CERTIFIED SOLUTION

killdurst

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer