Crystal Report

Printable View

Show 50 post(s) from this thread on one page

February 12th, 2003, 03:25 AM
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:

EmployeeName--------AppraiserName
A--------------------------C
B--------------------------E
C--------------------------A
E--------------------------A

Thanks!
February 12th, 2003, 06:16 AM
S T V Samy

Crystal Report help

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
February 12th, 2003, 06:18 AM
K.Babu

Explain with more details about your requirement

Quote:

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:

EmployeeName--------AppraiserName
A--------------------------C
B--------------------------E
C--------------------------A
E--------------------------A

Thanks!
February 12th, 2003, 12:53 PM
shuzz

LogOnServer Method

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....
February 12th, 2003, 03:29 PM
vbjohn

YES!!!!!!!! Thanks so very much for your help and for your time.

John-
February 12th, 2003, 09:33 PM
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!

Quote:

Originally posted by K.Babu
Explain with more details about your requirement
February 12th, 2003, 10:26 PM
K.Babu

Re: LogOnServer Method

Try using with this dll file "pdsora7.dll"

Quote:

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....
February 12th, 2003, 10:49 PM
K.Babu

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.

Quote:

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
February 13th, 2003, 10:06 PM
K.Babu

Create a view (query) in database, use the view directly in crstal report.

Quote:

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!
February 14th, 2003, 12:03 AM
hemak

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
K.Babu

Re: Image in Crystal Reports

1. Which version of cr you had?

2. About your Environment: Local / Remote?

Quote:

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
February 14th, 2003, 06:34 AM
hemak

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
vbjohn

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
tcjay

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?:confused:
February 16th, 2003, 06:46 AM
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.
February 17th, 2003, 04:25 AM
K.Babu

Hi,

Use "LogonInfo" to change the SQL Database whenever at VB run time.

Quote:

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.
February 17th, 2003, 04:31 AM
K.Babu

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.

Quote:

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-
February 17th, 2003, 06:02 AM
K.Babu

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.

Quote:

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
February 17th, 2003, 08:53 PM
clarayeung

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
atul_tak

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
February 18th, 2003, 06:04 AM
K.Babu

Re: I WANT TO RECORD COLUMNWISE

Create new crystal report, select the report type custom mail label.

Quote:

Originally posted by atul_tak
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
February 19th, 2003, 06:29 AM
Winni

changing the print document name

Hi,

to use a crystal reports print with a special fax printer driver, i have to assign different names to the print jobs, as they appear later in the printer queue. Crystal reports always names the print job like this: "Seagate Crystal Reports - reportname.rpt". Is there a way to change this. Im using the crpe32m.lib and vc++.

Thanks,

Winni
February 23rd, 2003, 10:55 PM
parri

CR7 Paginated Text Export oprion at W2k

Dear K. Babu

I'm using CR7 with vb6. I export the reports at win95,98 and me, I did not found any problem. Currently trying to use at W2k and xp, found the text fields are truncated.

I'v tried to enlarge the text field size, it resolve but the paper size (fanfold 3) available is not sufficient to fit the report

I hope you can guide me on this issue.

Thank You.:cool:
February 24th, 2003, 04:12 PM
Hadi Rezaie

Crystal Report and Record number !!!

Hello,
I've designed my report by Crystal Report 8.5
And right now i'm using Crystal Report ActiveX in my project.
I'm looking for a way to show the report of a special record number, directly.
For example, i wanna show the report of Record number 4.
NEED FOR SPEED ;)

Is there any way ?

Regards,
February 25th, 2003, 12:53 AM
K.Babu

Re: CR7 Paginated Text Export oprion at W2k

Change the font, and then try again.

Quote:

Originally posted by parri
Dear K. Babu

I'm using CR7 with vb6. I export the reports at win95,98 and me, I did not found any problem. Currently trying to use at W2k and xp, found the text fields are truncated.

I'v tried to enlarge the text field size, it resolve but the paper size (fanfold 3) available is not sufficient to fit the report

I hope you can guide me on this issue.

Thank You.:cool:
February 25th, 2003, 01:06 AM
K.Babu

Re: Crystal Report and Record number !!!

Hi,

At menu bar click insert menu, select the "Insert Record Field" to view the record numbers.

if you want to customize the record number put the "Insert Record Field" in formula field, use (if <condition> then ... else ...) conditions, refer other command used for formula fields like this.

Quote:

