Solved

Crystal Reports 9 Conecting to sql server DSN asking for username and password

Posted on 2003-11-14
13
634 Views
Last Modified: 2008-02-01
When designing the report I used a DSN name that exactly the same as on the server that runs the report server for my website.  Everytime I run the report it keeps asking for a username and password.  Can I do something in the viewer some code or something to tell it what the username and password are?
0
Comment
Question by:abishome
13 Comments
 
LVL 1

Author Comment

by:abishome
ID: 9752932
here is a copy of my viewer code It is ASP connection to Crystal Reports 9 and a SQL Severr 2000 database

<%@ Language=VBScript %>
<%

'Create the Report Viewer object
'Set HTMLViewer = CreateObject("CrystalReports.CrystalReportViewer")
Set HTMLViewer = Session("ObjFactory").CreateObject("CrystalReports.CrystalReportInteractiveViewer")
Set rptAppSession = Session("ObjFactory").CreateObject("CrystalReports.ReportAppSession")
    rptAppSession.Initialize
    If Err.Number <> 0 Then
        Response.Write "Failed to initialize ReportAppSession."
        Response.Write "Error message: " & Err.Description
        Err.Clear
    End If
Set OpenReport = rptAppSession.CreateService("CrystalClientDoc.ReportClientDocument")
'Supply the viewer with information it needs and set any viewer attributes
With HTMLViewer
    .ReportSource = Session("pathReport")
    .IsOwnPage = True
    .IsEnableDrillDown = True
    .IsDisplayGroupTree = False
End With

'Check that ParamCollection is not null or empty
If Session("ParamCollection").Count > 0 Then
    HTMLViewer.ParameterFields = Session("ParamCollection")
End If

'Display the report in the viewer
HTMLViewer.ProcessHttpRequest Request, Response
%>
0
 
LVL 13

Expert Comment

by:EwaldL
ID: 9753421
the report needs to be logged on at the database unless you are using nt authentication for sql server? Try executing tthe Logon command after instantiating the report object. I am not too familiar with ras asp but this seems to be missing in your extract?

Session("pathReport").DatabaseController.Logon "user", "password"

There are more samples in here, with a lot of info on database logon
http://support.crystaldecisions.com/communityCS/TechnicalPapers/apps_ras.pdf

Also make sure that the server has a System DSN, not a User DSN

0
 
LVL 1

Expert Comment

by:vairavamuthu
ID: 9761735
try it..iam a new to this..but trying to provide based on the thing i infered from u r ques

using
<appSettings>
        <add key="ConnectionString" value="Data Source=dsnname;Initial Catalog=;User ID=id;password=password;"/>
 </appSettings>


and call it when req..
0
 
LVL 13

Expert Comment

by:EwaldL
ID: 9761938
what does the Session("pathReport") contain? Just the report path as a String, ie "C:\report.rpt" ?
0
 
LVL 1

Author Comment

by:abishome
ID: 9770819
There are two files that get called when linking to the report.  This is the first

<%
'===================================================================================
' Creation Date: July 2003
' Author: ES
' Purpose: This sample ASP application demonstrates how to use the Report Application
'          Server (RAS) Viewer SDK to pass values to discrete report parameters.
'===================================================================================

'Specify the report to be opened
'reportname = "SimpleParameters.rpt"
reportname = request.QueryString("ReportName")
'Use this object to create other RAS objects
Set Session("ObjFactory") = CreateObject("CrystalReports.ObjectFactory.2")

