Crystal Server logon error - Urgent.

Hello,

Can anybody please help me or point me in the right direction here.

The ongoing problem is that I have uploaded my reports to the crystal server at work. Everytime I try to view a report, it tells me I have a logon error as follows, "The database logon information for this report is either incomplete or incorrect." I have tried to make a new report with a new sql database connection on the server at work - I still get the same error message.

The ODBC settings are exactly the same as my own server at home. I have the same username and password as well. I can view the reports at home without any problems. But can't view them from the work server.

If I view the reports through a JDBC connection I can view the reports on the server at work. But if I change the connection to ODBC, no report can be viewed. I can view the same reports on my home server regardless of what type of connection it is, ODBC or JDBC.

For the life of me, I just can't seem to figure out the root of the problem? Please help me.

Best regards
SafIf you don't mind my asking, have you figured out your database logon problem?. We occasionally have the same problem, and still don't know why it happens.|||See if you find solution here
www.businessobjects.com

crystal reports (urgent)

Public crxapplication As CRAXDRT.Application
Public crxreport As CRAXDRT.Report

Dim strReportName As String
Dim Fltr
crxapplication = New CRAXDRT.Application

'Pass the reportname to string variable
strReportName = "CITIES"

'Get the Report Location
Dim strReportPath As String = "C:\ReportViwer\ReportViwer" & "\" & strReportName & ".rpt"
'Check file exists
If Not IO.File.Exists(strReportPath) Then
Throw (New Exception("Unable to locate report file:" & vbCrLf & strReportPath))
End If
crxreport = crxapplication.OpenReport(strReportPath)
crxreport.DiscardSavedData()

'Delete all the original parameter values from the parameter picklist.
'If you want to keep the orginal parameter values in the parameter picklist, comment out this loop.
Do Until crxreport.ParameterFields(1).NumberOfDefaultValues = 0
crxreport.ParameterFields(1).DeleteNthDefaultValue(1)
Loop
crxreport.Database.Tables(1).SetDataSource(RS, 3)
' Read the records to force the parameter box to appear before sending data to the viewer
crxreport.ReadRecords()
Fltr = "{CITY_CITIES.COUNTRY_NO}={?COUNTRY_NO}"
' Get the value the user enters in the parameter box then send that text to the formula field (that ' the report is grouped on)
crxreport.RecordSelectionFormula = Fltr
' View the report
AxCrystalActiveXReportViewer1.ViewReport()
End Sub

The error I am getting is An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in axinterop.crystalactivexreportviewerlib10.dll

Additional information: Unspecified error

Can I have your help please.Which line are you getting the error?

crystal reports

Dear Friends,

Please help me urgent.

I have tried to create the code in vb.net 2003 in crystal reports 10. I had my code as follows:-

Con.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
"C:\Program Files\inventory.MDB;" & _
"Persist Security Info=False;" & _
"Jet OLEDB:Database Password = tz_2006"
Con.Open()

Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

RS = New ADODB.Recordset
Dim strReportName As String

CHECK_STRING = "SELECT * FROM CITY_CITIES"
RS.Open(CHECK_STRING, Con, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)

strReportName = "CITIES"
Dim strReportPath As String = "C:\Program Files\REPORTS" & "\" & strReportName & ".rpt"

'Check file exists
If Not IO.File.Exists(strReportPath) Then
Throw (New Exception("Unable to locate report file:" & vbCrLf & strReportPath))
End If

Dim rptDocument As New CrystalDecisions.CrystalReports.Engine.ReportDocument

rptDocument.Load(strReportPath)
rptDocument.SetDataSource(RS)
AxCRViewer1.EnableGroupTree = False
AxCRViewer1.ReportSource = rptDocument
AxCRViewer1.ViewReport()
End Sub

The Error I am getting is the 3rd line from below (i.e. AxCRViewer1.ReportSource = rptDocument) which the Error states that "an unhanded exception of type 'system.invalidcastexception' occured in axinterop.crviewerlib.dll" and "Additional information: No such interface supported"

Thanks.Open the report and Do verify Database

Crystal Report : Cross Tab Formatting(Urgent)

Hi!I am new to cross tab in reports.I am using Seagate Crystal Report 7.Currently developing report with few tables in it. I am having problem grouping it into the fields that i want.I also wish to know how do i add formula in it..as well as writing queries in the access itself.I cant seems to do anything with the column/row on the report.I hope to have some guidelines.Thank You.Hi!I am new to cross tab in reports.I am using Seagate Crystal Report 7.Currently developing report with few tables in it. I am having problem grouping it into the fields that i want.I also wish to know how do i add formula in it..as well as writing queries in the access itself.I cant seems to do anything with the column/row on the report.I hope to have some guidelines.Thank You.

Hi!!!
I'm also new with crystal reports but i have already done a cross tab report using 8.5...anyway, u can use the wizard to guide u in creating ur crosstab...or u can explain further what u want to do so we could help each other in solving ur problem... :)|||I created a cross tab query in Ms Access..hoping to link to Crystal Report 7. But when i tried to arrange the columns n rows..i cant edit anything.eg: There's summarized field to be set in Crystal report 7. I dont want it to count my field..instead displaying just the data. How can i do it?