Originally posted by Hadi Rezaie
Hello,
I've designed my report by Crystal Report 8.5
And right now i'm using Crystal Report ActiveX in my project.
I'm looking for a way to show the report of a special record number, directly.
For example, i wanna show the report of Record number 4.
NEED FOR SPEED ;)

Is there any way ?

Regards,
February 25th, 2003, 10:36 AM
vbjohn

K.Babu,

I was just curious if there is a way that I could have a VB Data Environment and then use it for the Crystal Reports? I do not have Crystal Designer for my Visual Basic application or I just can not find it on my VB. I looked into the Components and no Crystal Designer.

John-
February 25th, 2003, 03:09 PM
Hadi Rezaie

Hello dear K.Babu and thanks for reply.
But i wanna get the report directly in the program, not in Crystal Report IDE.
As i told u i'm using CR 8.5 activex.
What's ur idea ?

Regards,
February 25th, 2003, 10:25 PM
K.Babu

Hi,

Make sure your crystal report version had RDC feature.

Quote:

Originally posted by vbjohn
K.Babu,

I was just curious if there is a way that I could have a VB Data Environment and then use it for the Crystal Reports? I do not have Crystal Designer for my Visual Basic application or I just can not find it on my VB. I looked into the Components and no Crystal Designer.

John-
February 25th, 2003, 10:31 PM
K.Babu

Hi,

Yes you can change the record number using with RDC component events, pass value through formula fields.

Quote:

Originally posted by Hadi Rezaie
Hello dear K.Babu and thanks for reply.
But i wanna get the report directly in the program, not in Crystal Report IDE.
As i told u i'm using CR 8.5 activex.
What's ur idea ?

Regards,
February 26th, 2003, 09:04 AM
BoBi

Hi Babu

I have a little Problem whit Crystal and the SupportTeam from Crystaldecsision :rolleyes: :mad:
I have many Problems whit Images.
I want print a dynamic Image whit a path in my database.
I CAN'T save BLOB-Files and run no other programm, while printing. OLE Object dosn't work, "Hyperlinks" only exist virtuel and not on the paper.
I want only use a dynamic Image from a path. All image have the same size and resolution.

THX4HELP

BoBi :D

PS: Versions Crystal 8.0, 8.5, 9.0 :p
February 26th, 2003, 09:29 AM
vbjohn

It does not look like I have the RDC feature. I have Crystal Reports 8.5. Where would I look to find out if I do have it?

John-
February 26th, 2003, 01:33 PM
paulina_lui

Help in sorting out the mess

Hey,

Right now I am using different csv files and feed them to the crystal report tempelates that i have made,one for each csv file.
print each of the tempelates to pdf.
then combine the reports to get me the final report .
all this is done manually

I want to automate this so that I dont have to print each of the reports to pdf.
do that for all the csv file reports
then combine them to get a final report.

as all this takes a lot of time.

Basically what i want to do is if possible read from all the csv files in one tempelate and make my tempelate such that the generic info like the information about the test etc whose data is there in the csv files is included as well.

If you can help it would be great.
I can use VC++ for this.

Take Care
February 26th, 2003, 05:19 PM
Hadi Rezaie

hmm, RDC ?
Crystal Report Designer Component.
Can u explain more about this component ?
I wasn't familier with this one.
Anyway, i can use Formula in Crystal Report ActiveX.
February 26th, 2003, 07:45 PM
StateGuy

Crystal 9 and VB

I'm looking for a direct answer to a question. I've found lots of good suggestions, but none seem to address my specific need.

I have VB 6 front-ending a SQL Server backend. I have some stored procedures that I used to create CR 9 reports. So I've got my front-end, and I've got my reports; now how do I call them? I'm essentially a one man shop, so I don't have a lot of brain power to pull from.

The reports have approximately three sub-reports each, which if I read right can be a problem. The CR components I have are (according to the Components screen in VB):
- CR Analysis Common Controls 2.0,
- CR File Dialog Library 2.0,
- CR Report Viewer Control,
- CR Report Viewer Control 9,
- CR Repository Explorer Type Library and
- CR Expert OLE Control module.

I know this is basic stuff to most of you. But like I said, I'm a one-man band.

Thanks in advance...

Randy
February 27th, 2003, 08:25 AM
uralways

HI! this is Guru here
i want to convert currency into words for printing varification.
i tried towords function but no use

i wan to convert 422306.50 in to words, it print it as
four hundred twenty two thousand three hundred six and fifty

