-
February 12th, 2003, 09:33 PM
#256
Hi K.Babu,
Please help me!
* I have 2 tables following: EmployeeTb & DeparmentTb
- EmployeeTb contains fields: EmployeeID, EmployeeName, DeparmentID
- DepartmentTb contains fields: DeparmentID, DeparmentName, LeaderID
* Relations:
EmployeeTb.DepartmentID <--------> DepartmentTb.DepartmentID
DepartmentTb.LeaderID <--------> EmployeeTb.EmployeeID
* Note: DepartmentTb.LeaderID links to EmployeeTb.EmployeeID to describe Deparment Leader name.
* Data:
- EmployeeTb: (6 employees)
EmployeeID-------EmployeeName--------DepartmentID
1--------------------Employee1--------------1
2--------------------Employee2--------------2
3--------------------Employee3--------------2
4--------------------Employee4--------------1
5--------------------Employee5--------------1
6--------------------Employee6--------------1
- DepartmentTb: (2 department)
DepartmentID-------DepartmentName--------LeaderID
1- ---------------------Department1--------------3
2-----------------------Department2--------------5
* I have SQL statement:
SELECT e.EmployeeName, (SELECT e2.EmployeeName FROM EmployeeTb AS e2 WHERE e2.EmployeeID = e.LeaderID) AS LeaderName
FROM EmployeeTb e INNER JOIN DepartmentTb d ON e.DepartmentID = d.DepartmentID
Question:
I want to show following form:
EmployeeName---------------------LeaderName
Employee1--------------------------Employee5
Employee2--------------------------Employee3
Employee3--------------------------Employee3
Employee4--------------------------Employee5
Employee5--------------------------Employee5
Employee6--------------------------Employee5
How to I design in crystal report?
Thanks a lot!
Originally posted by K.Babu
Explain with more details about your requirement
-
February 12th, 2003, 10:26 PM
#257
Re: LogOnServer Method
Try using with this dll file "pdsora7.dll"
Originally posted by shuzz
Hi K.Babu,
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???
thanks a lot....
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.
Visit my company web site (Qmax Test Equipments Private Limited)
Yours friendly,
K.Babu
-
February 12th, 2003, 10:49 PM
#258
Re: Crystal Report help
2. if you are face error at all times using with stored procedure, don't use complicated or long lines procedure, try with simple queries, found out the problem is occurs in this case.
3. Make sure the security setting are correctly stored, compare both production and test
1. we will discuss later on for the first issue.
Originally posted by S T V Samy
Dear K Babu,
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.
CrystalReport1.Connect = CrystalReport1.LogOnServer("pdsora7.dll", "connectstring", "", "username", "password")
for you information, I am usually using the production connect information, while I develop the report.
It would be great help, if you tell me the solution for the above issues.
Thanks in advance.
Regards,
TVS
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.
Visit my company web site (Qmax Test Equipments Private Limited)
Yours friendly,
K.Babu
-
February 13th, 2003, 10:06 PM
#259
Create a view (query) in database, use the view directly in crstal report.
Originally posted by thienloclt
Hi K.Babu,
Please help me!
* I have 2 tables following: EmployeeTb & DeparmentTb
- EmployeeTb contains fields: EmployeeID, EmployeeName, DeparmentID
- DepartmentTb contains fields: DeparmentID, DeparmentName, LeaderID
* Relations:
EmployeeTb.DepartmentID <--------> DepartmentTb.DepartmentID
DepartmentTb.LeaderID <--------> EmployeeTb.EmployeeID
* Note: DepartmentTb.LeaderID links to EmployeeTb.EmployeeID to describe Deparment Leader name.
* Data:
- EmployeeTb: (6 employees)
EmployeeID-------EmployeeName--------DepartmentID
1--------------------Employee1--------------1
2--------------------Employee2--------------2
3--------------------Employee3--------------2
4--------------------Employee4--------------1
5--------------------Employee5--------------1
6--------------------Employee6--------------1
- DepartmentTb: (2 department)
DepartmentID-------DepartmentName--------LeaderID
1- ---------------------Department1--------------3
2-----------------------Department2--------------5
* I have SQL statement:
SELECT e.EmployeeName, (SELECT e2.EmployeeName FROM EmployeeTb AS e2 WHERE e2.EmployeeID = e.LeaderID) AS LeaderName
FROM EmployeeTb e INNER JOIN DepartmentTb d ON e.DepartmentID = d.DepartmentID
Question:
I want to show following form:
EmployeeName---------------------LeaderName
Employee1--------------------------Employee5
Employee2--------------------------Employee3
Employee3--------------------------Employee3
Employee4--------------------------Employee5
Employee5--------------------------Employee5
Employee6--------------------------Employee5
How to I design in crystal report?
Thanks a lot!
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.
Visit my company web site (Qmax Test Equipments Private Limited)
Yours friendly,
K.Babu
-
February 14th, 2003, 12:03 AM
#260
Image in Crystal Reports
Hi,
I have image path in my access database with each record.Is there a way through which I can display all these images(by referring to their path from the database) on the crystal reports along with other fields?
Thanks & Regards,
Hema
-
February 14th, 2003, 02:09 AM
#261
Re: Image in Crystal Reports
1. Which version of cr you had?
2. About your Environment: Local / Remote?
Originally posted by hemak
Hi,
I have image path in my access database with each record.Is there a way through which I can display all these images(by referring to their path from the database) on the crystal reports along with other fields?
Thanks & Regards,
Hema
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.
Visit my company web site (Qmax Test Equipments Private Limited)
Yours friendly,
K.Babu
-
February 14th, 2003, 06:34 AM
#262
Image in Crystal Reports
I am using Seagate Crystal Reports 8.0 . I am developing a multi user client server application.My OS is Windows 2000
-
February 14th, 2003, 04:26 PM
#263
Add a new field durring run-time.
Is there a way that I could add a field in SQL / Crystal durring run-time?
For Example:
SELECT EmpID, EmpName, EmpLoc, "NW" as EmpDirection From.....
John-
-
February 15th, 2003, 09:11 AM
#264
crystal report
I am receiveing a Betrieve[12] error message stating the the database can not be found. I am creating a cross tabe report and adding a select statement. I am not sure what is causeing this because the report works fine until I try to limit the results of the report.
What could be cuasing this. Could it be a RAM issue?
-
February 16th, 2003, 06:46 AM
#265
Hi,
please answer me as soon as possible.
I have used CR 9 to create report that uses SQL Server data.
Now I want in VB to change so that I get report for some other database server and database. Structure and table names are identical.
I neet solution that will work for SQL Server and that will be work for all my reports, so that I don't need to know what tables are used in report. Also I need to say that my report uses more than 20 tables.
How ?!! I have read about changing connection property but it doesn't work. What to insert * HERE *:
Dim crxApplication As New CRAXDRT.Application
Dim Report As New CRAXDRT.Report
Dim strSel As String
Set Report = crxApplication.OpenReport("HZZO.rpt")
* HERE *
Report.DiscardSavedData
strSel = "{Stavke_raèuna_poliklinike.RacunBR} = '20030000001' "
Report.RecordSelectionFormula = strSel
cv.ReportSource = Report
cv.ViewReport
Server will be: gradp4
Database will br: Bis6Test
User: ime
Password: sifra
Connectivity technology: OLE DB
Thnx in advance.
-
February 17th, 2003, 04:25 AM
#266
Hi,
Use "LogonInfo" to change the SQL Database whenever at VB run time.
Originally posted by fetus
Hi,
please answer me as soon as possible.
I have used CR 9 to create report that uses SQL Server data.
Now I want in VB to change so that I get report for some other database server and database. Structure and table names are identical.
I neet solution that will work for SQL Server and that will be work for all my reports, so that I don't need to know what tables are used in report. Also I need to say that my report uses more than 20 tables.
How ?!! I have read about changing connection property but it doesn't work. What to insert * HERE *:
Dim crxApplication As New CRAXDRT.Application
Dim Report As New CRAXDRT.Report
Dim strSel As String
Set Report = crxApplication.OpenReport("HZZO.rpt")
* HERE *
Report.DiscardSavedData
strSel = "{Stavke_raèuna_poliklinike.RacunBR} = '20030000001' "
Report.RecordSelectionFormula = strSel
cv.ReportSource = Report
cv.ViewReport
Server will be: gradp4
Database will br: Bis6Test
User: ime
Password: sifra
Connectivity technology: OLE DB
Thnx in advance.
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.
Visit my company web site (Qmax Test Equipments Private Limited)
Yours friendly,
K.Babu
-
February 17th, 2003, 04:31 AM
#267
Re: Add a new field durring run-time.
Add Formula Fields in cr design mode, change the value for each record value (like eg. "NW") using with (if then ... else ...) commands.
Originally posted by vbjohn
Is there a way that I could add a field in SQL / Crystal durring run-time?
For Example:
SELECT EmpID, EmpName, EmpLoc, "NW" as EmpDirection From.....
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.
Visit my company web site (Qmax Test Equipments Private Limited)
Yours friendly,
K.Babu
-
February 17th, 2003, 06:02 AM
#268
Re: Image in Crystal Reports
You can store pictures in access database itself, data field type called ole object. insert the field in cr design mode directly.
Originally posted by hemak
Hi,
I have image path in my access database with each record.Is there a way through which I can display all these images(by referring to their path from the database) on the crystal reports along with other fields?
Thanks & Regards,
Hema
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.
Visit my company web site (Qmax Test Equipments Private Limited)
Yours friendly,
K.Babu
-
February 17th, 2003, 08:53 PM
#269
hi,
I have a problem in printing directly on web using ASP and crystal report. I can work fine in previewing the report using ActiveX viewer. But I would like to send to report to printer without preview. Can you tell me how to work it out?
Thanks
Clara
-
February 18th, 2003, 04:24 AM
#270
I WANT TO RECORD COLUMNWISE
HELLO SIR ,
i want to print address in two columns
how to do that in crystal report
waiting for u r reply
like
Atul Tak mahen Raja
Subhash Road Komal Colony
Mantri Galli plot no 25
Beed Rohtak
like this
hot acheive it
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|