'This "While/Wend" loop is used to determine the physical path (eg: C:\) to the
'Crystal Report file by translating the URL virtual path (eg: http://Domain/Dir)  
Path = Request.ServerVariables("PATH_TRANSLATED")                    
While (Right(Path, 1) <> "\" And Len(Path) <> 0)                      
      iLen = Len(Path) - 1                                                  
      Path = Left(Path, iLen)                                              
Wend      

'Store the Path and report into a session variable as it will be used by the viewer code
Session("pathReport") = Path & reportname

'The ServerControl object provides us with an interface to a variety of RAS Services
Set oServerControl = Session("ObjFactory").CreateObject("CrystalReports.CrystalReportServerControl")

'We need to open the report for modification (in this case passing parameters)
oServerControl.reportSource = Session("pathReport")
oServerControl.processHttpRequest Request, Response, Null

'Retrieve all the parameters from the report
Set ParamCollection = oServerControl.ParameterFields

'This subroutine expects two values, the parameter name and its value
Sub PassParameter(strParamName, ParamValue)

   'determine the index value of the parameter in the collection
   paramIndex = ParamCollection.Find(strParamName, 0)
   
   'add a current value to the parameter
   ParamCollection.Item(paramIndex).CurrentValues.Add ParamValue

End Sub      

'Pass parameters to the report using the PassParameter subroutine
'This will also work for multi-value discreet parameters
'PassParameter "StringParam", CStr("I am a string")
'PassParameter "StringParam", CStr("I am also a string")
'PassParameter "NumberParam", CInt("123")
'PassParameter "CurrencyParam", CDbl("321.123")
'PassParameter "BooleanParam", CBool("True")
'PassParameter "DateParam", CDate("2001/Jan/02")
'PassParameter "TimeParam", CDate("3:45:00 PM")
'PassParameter "DateTimeParam", CDate("2001/Jan/02 3:45:00 PM")
'PassParameter "res_id", 725
For each item in Request.QueryString
'response.write item & "********" &  Request.QueryString(item) & "<br>"
if item <> "ReportName" then
    response.write item & ": " & CStr(Request.QueryString(item)) & "<br>"
    PassParameter item, CStr(Request.QueryString(item))
end if
next

'Store the modified collection of parameters in session as it is used by the viewer code
Set Session("ParamCollection") = ParamCollection

'Redirect to viewer code
Response.Redirect "CrystalReportViewer.asp"

%>
As you can see this redirects to the Viewer the code for that is

<%@ Language=VBScript %>
<%

'Create the Report Viewer object
'Set HTMLViewer = CreateObject("CrystalReports.CrystalReportViewer")
Set HTMLViewer = Session("ObjFactory").CreateObject("CrystalReports.CrystalReportInteractiveViewer")
Set rptAppSession = Session("ObjFactory").CreateObject("CrystalReports.ReportAppSession")
    rptAppSession.Initialize
    If Err.Number <> 0 Then
        Response.Write "Failed to initialize ReportAppSession."
        Response.Write "Error message: " & Err.Description
        Err.Clear
    End If                                                        
Set OpenReport = rptAppSession.CreateService("CrystalClientDoc.ReportClientDocument")

'Supply the viewer with information it needs and set any viewer attributes
With HTMLViewer
    .ReportSource = Session("pathReport")
    .IsOwnPage = True
    .IsEnableDrillDown = True
    .IsDisplayGroupTree = False
End With

'Check that ParamCollection is not null or empty
If Session("ParamCollection").Count > 0 Then
    HTMLViewer.ParameterFields = Session("ParamCollection")
End If

'Display the report in the viewer
HTMLViewer.ProcessHttpRequest Request, Response

%>
0
 
LVL 1

Author Comment

by:abishome
ID: 9770829
vairavamuthu,

I don't understand what you are refering to
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Expert Comment

by:chengzhou
ID: 9926597
why not set user/password in Crystal Enterprise 9's management Console!
0
 
LVL 1

Author Comment

by:abishome
ID: 10274476
here is the pop up I am getting.  The only software I have running on the server is RAS  My users are getting anoyed and I don't know what to do

The report you requested requires further information.
--------------------------------------------------------------------------------
Database Logon
 
Server Description dbName
Database Type ODBC (RDO)
User Id  
Password  
 
 


 

0
 
LVL 13

Expert Comment

by:EwaldL
ID: 10274578
this should solve it, i take you are using the eportfolio lite
http://support.businessobjects.com/library/kbase/articles/c2013600.asp
0
 
LVL 1

Author Comment

by:abishome
ID: 10276601
I am not using eportfolio light.  I am just using the viewers from an asp page.  The entire code for my asp pages is includeded above.  According to your documentation link it says to change a specific line in my code.  My code does not contain that line.  
0
 
LVL 1

Author Comment

by:abishome
ID: 11174479
I got the latest sample files from Crystal and everything was resolved using these updated files.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 11195942
Closed, 500 points refunded.

modulo
Community Support Moderator
Experts Exchange
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now