i want in some other format.
four lakh twenty two thousand three hundred six and fifty
Guru
February 27th, 2003, 10:12 AM
nazimocp

How to access ms access password protected database

How to access password protected database
Thanx for ur answer but it did't solve the prob i am using crystal report 8.0 and ther is no property or method of logoninfo

crReport.LogonInfo(0) i counld not found this property in crystal report 8.0 but there is a method crReport.database.tables(0).setLogonInfo "Servername,uid,pass") but i am using database file driver not oledb or dsn i am using direct database file.

Please help me to solve this prob
thanx in advance
Nazim
February 27th, 2003, 11:55 AM
MikeB

Hello K.Babu!

I need help with this report. It seems it should be simple, but .....

What I have is 2 tables related by a ProjectID. The project being a building and the database is used to track the development of the building by floors. I need for the report to calculate the total square feet of the bulding, and total square feet in material produced.

The first table is the project details which is broken up by floors (levels).

Code:

ProjectID | Level | TotalSqFt 10001 1 1000 10001 2 1000

The second table is the production details which is broken up by production ID's

Code:

ProductionID | ProjectID | ComponentID | Area 1 10001 401 80 2 10001 402 80 3 10001 402 80

The result of the report should be the following

Code:

Job# | Project Name | Total Sq. Ft. | Total Produced | Remaining 10001 Some Name 2000 240 1760

The problem is that I do not know how to total the values from the 2 tables. I tried grouping but it does not seem to work because there are a different number of records in each table.

Any idea?

Mike B
March 1st, 2003, 11:14 AM
pmok

Using CR with VS.net

I am relatively new to crystal report. I am using CR 9 with VS.net. I have made a simple CR report on a aspx Webform using CrystalReportViewer and bind the datasource to a mdb through the viewer's properties without much coding. I can view the report on web browser with no problem, however, the data is static. How can I make the data to be real-time? The web server is IIS on Window 2000 server box. The VS.net is on a development machine. I search a lot of places and find nothing about this. I have installed CR 9 advance on the server box. Is there a good book that you can recommended to learn CR.Net?
March 2nd, 2003, 02:01 AM
japslam

Crystal Report with ASP

I found some problems when I create report (crystal report) on ASP.

Every time I press print icon, it always print another one blank page.

for example: I have 1 page result of report, the printer always return 2 pages for me, one is report detail, another one is blank page

does anybody found this problem, how to solve

i'm very serious about this problem.

thanks in advance.
March 4th, 2003, 07:56 PM
Limix

Accessing database Field by it's name?

Hello!
I've got a situation here, where I would like to access to a database field by providing it's name. For example, I've got a table containing the 'ItemCode' and quantity columns/fields named after it's branchcode, e.g. '0000'. So the table might looks like this
--------------------------------------------------------
ItemCode 0000 1123 2251 ..........
--------------------------------------------------------
01-12345 5 2 12 ...........
01-32321 1 9 11

Additionally, I have a parameter field called 'CounterCode'. The report should then display all the item codes together with the quantity of the counter code entered by user.
Is it possible to do so? If yes, then how?

Thank you.

Limix
March 4th, 2003, 10:05 PM
thienloclt

change SQL Server in VB runtime

Hi K.Babu,

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.

Server: thienloc
Database: payroll
User: sa
Password:

I am beginner for learning report.
Could you give me Connectivity Technology? Detail as possible.

Please give me detail for use LogonInfo?

What pdsoledb.dll? pdssql.dll?

Thnx in advance.
March 5th, 2003, 09:48 PM
nesdex

Flat File Export

Hi,
I am generating a report (using crystal report 8.5) automatically at a preset timing. The report is fine. All i wanted to do is i want this report to be exported to a flat file (CSV format) automatically. Can this be done? Please help me out.
Thanks.
Siddha
March 10th, 2003, 12:44 AM
yaoying2003

Search in Crystal report 9

Hi, I am currently using CR9 and I hit some problems, just wondering is there anyone out there can help to answer these query?

I created a parameter wif the param name ='myName'
I use the search expert to attempt a search on the following sql
'select * from biodata where name like '%myName%'
I find that I couldn't find any related condition from the drop down condition ...can anybody help to advise on this??

Thanks

Adeline
March 12th, 2003, 06:05 AM
gokakian

Help needed urgently

Dear Mr Babu,

I want to know urgently whether Crystal report has all the below listed
functionalities..

