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
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.
Please avoid sending emails to my personal mail:
write your doubts as thread in Codeguru
Crystal Reports Forum.
This will help all people having similar matters, and will let people who know solutions on the specific topic
share their knowledge.
I want to create a report while is running a VB application. The report is generated by a database at runtime.
I can only show the data in one page and there are data which are not visible because the width of the paper is not enough.
How is possible to show all the data in differents pages?
I have the same problem if I use the crystal activex control or the RDC.
Thank you very much
Natalia
Just one question, is there a way to "refresh" the CR control in order to clear the formulas passed via the ".ReplaceSelectionFormula " and ".Formulas(x)"?
Thank you very much.
Rubber Duckie
Last edited by Rubber Duckie; July 29th, 2003 at 12:07 PM.
cr.Formulas(x) = " myformula = '' " same as replaceselectionformula also.
yours,
K.Babu
Originally posted by Rubber Duckie
Dear K. Babu,
Done !!! ... and working fine.
Just one question, is there a way to "refresh" the CR control in order to clear the formulas passed via the ".ReplaceSelectionFormula " and ".Formulas(x)"?
Thank you very much.
Rubber Duckie
Please avoid sending emails to my personal mail:
write your doubts as thread in Codeguru
Crystal Reports Forum.
This will help all people having similar matters, and will let people who know solutions on the specific topic
share their knowledge.
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...
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)
Hi K.Babu,
I would like to do some batch reporting from my program:
Our users use the program to look at their report thru the web, i was wondering if there is a code to either print it direcly from the web component or add the code in the webpage that create the report to print it as soon as it s loaded.. like this i can load another page and print it.. ect..
Thanks
---------------------------------------------
Sure i got it... what s a form again?
Try to view in ADO activex control from vb, through by odbc connection string.
your friendly,
K.Babu
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?
Please avoid sending emails to my personal mail:
write your doubts as thread in Codeguru
Crystal Reports Forum.
This will help all people having similar matters, and will let people who know solutions on the specific topic
share their knowledge.
Insert the formula fields in cr, add the table fields in that formula fields,
here you can get the pageno and find it out the odd / even pages if the odd number page, view table1.field1 else if even number page view table1.field10, Try this logic.
yours friendly,
K.Babu
Originally posted by nataliagonzalez
I want to create a report while is running a VB application. The report is generated by a database at runtime.
I can only show the data in one page and there are data which are not visible because the width of the paper is not enough.
How is possible to show all the data in differents pages?
I have the same problem if I use the crystal activex control or the RDC.
Thank you very much
Natalia
Please avoid sending emails to my personal mail:
write your doubts as thread in Codeguru
Crystal Reports Forum.
This will help all people having similar matters, and will let people who know solutions on the specific topic
share their knowledge.
I've VB6.0 Enterprise Edition and Crystal Reports 7 installed. I'm currently doing a project in VB and i wish to have Crystal Reports to be my reporting tool.
However, there are several reports to be done in the project around 35 reports. Now if I create all 35 reports it makes my setup program larger.
Hence I would like to have only one reprt file in my project and should be able to pass the relevant source and column positioning from my vb code.
I thought that it may be done using crystal report engine but I dont know where to find it.Can you please help me regarding this, if this is possible
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")
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
How can I concatenate data in a field? Example, I got an output of data that print out on the report as one data per row:
20
25
41
56
and I want it to look like
20, 25, 41, 56
Hi,
I need to email the report using VB how can i do that ?
I created a payslip for each employee using crystal report i want to email each employee its own payslip without need to print it how can i do that using VB ?
* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.