I was wondering if there is a way that I could type in some text in VB 6.0 and post that data from a Textbox into a field or label in a Crystal Reports Page/Report Header?
Thanks,
John-
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.
Hi,
1.
Please help me solve bug:
I have code:
If crystal.LogOnServer("PDSODBC.DLL", "MQIS", "PAYROLL", "SA", "") Then
crystal.ReportFileName = App.Path & "\reports\" & "contact.rpt"
crystal.Action = 1
End If
on line "crystal.Action = 1" --> error: "Cannot open SQL Server"
2. What are differences between cr.Connect and cr.LogOnServer?
SELECT e1.FullName, (SELECT e2.FullName FROM EmployeeTb AS e2 WHERE e2.EmployeeId = a1.AppraiserId) AS AppraiserName
FROM EmployeeTb e1 INNER JOIN AppraisalTb a ON e1.EmployeeId = a.EmployeeId
How to I design in crystal report to show following form:
But nothing printed on the report. I think you kind of mis-understood what I was going for...
As you can see on the .gif image. Where it says *testing* I need to have text in a textbox in VB and post that text into a field or label in a Crystal Reports Page/Report Header?
"Connect" is cr property which is log on to SQL Servre, it must required ODBC driver
"LogonServer" is a method it returns connection id, This connection id used for "LogoffServer" method. you can use DSN ODBC Data Source here.
Originally posted by thienloclt
Hi,
1.
Please help me solve bug:
I have code:
If crystal.LogOnServer("PDSODBC.DLL", "MQIS", "PAYROLL", "SA", "") Then
crystal.ReportFileName = App.Path & "\reports\" & "contact.rpt"
crystal.Action = 1
End If
on line "crystal.Action = 1" --> error: "Cannot open SQL Server"
2. What are differences between cr.Connect and cr.LogOnServer?
Thanks!
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.
Create formula fields in crystal report design time
eg. RepTitle (assume your formula field name is RepTitle)
in vb
cr.formulas(0) = "RepTitle = 'Hello world'"
Originally posted by vbjohn
I tried...
Cr.BoundReportHeading = "Report Title Message"
But nothing printed on the report. I think you kind of mis-understood what I was going for...
As you can see on the .gif image. Where it says *testing* I need to have text in a textbox in VB and post that text into a field or label in a Crystal Reports Page/Report Header?
I hope this clears things up more.
John-
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.
SELECT e1.FullName, (SELECT e2.FullName FROM EmployeeTb AS e2 WHERE e2.EmployeeId = a1.AppraiserId) AS AppraiserName
FROM EmployeeTb e1 INNER JOIN AppraisalTb a ON e1.EmployeeId = a.EmployeeId
How to I design in crystal report to show following form:
I am using Crystal report ver 7.0 , VB 6.0 and Oracle 8i database 8.1.5.
I have 3 issues in Crystal Report. Can you help me.
1. One of my report, I am using parameter from branch Id and To branch ID. If I give parameter more than one branch ID i.e 1 to 30 / 14 to 15 like that, the report would complete with in 15 to 20 seconds even 2 years data. but If I give parameter just one branch ID i.e. any one branch ID, it would take minimum 5 minutes for even one month data.
2. If I try to use stored procedure of Oracle, crystal report would crash at design time itself i.e. windows illegal error that I have to say either Yes / No.
3. I have Test and production oracle database. I am using the below command to connect the database in VB program. but if I am giving the test database connect string, it would not connect the database i.e I am getting error.
Originally posted by thienloclt
Hi K.Babu,
Please help me!
I have SQL statement:
SELECT e1.FullName, (SELECT e2.FullName FROM EmployeeTb AS e2 WHERE e2.EmployeeId = a1.AppraiserId) AS AppraiserName
FROM EmployeeTb e1 INNER JOIN AppraisalTb a ON e1.EmployeeId = a.EmployeeId
How to I design in crystal report to show following form:
im trying to connect a crystal repot in Visual basic, with an Oracle DataBase, the LogOnServer Method expects a DLL.
which DLL should i use, and where should the DLL be???
* 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.