Query Capability
Dedicated Module to create Structured Query
Ad-hoc Query
Multidimensional Analysis
Web Enabled Query Capability
Interface with MS Access and MS Excel
Read from these files Capability
Complete Integration of Excel
Storage in other Formats
PDF
BI Metadata
Metadata support
Network And Internet Access
Web Support
Web Module
Central Repository
Zero Administration client
Graphs
Capability to Produce Complex Graphs
Security
LDAP Support
User Management
Report Level Security
Security Modules
Integration
External API Support
OGL interface
Data entry
Maintain user personal database
Scheduling and Distribution
Service
User Specific Capabities - Summary
For Executive Users
Multi Dimensional Analysis
User Interface
Summarizing, Ranking, filtering Etc.
For Reports Users
Quick Report Viewing
Viewing in Other formats
Parameterized Reporting
For Power Users
Developing Reports
Report Distribution
Zero Administration Client
Provision for entry
Provision for data entry
----------------------------
you can even mail me at [email protected]
March 12th, 2003, 07:35 AM
K.Babu

Re: Help needed urgently

Hi,

Crystal Report is a tool for generate reports effectively, It don't have integrated database, you should have to use external database.

Quote:

Originally posted by gokakian
Dear Mr Babu,

I want to know urgently whether Crystal report has all the below listed
functionalities..

Query Capability
Dedicated Module to create Structured Query
Ad-hoc Query
Multidimensional Analysis
Web Enabled Query Capability
Interface with MS Access and MS Excel
Read from these files Capability
Complete Integration of Excel
Storage in other Formats
PDF
BI Metadata
Metadata support
Network And Internet Access
Web Support
Web Module
Central Repository
Zero Administration client
Graphs
Capability to Produce Complex Graphs
Security
LDAP Support
User Management
Report Level Security
Security Modules
Integration
External API Support
OGL interface
Data entry
Maintain user personal database
Scheduling and Distribution
Service
User Specific Capabities - Summary
For Executive Users
Multi Dimensional Analysis
User Interface
Summarizing, Ranking, filtering Etc.
For Reports Users
Quick Report Viewing
Viewing in Other formats
Parameterized Reporting
For Power Users
Developing Reports
Report Distribution
Zero Administration Client
Provision for entry
Provision for data entry
----------------------------
you can even mail me at [email protected]
March 12th, 2003, 11:57 PM
manish_kk

Crystal Report

;) Thank you for your response sir,
My qustion is " I am getting error 'Physical data base not found' when i am running my report where crystal report is not installed.
Now i have found solution.

When i have included "P2smon.dll" to program directory & system32 on client through setup i got solution i am using MS Access, VB.
March 14th, 2003, 08:13 AM
Azdjekel

Shared variable returns 0

Hi,
I'm using Crystal Report 8.5 and i want to shared some variable from sub report to use them in another sub report or main report. The shared variable in my first sub report return correctly but when my other sub report with shared variable is called in the shared variable from the first sub report now return 0. The report is correct when i look to it in Crystal Report. This problem only happen when i preview the report with my application in Visual C++. How can i fix that ?? Please help me !
March 14th, 2003, 01:36 PM
vkuzmich

Hello Babu,

Need your help to solve my problem.
I have created tens of programs in VB 6.0 with reports created in Crystal 8.0 using RDC. They are already distributed to multiple sites. Initially I didn't pay attention that exporting doesn't work. Now many clients complaining that they can't export to rpt, exel, and other files. Seagate has a patch for this, but it doesn't resolve this problem. I am looking for a less paintfull way to resolve this problem. I have already Crystal 9.0, but it will require to recompile everything and to reinstall on all computers. This is nightmare.

Babu, do you have any idea how to restore exporting with less trouble and pain? Maybe I can replace some DLLs or something like this?
My executables are on the server, so just to recompile isn't big trouble with the same set of DLLs, the trouble is to reinstall on all machines.

I will really appreatiate you for any good idea.

Thank you.
Victor
March 17th, 2003, 05:15 AM
Levis

SQL query in CR9

Hi Babu,

I built a CR9 report that obtain from mssql via odbc. Supposedly, the default database should be determined by the odbc. However, I found that the database name is embedded into the sql query. So the report won't work even i change the database setting in odbc unless i update all tables location in
the report. How could i avoid that? I can't update the query as in 8.5 as the update mechanism is different now.

Thx.
Lee Man Kei

Show 50 post(s) from this thread on one page

All times are GMT -5. The time now is 06:30 AM.