Re: Error when using more than one CR control in a single form
Hi,
You can use with single cr control for more reports, just change the *.rpt file and the database connection, it's right.
if you face same problem using with the single cr control, Reinstall the cr applicaton and then try again.
Thanks
K.Babu
Quote:
Originally posted by Rubber Duckie
Hi to everyone.
I'm running a VB5 and crystal reports 4.6.1.
I have several CR controls in a form for different reports. When invoking the "cr.action = 1" in more than one cr control in the compilated .exe program I get the next message when closing the form:
XXXX caused a page fault
in module CRYSTL32.OCX memory location 0167:250127fb.
Registers:
EAX=00000000 ... etc.
Is anybody familiar with this error, and which is the solution?
Thanks in advance.
Rubber Duckie.
Left outer join problem in CR9 through ODBC
Hi,
I have a problem with a left outer join in the database expert.
I join two tables with a left outer join and it appears like it is like an inner join.
My database is pervasive2000. I have a connection through ODBC.
I found a document on the "Cr9_left_outer_join.pdf" and I added my driver to a registry key. But left outer join works like a inner join.
How can I solve this problem.
Thanks in advance !!
Crystal Report Print View ----- Not Aligned >>> Help Required Urgently ****
Hi,
I have a typical problem that has to be solved immediately.
I created a report, which is been Grouped, I have subtotal, GrandTotal too. In the View I see the GroupHeader in end of the Page/ Subtotal in the next page. The reason I feel is lack of space, but I would like if the their is no space continue in the Next page. But I would like Groups continously not in separate pages...
Do reply Immd.
Thank You :)
With Regards
Soundar
1 Attachment(s)
Crystal Report 5 and SQL 2000
I am running Windows 2000 Adv Server and SQL 2000 SP3.
Client is Windows 98.
Developing using VB6 and Crystal Report 5.
Problem: Even when I create a new login with DBO rights to the database, connecting at CR via ODBC, I am not able to see any tables other than 2 system tables. (refer to attached jpeg)
Any comments?
Re: Crystal Report 5 and SQL 2000
Hi,
Try to view in ADO activex control from vb, through by odbc connection string.
your friendly,
K.Babu
Quote:
Originally posted by tadaguru
I am running Windows 2000 Adv Server and SQL 2000 SP3.
Client is Windows 98.
Developing using VB6 and Crystal Report 5.
Problem: Even when I create a new login with DBO rights to the database, connecting at CR via ODBC, I am not able to see any tables other than 2 system tables. (refer to attached jpeg)
Any comments?
ASP.NET and Crystal Reports 9.0 Developer version
Hi,
I designed a crystal report with the pull method and display it in the web browser using the
crystal report viewer control. During run time, I am setting the login id
and password. I am able to view the report in the browser. However I am
noticing that each time I view the report in the browser, a connection
with a sleeping status is left open in the database. Eventually I max out
of connections and login failed error is displayed in the browser.
I am using SQL Server 6.5. (does this have anything to do with the problem??)
The following is my code. Please tell me what I am doing wrong. Why are
the database connections left open?
Dim paramFields As ParameterFields
Dim paramField As ParameterField
Dim curValues As ParameterValues
Dim discreteValue As ParameterDiscreteValue
Dim dtReleased As String
dtReleased = Request("dtRel")
CrystalReportViewer1.DisplayGroupTree = False
CrystalReportViewer1.SeparatePages = False
CrystalReportViewer1.DisplayToolbar = False
CrystalReportViewer1.ReportSource = Server.MapPath("Reports\claims.rpt")
CrystalReportViewer1.LogOnInfo.Item(0).ConnectionInfo.ServerName =
"serverName"
CrystalReportViewer1.LogOnInfo.Item(0).ConnectionInfo.UserID = "UID"
CrystalReportViewer1.LogOnInfo.Item(0).ConnectionInfo.Password = "pwd"
CrystalReportViewer1.LogOnInfo.Item(0).ConnectionInfo.DatabaseName =
"dbName"
paramFields = CrystalReportViewer1.ParameterFieldInfo
paramField = paramFields("ReportDate")
curValues = paramField.CurrentValues
discreteValue = New ParameterDiscreteValue
discreteValue.Value = dtReleased
curValues.Add(discreteValue)
CrystalReportViewer1.ParameterFieldInfo = paramFields
paramFields = Nothing
curValues = Nothing
paramField = Nothing
discreteValue = Nothing
CrystalReportViewer1.Dispose()
CrystalReportViewer1 = Nothing
DataBind()
Based on an article that can be found at http://support.crystaldecisions.com/...s/c2010371.asp
I changed my code to the following but still encountered the same problem of running out of database connections.
I posted to the Crystal Report support team and yet to hear back from them. But If someone knows what's going on here, I would appreciate your response very much.
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
InitializeComponent()
crReportDocument = New ClaimsRpt
With crConnectionInfo
.ServerName = "srvName"
.DatabaseName = "dbN"
.UserID = "Uid"
.Password = "pwd"
End With
CrTables = crReportDocument.Database.Tables
For Each CrTable In CrTables
crtableLogoninfo = CrTable.LogOnInfo
crtableLogoninfo.ConnectionInfo = crConnectionInfo
CrTable.ApplyLogOnInfo(crtableLogoninfo)
Next
discreteValue = New ParameterDiscreteValue
discreteValue.Value = "8/5/2003"
crReportDocument.SetParameterValue("ReportDate", discreteValue)
CrystalReportViewer1.ReportSource = crReportDocument
End Sub
I also tried setting every reference to Nothing but still the problem remains
Private Sub Page_Unload(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Unload
crReportDocument.Close()
crReportDocument.Dispose()
crReportDocument = Nothing
crtableLogoninfos.Clear()
crtableLogoninfos = Nothing
crtableLogoninfo = Nothing
crConnectionInfo = Nothing
CrTables = Nothing
CrTable = Nothing
discreteValue = Nothing
CrystalReportViewer1.Dispose()
CrystalReportViewer1 = Nothing
End Sub
Thanks