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.
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
K.Babu
February 12th, 2003, 06:18 AM
Explain with more details about your requirement
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???
thanks a lot....
vbjohn
February 12th, 2003, 03:29 PM
YES!!!!!!!! Thanks so very much for your help and for your time.
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
K.Babu
February 12th, 2003, 10:26 PM
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....
K.Babu
February 12th, 2003, 10:49 PM
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.
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!
hemak
February 14th, 2003, 12:03 AM
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
K.Babu
February 14th, 2003, 02:09 AM
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
hemak
February 14th, 2003, 06:34 AM
I am using Seagate Crystal Reports 8.0 . I am developing a multi user client server application.My OS is Windows 2000
vbjohn
February 14th, 2003, 04:26 PM
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-
tcjay
February 15th, 2003, 09:11 AM
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:
fetus
February 16th, 2003, 06:46 AM
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")
Server will be: gradp4
Database will br: Bis6Test
User: ime
Password: sifra
Connectivity technology: OLE DB
Thnx in advance.
K.Babu
February 17th, 2003, 04:25 AM
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")
Server will be: gradp4
Database will br: Bis6Test
User: ime
Password: sifra
Connectivity technology: OLE DB
Thnx in advance.
K.Babu
February 17th, 2003, 04:31 AM
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-
K.Babu
February 17th, 2003, 06:02 AM
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
clarayeung
February 17th, 2003, 08:53 PM
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:(
atul_tak
February 18th, 2003, 04:24 AM
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
K.Babu
February 18th, 2003, 06:04 AM
Create new crystal report, select the report type custom mail label.
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
Winni
February 19th, 2003, 06:29 AM
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
parri
February 23rd, 2003, 10:55 PM
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:
Hadi Rezaie
February 24th, 2003, 04:12 PM
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,
K.Babu
February 25th, 2003, 12:53 AM
Change the font, and then try again.
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:
K.Babu
February 25th, 2003, 01:06 AM
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.
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,
vbjohn
February 25th, 2003, 10:36 AM
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-
Hadi Rezaie
February 25th, 2003, 03:09 PM
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,
K.Babu
February 25th, 2003, 10:25 PM
Hi,
Make sure your crystal report version had RDC feature.
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-
K.Babu
February 25th, 2003, 10:31 PM
Hi,
Yes you can change the record number using with RDC component events, pass value through formula fields.
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,
BoBi
February 26th, 2003, 09:04 AM
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
vbjohn
February 26th, 2003, 09:29 AM
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-
paulina_lui
February 26th, 2003, 01:33 PM
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
Hadi Rezaie
February 26th, 2003, 05:19 PM
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.
StateGuy
February 26th, 2003, 07:45 PM
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
uralways
February 27th, 2003, 08:25 AM
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
nazimocp
February 27th, 2003, 10:12 AM
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
MikeB
February 27th, 2003, 11:55 AM
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).
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
pmok
March 1st, 2003, 11:14 AM
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?
japslam
March 2nd, 2003, 02:01 AM
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.
Limix
March 4th, 2003, 07:56 PM
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
thienloclt
March 4th, 2003, 10:05 PM
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.
nesdex
March 5th, 2003, 09:48 PM
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
yaoying2003
March 10th, 2003, 12:44 AM
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
gokakian
March 12th, 2003, 06:05 AM
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 mzmulla@kanbay.com
K.Babu
March 12th, 2003, 07:35 AM
Hi,
Crystal Report is a tool for generate reports effectively, It don't have integrated database, you should have to use external database.
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 mzmulla@kanbay.com
manish_kk
March 12th, 2003, 11:57 PM
;) 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.
Azdjekel
March 14th, 2003, 08:13 AM
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 !
vkuzmich
March 14th, 2003, 01:36 PM
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
Levis
March 17th, 2003, 05:15 AM
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
vkuzmich
March 17th, 2003, 08:37 AM
To Levis.
Sorry, I am not Babu, but will try to help you. In Cr8 you were able to correct this in such way: go to Database menu, Set Location; in Location section in Table text box delete database name and other stuff, leave only table name. It worked in CR8.
Victor
Levis
March 17th, 2003, 10:45 PM
Hi,
Thx for ur help. I used to delete the database name in cr8 or 8.5.
But this is no longer working in cr9 as the set location become a one to one mapping between reporting tables and current connection tables. And the user cant directly touch the generated sql anymore...
:(
ipmurali
March 18th, 2003, 01:00 AM
hi babu,
i created a crystal report based on Access Database through ADO connection. Can i use the same report for other backend databases like SQL server/Oracle without changing the report ?
Or is there anyway to change the connecting string property through VB code?
please help me
thanks
nwy
March 19th, 2003, 02:34 AM
Hi,
I want to know how I can creat a Cystal Report with vb code ,
not using Cystal Reprot designer. would you like to help me?
K.Babu
March 19th, 2003, 11:24 PM
Use RDC for develop crystal report from vb, available in cr 8.5
Originally posted by nwy
Hi,
I want to know how I can creat a Cystal Report with vb code ,
not using Cystal Reprot designer. would you like to help me?
pooran
March 27th, 2003, 08:38 AM
Hi Babu,
I have a report that displays a set of data. Here, one requirement is, when one field is say 'High', I have to display one red image. If it is 'Medium' I have to display 'Green' and so on. I am using Crystal reports 9.
Thanks in advance
Pooran
Shanmugam
March 28th, 2003, 09:06 PM
1.
I am trying to export to .pdf format from exe file.
it fails without error message.
got few solution from crystaldecisions.net but no help
but it runs well with vb
how to solve?.
thanks in advance.
2. i am printing a report in line printer (very old).
but when i print string field, if the value is empty "" the alignment all goes out, how to solve.
same applies to the fields whose rows missing for the child table.
for ex, if master table contains 100, child 25 only. the alignment for 25 & 75 is different like
emp name emp no dept name dept no
john 1101 IT 10
Ken 1201
durgada
March 31st, 2003, 05:14 AM
Iam using below code
rpttoview="E:\Manju\ERP\Reports\DCReport.Rpt"
' Only create the Crystal Application Object on first time through
If Not IsObject ( session ("oApp")) Then
Set session ("oApp") = Server.CreateObject("Crystal.CRPE.Application")
End If
Set oApp = Server.CreateObject("Crystal.CRPE.Application")
' Turn off all Error Message dialogs
Set oGlobalOptions = oApp.Options
oGlobalOptions.MorePrintEngineErrorMessages = 0
' Open the report
If IsObject(session("oRpt")) then
Set session("oRpt") = nothing
End if
Set session("oRpt") = session("oApp").OpenReport(rpttoview,1)
Set oRpt = oApp.OpenReport(rpttoview,1)
' Turn off sepecific report error messages
Set oRptOptions = oRpt.Options
oRptOptions.MorePrintEngineErrorMessages = 0
Iam getting the following error.
CPEAUT Error Ocured on Server.
20614: Starting background processing failed.
vikramsingh
April 1st, 2003, 04:55 AM
Hi Babu,
I need your help on my web application that using crystal report as reporting system module.
The problem is the report gradualy stuck when generating report. Then we restart the system again, but the performance wont budge. I check the system performance (we use win2k as the server) on SQLServer.GeneralStatistic.User Connection and it count more then 500.000 connection.
TIA.
durgada
April 1st, 2003, 05:25 AM
hi Babu,
Iam using below code get my report in browser but Iam getting the error.
Error No is :20614
Starting background processing failed.
one more method Iam using that is directly giving the link the report <a href=report1.rpt?user0=sa&password>Show Report</a>
If I give this user can view database server Used Id & Password,
how to avoid this.
If IsObject(session("oRpt")) then
Set session("oRpt") = nothing
End if
Set session("oRpt") = session("oApp").OpenReport(path & reportname, 1)
set session("oRptOptions") = Session("oRpt").Options
session("oRptOptions").MorePrintEngineErrorMessages = 0
session("oRpt").DiscardSavedData
set Database = session("oRpt").Database
set Tables = Database.Tables
set Table1 = Tables.Item(1)
Table1.SetPrivateData 3, session("oRs")
On Error Resume Next
session("oRpt").ReadRecords
If Err.Number <> 0 Then
Response.Write err.Description & "<br>"
' Response.Write "An Error has occured on the server in attempting to access the data source"
Else
If IsObject(session("oPageEngine")) Then
set session("oPageEngine") = nothing
End If
set session("oPageEngine") = session("oRpt").PageEngine
End If
I am using crystal reports 9 in a program. The following line of code genates the error " Creation feature not enabled".
Set m_Report = m_Proj.NewReport
How can I workout this problem.
Thanks
jheoyz
April 1st, 2003, 10:04 PM
hello, i hope you can help me with this one.
how can i display the name of the report in the title bar?
thanks...
Randy VL
April 2nd, 2003, 11:41 AM
Hi Babu
I'm using VB 6 & Crystal Report 4.6. In my VB form (frmMain) I have Text and DBGrids that has all the information from MS Access. I would like a report that have the information in frmMain. Can this be done and what books do you recommed?
Thanks
MikeB
April 2nd, 2003, 03:33 PM
I am having difficulty in viewing reports using the OCX in my application. The user can choose to view/print 1 of 4 different reports. The problem is after viewing one, then choosing another, the window does not refresh with the new report.
if(m_cPreview.GetCheck())
m_cReport.SetDestination(0); // To window
else
m_cReport.SetDestination(1); // To printer
m_cReport.PrintReport();
m_cReport.Reset();
}
If I called this function twice via Button Click, change the selection formula, the report doesn't change!
Mike B
takashi6352
April 3rd, 2003, 02:41 AM
I'm using the VB code below to generate a report but the crystal report keep on complaining
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]An ORDER BY clause is invalid in views, derivied tables, and subqueries unless TOP is also specified"
Dim sSQL As String
sSQL = "Select SalesForceDetail.SFID,SalesForceDetail.SFName,SalesForceDetail.CustID,customer.Name
From SalesForceDetail, customer Where SalesForceDetail.CustID = customer.CustID
And SalesForceDetail.CustId In (select CustID from SalesForceDetail
Group by CustID having count(CustID) > 1 ) Order by SalesForceDetail.CustID"
With CrystalReport1
.Connect = gblDSN
.SQLQuery = sSQL
.ReportFileName = App.Path & "\Report\SalesForceCustomerDetail.rpt"
.Action = 1
End With
Please help
reemjacob
April 3rd, 2003, 09:21 AM
Hello everybody
I am trying to pass a recordset to Crystal report using a TTX file. The recordset is created by executing Stored procedure. I created the TTX file from the recordset, using the Active Driver Function CreateFieldDefFile(). but when i run the code the report does not get populated with the records. I am SQL Server2000 as the database. What am I doing wrong here? Please advise.
Thanks in advance
Dim CrAppl As New CRPEAuto.Application
Dim CrRep As CRPEAuto.Report
Dim CrDB As CRPEAuto.Database
Dim CrTables As CRPEAuto.DatabaseTables
Dim CrTable As CRPEAuto.DatabaseTable
Private Sub UserForm_Activate()
Dim oRSRate As New ADODB.Recordset
Dim oCmd As New ADODB.Command
Dim oParam As New ADODB.Parameter
Dim oConn As New ADODB.Connection
Dim sStr As String
'open the ADO recordset
oRSRate.Open oCmd, , adOpenDynamic, adLockBatchOptimistic
'open the report
Set CrRep = CrAppl.OpenReport("D:\Report1.rpt")
'set the database object to the reports database
Set CrDB = CrRep.Database
'set the databaseTables object
Set CrTables = CrDB.Tables
'set the databaseTable object to the first table in the report
Set CrTable = CrTables.Item(1)
'sets our ADO recordset as the data for the first table
CrTable.SetPrivateData 3, oRSRate
'Preview the report with the ADO recordset as the data
CrRep.Preview
oRSRate.Close
End Sub
Norby mahoney
April 3rd, 2003, 04:13 PM
Using CR 7.0.0.0, CRW32 7.0.1.192.
Trying to run a report that is based on ADO (driver pdsmon.dll).
If there are no records in the query set that is used by the report, I receive the error 'Unable to access first record!' followed by 'SQL Server error'. I searched and saw that some others had received this error, but I think their situations were different.
Anyway, this report is based on a query, not a stored proc. It is run against either SQL Server or MSAccess. Any ideas on how to get around this error; i.e. just display the report with no records.
dharmesh_niru
April 4th, 2003, 08:08 AM
Hi Babu,
Thanks in advance,
I am a new comer for CRYSTAL REPORTS.
I want to create a report that doesn't contain any recordset object during design time. But During Runtime it should generate
columns according to Fields in different Tables.
Also i want to know, how can I size report designer i.e. Landscapre mode during desing time.
Thanks once again
Dharmesh
aRaj
April 4th, 2003, 09:49 AM
Hello,
I am using Crystal reports 8/8.5. I would like to distribute my reports to users who don't have CR on their PC. I have been able to do this to the internal users, by placing them in the web folder, and with the page server running as a service. I am not sure how i can distribute to users outside our company! I would appreciate if you could provide me some insight on the same.
Thanks.
Raj
jacob_mw2
April 17th, 2003, 03:29 PM
Hi all,
Im having trouble printing from my VB app using crystal reports.
The app runs on systems having 2000,NT and 98.....I have used the generic printer driver in Crystal Reports.
The problem is the formatting is fine on prints from 2000 systems,but the same report gets screwed up if a print is fired from NT or 98 clients....
Jacob
dupontp
April 18th, 2003, 11:14 AM
Hello !
I know just a little bit about Crystal Report. I am a VB developper and I am lokking for a report engine. I know that Crystal Report is a good one but I have certain specification I want from a report engine.
I want a report engine having a lot of kind of pagination. For example, 2 pages by sheet... I will explain me...
If you want to print a book with 2 pages by sheet and recto-back, so on one sheet, I will have 4 pages (2 on recto, 2 on back). The problem is if I have document of 8 pages, I will need 2 sheet. I will show you with a picture (see below).
So, my question is: Do you know if Crystal Report can build that kind of report (with this pagination). If no, do you know another report engine that can do this.
Thank you very much ! :)
Patrick.
Tony Choo
April 21st, 2003, 10:12 PM
Hi all,
Does anyone know how to enable the CE8.0 to sent out email notification on the success or failure of a particular report that has been scheduled?
Our aim is to write a CSP that pass the parameters to the CE8.0 to enable this.
We hope to do this without having to upgrade to CE8.5. Has anybody done this? Please share with us. Many thanks.
best regards
Tony
Tony Choo
April 21st, 2003, 10:15 PM
Hi everybody,
Another question on CE8.0.... Is there a place where sample code can be found for writing a CSP to export scheduled rpts to diff file formats??
Can I assume that the following is relevant...
cr.Destination
cr.PrintFileName
cr.PrintFileType
If so where can I find the syntax for using them? Many thanks.
best regards
Tony
Tony Choo
April 22nd, 2003, 05:56 AM
Hi,
Does anyone know how to trigger the CE8.0 to ran repeatably for a particular weekday? e.g. rpt to be generated on every monday...
we interested to know the methods avaiable to a CSP for the above...
Thanks in advance.
regards
Tony.
RIC_V
April 22nd, 2003, 10:05 AM
Hi!,
I´m trying to insert a Graph (vertical bars) on my report without success. There are three AccessDB fields that need to be shown in the graph (as a bar each).
I created a summary for these fields but apparently I can only display one bar (field) per graph.
If someone knows if it´s possible to include more than one field in a graph please let me know.
Thanks in advance.
:confused:
jojys
April 24th, 2003, 02:37 AM
This is not a reply but a new thread directly to Shri K Babu.
Hi,
I am using VB6 and Crystal report for my application. While designing the report using report expert, I have used ADO with Jet 3.51 and for data I have an sql statement linking three tables from my Access database.
After designing the report, I am not able to modify the sql statement, if i want to add any more fields from the tables. When i try to modify the sql statement using verify command, i get an error message. As a result, if I want to modify my report adding some additional fields, I have to redo the entire design.
I am using CR8.
Can you help me where I am going wrong ???
thanx
andytim
April 24th, 2003, 10:00 AM
Does anyone known if it support wince?
Andytim
--------------------------------------------------------
http://www.********.net
XD++ MFC Library provides Microsoft Foundation Class (MFC)/Visual C++ developers with a complete library of MFC extension classes which implement a drag and drop (e.g. VC,VB Form Editor) graphical interface.
francis3
April 28th, 2003, 02:59 AM
Hi,
encountered a big problem here.
I have create a rpt with a crystalreportviewer on a aspx page. It runs well on my local machine. But when pushing it to my live server, (my database is on another machine), the following error occurred
Make sure your DSN are correctly refered,
and your server permission are correct.
Originally posted by francis3
Hi,
encountered a big problem here.
I have create a rpt with a crystalreportviewer on a aspx page. It runs well on my local machine. But when pushing it to my live server, (my database is on another machine), the following error occurred
Don't change the sql select fields in cr, instead of this you can create query at access database whatever you need select fields names.
Then use the query from your access database to cr as a table.
Originally posted by jojys
This is not a reply but a new thread directly to Shri K Babu.
Hi,
I am using VB6 and Crystal report for my application. While designing the report using report expert, I have used ADO with Jet 3.51 and for data I have an sql statement linking three tables from my Access database.
After designing the report, I am not able to modify the sql statement, if i want to add any more fields from the tables. When i try to modify the sql statement using verify command, i get an error message. As a result, if I want to modify my report adding some additional fields, I have to redo the entire design.
I am using CR8.
Can you help me where I am going wrong ???
thanx
Tony Choo
April 29th, 2003, 12:57 AM
Hi Babu,
I was wondering if you could advice how one would go about implementing a recursive scheduling of report on CE8.0 using CSP?
Basically our recursive report uses the same parameter and every time it runs recursively. We want the parameter to be relevant to the time run.
For example, report is scheduled to run on 29 apr 03 (Tue), and then again everyweek on the same day, granted it does run every tuesday, but the date of data to print is stuck at 29 apr 03.
How do we tell CE8.0 that when it runs a recusive report, it should get current date, week month or even year's data, so that every time it runs, relevant data is secured?
Thanks & best regards
Tony
K.Babu
April 29th, 2003, 01:03 AM
Refer the Graph Wizard at Graph Type Report, this will help you to follow the steps easly.
Originally posted by RIC_V
Hi!,
I´m trying to insert a Graph (vertical bars) on my report without success. There are three AccessDB fields that need to be shown in the graph (as a bar each).
I created a summary for these fields but apparently I can only display one bar (field) per graph.
If someone knows if it´s possible to include more than one field in a graph please let me know.
Thanks in advance.
:confused:
CA_IB_MR
April 29th, 2003, 10:38 AM
I have been trying to use crystal reports from a MFC dialog box. But I donot find any documentation on how to do it.(in Visual C++ .NET).
Any help would be appreciated,
thanks,
CA_IB_MR
Randy VL
April 30th, 2003, 07:45 AM
Hi K. Babu
I am using VB6 and CR9. Not that Familiar with CR9.
I have a frmMain with DBGrid and text etc. that the user has entered, with that I would like to transfer the info to CR9 and was wandering how I can do this
Thanks
:)
saldig
April 30th, 2003, 09:38 AM
Hi,
I 've a problem in printing report (file.rpt) from Crystal report 9 environment. I have Microsoft Windows 2000 installed in Italian Language, and Crystal report 9 installed in English Language.
When I print a report, the result is that numbers are correctly printed but characters are non correctly printed (strange combinations of symbols are printed).
If I use both Windows 2000 and Crystal Report 9 in English version, the printing works fine.
---------------------------------------------------------------------------
Another question.
What is the run time (dll) that have to be used with Crystal Report 9??
The applicatione that have to use the run time is a C++ application.
Thanks in Advance
Kain
April 30th, 2003, 04:53 PM
Hi there, in my program you r supposed to be able to print a bunch of reports in one time.. All the report displays well but it will only print the last one even if it gives printer dialog after first one..
So i guess i need to wait a event saying that the display - Printing is done.. b4 trying to do the next..
My report are done in Crystal Report exported in PDF..
Any idea?
Thanks
kishore_mala
May 1st, 2003, 03:55 AM
Dear Babu,
Can you please answer my post in http://www.codeguru.com/forum/showthread.php?s=&threadid=243434
I don't post it again here because it may be considered as spam.
Thanks in advance
Kishore
shethashish_a
May 1st, 2003, 08:09 AM
hi mr.Babu,
I just came to know about the forum on crystal report.
I have a problem with crystal report which I have posted a thread just now on the following link.
www.codeguru.com/forum/showthread.php?s=&threadid=243456 (http://www.codeguru.com/forum/showthread.php?s=&threadid=243456)
Can u answer me on this immediately. I am stuck on that and i need solution immediately.
my email id is
ashish@sankhyainfotech.com
thanks in advance.
Ashish
shethashish_a
May 2nd, 2003, 02:21 AM
Hi all,
In my previous thread i have mentioned that I tried to connect to oracle database through crystal report wizard but it is not working. Now i have tried through code and still it is not working.
here is the code that i have written in crystal report's initialize event
Private Sub Report_Initialize()
Dim con As ADODB.Connection
Set con = New ADODB.Connection
con.ConnectionString = ConString
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
con.Open
rs.Open "Select * from emp", con, 3, 2, 1
Database.SetDataSource rs
End Sub
Please help me immediately. it is urgent. I am stuck on that.
thanks,
ashish
yeosc
May 5th, 2003, 03:38 AM
Hi Babu,
I've created a report with a line chart. When I call the report from vb6 on a windows XP, it's running fine; but when the same report is called on Windows 98, the chart just dissapeared. Is there anything to do with any missing file? However, I didn't get any error message. The other info in the report was displayed properly. I'm using CR8.5.
Thanks
yeosc
RIC_V
May 5th, 2003, 01:28 PM
Hi People,
How can I set the database location at runtime from my vb app? When i was using an old version of Crystal report i was allowed to set "same as report".
Thanks in advance.
Ricardo
OrangKampung
May 5th, 2003, 09:32 PM
OK..the problem is like that.I connect the crystal report to MYSQL using ODBC.
Everything work perfect when i am just using 1 or 2 tables in a report. I use left outer join to connect each table.
But the problem occur when i am using the data from 3 or more tables in a report.It always appear a message " Fail to open a row set" What wrong actually?
Thanks for help.
OrangKampung
May 5th, 2003, 09:34 PM
I am using ODBC to connect crystal report to MYSQL database. I am wondering why i cant select a data from a tables where a field in a table is equal to "" (That mean it was nothing in the field,but not null,just nothing).
I right click on 1 field at the table..then click select expert
-> click equal to "" , but when run the crystal report,nothing select? how can i fix this problem?
thanks for help.
lsavidge
May 6th, 2003, 01:42 PM
Hi,
I'm having real problems trying to do something that ought to be very straightforward. I have a stored procedure that returns a recordset. This displays a nice tabulated report without problems. This stored procedure takes 3 parameters, 2 dates and an ID to identify a survey I'm reporting on. Also there is a sub report which is related to the main report but is designed to sumarise some columns with a view to creating a graph.
The sub report is a stored procedure which takes the same parameters but also another parameter which is the question number of a particular question in the given survey. This produces a small recordset with which I want to produce a pie chart from.
I can do all this seperately and I have also figured out how to link the parameters so that the subreport takes the parameters from the main report. However, for the sub report, I do not want the question ID parameter to be entered by the user, I want to hard code it (for reasons I won't go into right now). I have to run this sub report for 24 different questions so I need to be able to have a subreport generated from single stored procedure.
To summarise, if I were to run this in query analyser I would run:
where the first 3 params in each case are the same.
This will then give crystal the recordsets with which it can create the charts from. I don't want to prompt the user to enter in the question numbers in the subreport, I just want to hardcode them into crystal.
Any help is most welcome.... I'm running Crystal 9 and Report Application Server. All I require is the end user to choose a report in the browser, type in the dates and state which survey to run and for crystal to show the report and the graphs. I have the SQL in the form I need, but not the knowledge of crystal to pull it off.
Cheers,
Lee
Fumiseki
May 7th, 2003, 04:26 AM
helo ,
nice to hear that's a crystal report specialist would resolve my question .
ok , i'm facing a problem of displaying my daily sales value into graph, my clients which running his operation hours from afternoon 3 pm to morning 3 am .... so ... it's raise a serious problem to me of displaying the sales value , you know .. by default crystal report uses default time as daily (00:00:00 to 00:00:00) ... so all my value getting wrong !! ... it should be 03:00:00 to 03:00:00 correct ? so i had been mad about this .. hope you can give me a hand .. i'm grade of hearing reply from you . thanks you!
NasirAbbas
May 8th, 2003, 02:39 AM
Dear K. Babu.. how r u...
I face a problem in projects of VB when calling Reports through Crystal Report ActiveX Control that is the report some times does not show i mean if application is run and some reports are frequently used all of a sudden they fails to show and again to show i have to close the application and then run it again.. pls help me...
RIC_V
May 8th, 2003, 06:28 AM
Dear NasirAbbas,
I was facing the same problem with my VB6 and CR9 app.
LogoffServer worked fine for me. Everytime I close my viewer window I Logoffserver.
Hi ,
I am using CR7.0 version and i want to place a jpeg picture as background image in detail section when all records are displayed simultaneuosly (one by one just like in Grid).When i am printing a single record it is coming correct what i need,but when i want to print all(nearly 10 ) records it is not getting what i need......
My printer is colour printer and it is HP Deskjet color printer and all my Cry Reps are printing in Black and White and when i am printing the same reports in Data Report it is printing Colour.....
I have a created database in MS Access XP and having some tables in that database.From CR7.0 i can't able to open the database and it is giving error like unrecongnised database..
Please help me because i need this Urgent !!!!!
Thanks !!!!!!
CookieMonster24
May 11th, 2003, 03:11 PM
I want to create a report that's based on a user's selection, basically a form with checkboxes and comboboxes. The end user will not have to write an sql statement.
to start with, I have a form with check boxes and comboboxes and based on those that are selected i want to be able to grab that record or count the number of records. That's the easy part. I'm stuck on how i go about displaying that information on to the report. How do i go about putting that into a field? Is the field unbound??? I'd do an Add Command but it's not known until runtime what will be selected or what will be needed until runtime.
Also I want to be able to edit a text object without having to actually going to the report design, specifically in the page header. I want to be able to have some code that will do that for me but i'm at a loss here too.
for e.g., suppose the end user wanted to know the total number of orders sold rather than the total number of employees. how would that be displayed? (From access northwind.mdb)
dca
May 12th, 2003, 04:58 PM
Hi,
I have one crystal report that I can not add or move fields on the preview mode. Why?
Pleae help
Thanks
MananThakkar
May 13th, 2003, 08:32 PM
I want to configure the crystal report template file to allow application to dynamically set the link to the bitmap from code.
Is this possible? Do I use PESetFormula(...) for this?
Or do I need to hardcode the path and name of bitmap file in my crystal report template?
Thanks
__Manan__
dilraj
May 14th, 2003, 07:34 AM
I m using VB 6, crystal report 8 and oracle 9.
I m getting problem to using parameter field through VB.
Please give me code of vb for how to pass parameter through VB using parameter fields
clahl
May 14th, 2003, 10:03 AM
hi group,
i'm new to crystal with vs.net and did some reports for a website after reading the wrox book.
now i try to depoly my first winform app with crystal reports in it and it doesn't work. everything's fine on the pc where i developped it, but on any other pc i get an error message that i try to translate from german: querry module error: c:\windows\temp\temp_15....f9.rpt
i did the following: first create an xml dataset that was used to create the report from. next i fill another dataset with runtime filtered data from my database. this works, i can see it in the datagrid. than i set the report datasource to the dataset with the filtered data and execute it.
than i built a setup project, which reports no errors and deployed the solution. the form works fine, only when i hit the buton to connect the report to the dataset i get the above mentioned error.
any help?
thanx anyway
chris
Amandeep
May 17th, 2003, 10:36 AM
Crystal Report 8.5
I am using a sub report. I have inserted the subreport into my primary report via the report designer.When i invoke the primary report from my VB6 application i get an error "File Not Found". I guess this is because the VB appilication cannot find the path for the sub report. How can i specify the path of the sub report in the VB Application?
mojick
May 23rd, 2003, 02:10 PM
Dear Mr. Babu
I am working on a test project. Were I use access 2000 and VB and for report crystal report. In access I have 25 tables with collect data about 25 different dimensions of an auto part. I created a report using crystal report and put 25 fields [field name 'dimension'] from each database into report. For eg my report looks like.
dimen1.value, dimen2.value, dimen3.value and so on till 25 dimension.
Now after creating a report I entered first record with 25 dimension i.e. one value per table. After that I entered 2nd record in which I put only 4 dimension. Now when I preview the report my problem is 1 record show all the 25 dimen. perfectly but 2nd record which has only 4 dimension shows first 4 dimension correctly but from the fifth dimension it shows records of first record.
I am really confused . Why the 2nd row in report shows the data in 5th dimension of first record. 2nd row in report is supposed to be blank as I have entered only 4 dimensions. If you can guide then please help
m_varsha
May 27th, 2003, 05:22 PM
Hi All,
I am a new learner and user of Crystal reports. I have one query. I have made a line chart. I have made it thru chart expert, in that the names of the legends were automatically created by the software and I have no ways to change it.
eg. My table structure is
Week Date
Plan Number
Actual Number
Forecast Number
On my X-Axis the vales of weeks are shown and on Y Axis -- forecast, Actual and Plan values are shown. SO when I create a grapf, the legend names are automatically given by the software as.... sum of plan......
sum of forecast
sum of Actual
I want to change it to Just Plan, Actual, Forecast. How to go about it?
Please help me as I have to submit my work to client in few days.
Thanx & Regards
Varsha
ptung
May 30th, 2003, 05:01 AM
Hi,
I have a very simple problem: I have a selection parameter that is defined as string. During selection I want to define a search query using wildcards on a defined DB field. So I have defined the selection parameter as follows:
{db.column_name} like {?PARAMETER}
The compiler returns an error on the PARAMETER saying that it is not a string.
If I try to convert the parameter using functions like toText the error changes into somethingh like "number, date, boolean required".
Is there any document that can help developing with Crystal Report?
Thanks in advance.
kjcarrots
June 2nd, 2003, 02:53 AM
Hi K. Babu! I hope you can help me with my dilemma.
Can i put page columns in a crystal report??? If it is possible, how can i do it??
Attached is the format i want to do with my report
Thanks in advance!
Joy :)
aniruddhabadola
June 2nd, 2003, 02:55 AM
How do i insert variable number of images retrieved from database in to a crystal report at runtime.
slah
June 2nd, 2003, 05:28 AM
HI
I am having problem with crytal report. I am a newbie. i have made a report with the wizard and added the report form viewer control and set its source property to my report. but when i start my applicaton it asks for server, database, user and paasword what to do. i don't want this dialog to come. anybody plz could fix this problem.
THNX IN ADVANCE
anand chawla
June 2nd, 2003, 09:01 AM
Hi,
Well my problem is that i cant print grouped data horizontally..for example...
hoping this is an easy one - I am really new and I have a report that I need to have the user choose multiple elements or 'all' elements for the sort - I have the multiple element working but I am not sure how to get the 'al'' working...
example:
database holds element COLOR - values: blue, red, yellow, green, orange..
I want the user be able to pick 1 value, multiple values, OR I would like them to be able to pick 'ALL' and I would like ALL by default (so it picks ALL colors)...
I hope this makes sense :)
Thanks !
Jennifer
kevinwzh
June 6th, 2003, 05:52 AM
hi ,
i use my .net2002 IDE to develop a report veiwer tools, i use this in other win2000 machine with .net frame work,but when i open .rpt file use this tool,it disappear "missing registration .dll",i already include some module in this application (regwiz.msm),why?
thanks.
Satishatakare
June 6th, 2003, 08:53 AM
How to Improve Crystal Report performance ?
For simple report it took 1-2 minutes to show report.
RevDebug
June 10th, 2003, 02:04 AM
I have upgrade to crystal reports 8.5 to take advantage of the Active Data Driver/Reporting. Problem, the documentation states that a System DNS connection must be created. I have been successful in creating and connection to a report. However I would like to create a DNS-Less Connection. Any clues on how to connect to the Crystal Report Viewer using a DNS-Less Connection?:D
Satishatakare
June 10th, 2003, 04:51 AM
Hi,
I have started to develop reports using the Crystal Reports.
Case #1
We can design report into Crystal report and save it as .Rpt file.
Case #2
We can design report as like data report into the Visual Basic Interface and save it as DSR Files.
Problem #1
I Need to change Database connection for report at run-time.
Is there need of creation of DSN.
(I can't use DSN, it is out of our architecture )
Using Case#2, I have no need to change database connection of report, because report is connected to Data Environment connection, I can change only Data Env. Connection to other Database.
So, Please tell me hot to change database of crystal report at runtime for .rpt ?
Question #1
If I used reports like Case#1.
Are they included into the my Application .Exe or I can keep them separate as like .RPT
Question #2
Speed : Crystal Report takes too much time to load the report
Please guide me this.
suyog
June 10th, 2003, 10:07 AM
Hi every one ,
I am trying to pass parameter to crystal report 8.0 from VB6.0 form .
But it is giving problem .
I have written following code
it is okay up to this level but when i tryed to give action to crystalreport1 as
CrystalReport1.action = 1
then it is giving problem .
can any boody tell me why i am getting problem .
Thanks in advance .
Suyog
Satishatakare
June 11th, 2003, 03:06 AM
Hi,
Following is code for parameter.
Ex:
' Customer ID parameter. This is a number range parameter.
CrxReport.ParameterFields.GetItemByName("Customer ID").AddCurrentRange 1, 100, 3
' Last Year's Sales parameter. This is a currency parameter.
CrxReport.ParameterFields.GetItemByName("Last Year's Sales").AddCurrentValue 20000
' Region parameter. This is a string parameter with multiple values.
CrxReport.ParameterFields.GetItemByName("Region").AddCurrentValue "CA"
CrxReport.ParameterFields.GetItemByName("Region").AddCurrentValue "NJ"
' Today's date parameter. This is a date parameter.
CrxReport.ParameterFields.GetItemByName("Today's Date").AddCurrentValue Date
Note : For more detail download this sample from www.crystaldecisions.com/Support
:rolleyes:
(Every body is Master..., No body is Master...)
Tim_England
June 11th, 2003, 07:19 AM
Hello,
I'm new to this group, so sorry if I'm a little slow off the blocks.
I'm creating a crystal report object in an Access module, that is
using a report already created using the standard version of Crystal
(version 9).
Everything is ok, except when I password protect the database, and
subsequently update the tables in the database connection dialog in
the Crystal Report, I can no longer create the object in the Access
module....
perhaps I need to be using something like .logonserver or such
like.....but I suspect this uses DLLs that aren't available with the
standard version of Crystal Reports.
any info much appreciated
Tim
TreeOfWoe
June 11th, 2003, 03:57 PM
Greetings Babu,
I am using a dataset that consists of a SQL Server Stored procedure with a parameter, I would like to have a bottun on a windows form in my C# app that the user would press to pass in a param, do you know how I can pass in a param to my crystal report? EVerytime I add a param, and run my app, this dialog box pops up and asks for the parameter, i don't want this to happen because I want my text field to take care of passing hte param in? Could you provide any advice?
Thanks!!!
The TreeofWoe
erisinani
June 12th, 2003, 03:08 AM
Hi,
I am having a problem with a report for a table in a Access DB. I am filling this table with 3 - 5 records from a VB program and after that I display the report (crystal report 7.0). The problem is that not all the records are displayed. I have to wait about 5 sec and after that to make a refresh. After that everything is OK. Some times there is nothing displayed, some times there are displayed only some records. It is very rare that all the records displays since the first display.
PLS, anyone helps me.
All the best,
Eri.
etatis
June 12th, 2003, 05:18 AM
Hi,
I' m working with VB6, CR 9 and SQL Server.
I connect to my Database by setting the DSN dynamically. So far so good, BUT.....
i want to connect to another database that has a different name, but the same structure with the main one.
My question here is: is there any way to have my database name dynamic in the report file so I don't have to go through and explicitly change the source names in the report?
THANX
rdonline1
June 12th, 2003, 07:49 AM
hi,
I have used graphs in my report. I have used Crystal Report 6.0. The graphs are working fine in report wirter.
But when i'm executing the reports through my vc++ program it's not showing the graphs in the report. All other things are coming properly except the graphs.
What could be the possible reason. Am i need to include any lib file or anything else. Please help!!!
rdonline1
seminole
June 18th, 2003, 02:13 PM
Jennifer,
Create a parameter called color, check the multiple value box, then click the set default values box. Add the values you want to choose from i.e. Red, blue etc.... Then type in "All" and add that. Make sure "All" is at the top of the list.
Then go into "Select expert" and create the formula below
if {?Color}= "All" then {Your . Field} like "*" else {Your . Field}={?Color}
Replace "Your . Field" with the appropriate database field
You will still have to click add for "All" when selecting, but it will be up by default.
Hope that helps,
Mike
Originally posted by Jenreb1
Hello Babu,
hoping this is an easy one - I am really new and I have a report that I need to have the user choose multiple elements or 'all' elements for the sort - I have the multiple element working but I am not sure how to get the 'al'' working...
example:
database holds element COLOR - values: blue, red, yellow, green, orange..
I want the user be able to pick 1 value, multiple values, OR I would like them to be able to pick 'ALL' and I would like ALL by default (so it picks ALL colors)...
I hope this makes sense :)
Thanks !
Jennifer
alexei_1973
June 18th, 2003, 05:35 PM
Hi A. Kabu
I've using Cristal Report for some time. and I have a problem.
I need to resize the preview window. This window is made a child window of CRPEPlusView wish is derived from CView folowing the Document/View parathigm.
Then when I resize the application frameWindow the prevw window of Crystal Report don'st do it. there's any way to get that window's handle to rezie it or other way of doing it....
void CRPEPlusView::OnReportPreview()
{
...
GetClientRect(&Rect);
if (!app->printJob->OutputToWindow("Crystal Reports Class Demo",0,0,Rect.Width(),Rect.Height(),WS_CHILD ,this))
AfxMessageBox(app->printJob->GetErrorText());
else if (!app->printJob->Start())
AfxMessageBox(app->printJob->GetErrorText());
}
My Derived class from CWinApp has this two objects.
CRPEngine printEngine;
CRPEJob *printJob;
Hetan
June 24th, 2003, 02:27 AM
I have a report that works fine, it access a free table database using a DSN. When one of the tables is corrupt, the report crashes and the ASP web page kills IIS. I want to set a time out to the web page to stop it and let IIS to continue with it service. What can i do?
solomon_13000
June 25th, 2003, 05:49 AM
I have created a VB app, that will display crystal report.
The problem now is I have set my MS Access database a password. Therefore I cant view my crystal report now.
can u help me with this problem?
Your could download my program at:
www.bigcaterers.com.my/db/cybercaffe.zip
180fatman
July 7th, 2003, 12:24 PM
Originally posted by K.Babu
hi,
Stores all pictures in database files using with OLE Object type.
Add the picture field in your crystal report.
yours,
K.Babu
MailID: k_babs@hotmail.com
hi,
I meet this question too,i used SQL 2000. So Should I stores all picture files content into database's image field? I only want to show a picture according a picture file whose name stored in database and picture file stored in my disk.
Can you give me a reply and some code?
Satishatakare
July 9th, 2003, 02:53 AM
Dear Sir,
I am using Crystal Report 8.5, I have designed my report into the .DSR format. I have created Setup of my application to Install, It installs the app on other system. But when I run the report it gives me error.
It shows Crystal Report Viewer and does not show the report but give this error Physical Database not Found.
:confused:
Humanist3
July 9th, 2003, 09:30 AM
Hi Babu: I have an ASP application that that uses crystal report, I need to access the SQL query, modify it and reset it dynamically at run time. I am thinking to use ISAPI filters to interrupt the calls to the .rpt files in the ASP. Is it doable? Do you recommend a different methods? PS note that I want to do this with the minimum or no change to the code in the ASP.
Thanks
Basheir
Satishatakare
July 10th, 2003, 03:45 AM
:) HI everybody
I have 3 reports in my app. they are successfully install/distributed to other system. I have one Problem with them
One report get open properly, but other two reports give error that is "SERVER has not yet open". I am using ODBC due to my multi-databases.
My Programming I Change registry Entries of ODBC. I think it is fine because my app is working fine, only two reports give this error. Visual Basic is used.
Please help me.
mizwan
July 15th, 2003, 04:01 AM
hi...
why some of crystal report component in VB not there when i install crystal report 8.5... but if i install the built in crystal report in visual studio 6.0 cd , all the component appear... this is the beginning of my curiosity as a newbie...
sorry for bad english......:confused: :confused:
factian
July 17th, 2003, 07:05 AM
hello, hai
please tell me how i can learn cyrstal reports.net and please recomend me best books and sites.
i am waiting for your reply.
Teekam
July 19th, 2003, 03:27 AM
Hi Everybody,
I have been trying hard to print a crystal report thru CrystalReportViewer. I am able to do it but the problem is that I donot want the print dialog box that appears with it.
I also tried PrintToPrinter method of Report which does not bring up the dialog box but that does not help either as here the arabic characters in my report are printed as junk characters.
So one of the two things will solve my problem. 1. suppress the dialog box when printing thru crystal report viewer or 2. find a way to print arabic characters.
Regards,
Teekam.
imran_qau
July 21st, 2003, 01:56 AM
Hi
How can I generate report on a pc where crystal report software is not installed. Is it possible. Or what is the other way.
I am calling report in my program using crystal report ocx control. So how it will work without installing crystal report software. Should I convert report file to exe or some other way.
Thanks
imran
tamilselvir
July 21st, 2003, 02:53 AM
Hi Friend
I need help regarding the crystal report group by function.
When we add a group by "DATE" with condition as "Weekly" it takes from Sunday to Saturday by default.But the requirement I have is Weekly should be from Monday to Saturday.IS there any way I can customize this group by function by Weekly where it can take days from Monday to Saturday?
Please reply
thanks in adv
Selvi
Rubber Duckie
July 24th, 2003, 09:11 PM
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.
Rubber Duckie
July 24th, 2003, 09:13 PM
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.
K.Babu
July 28th, 2003, 08:24 AM
Hi,
What is your actual requirement, you want to skip the sunday?...
Thanks,
K.Babu
Originally posted by tamilselvir
Hi Friend
I need help regarding the crystal report group by function.
When we add a group by "DATE" with condition as "Weekly" it takes from Sunday to Saturday by default.But the requirement I have is Weekly should be from Monday to Saturday.IS there any way I can customize this group by function by Weekly where it can take days from Monday to Saturday?
Please reply
thanks in adv
Selvi
K.Babu
July 28th, 2003, 08:31 AM
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.
nataliagonzalez
July 29th, 2003, 08:34 AM
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
CR8563
July 29th, 2003, 11:29 AM
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 !!
Rubber Duckie
July 29th, 2003, 01:02 PM
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
K.Babu
July 30th, 2003, 08:02 AM
Hi,
Just you reassign the empty string that's enough.
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
bsoundar
July 30th, 2003, 08:48 AM
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
tadaguru
July 30th, 2003, 10:42 PM
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?
Kain
August 1st, 2003, 01:13 PM
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
K.Babu
August 7th, 2003, 03:01 AM
Hi,
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?
K.Babu
August 7th, 2003, 03:14 AM
Hi,
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
stealbreeze
August 7th, 2003, 11:42 AM
Babu,
My VB6 program uses CRE8 for reporting. I just upgraded to Crystal 9. Do you know of any easy ways to migrate to RAS from RDC?
Regards,
SB
cutamacious
August 8th, 2003, 07:22 AM
Originally posted by K.Babu
Dear All,
If you have any doubt in Seagate Crystal Reports contact me, i will help you my level best.
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
Thanx in Advance
pal501
August 13th, 2003, 05:21 PM
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/library/kbase/articles/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
Shinyee
August 14th, 2003, 04:15 PM
Hello,
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
The number of data in the field various.
Thanks.
Anani
August 16th, 2003, 04:26 AM
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 ?
Roddy
August 17th, 2003, 02:58 PM
I am new to crystal reports so plz help me.
I want the previewed report to omit fields from the database based on what their value is.
For example, if we have a mailing list: The address is made from three seperate fields. If any of the fields are a certain value, like "NULL" (A string) then I don't want NULL to appear in the previewed report. It would be better if these values were filtered out in some way without sacrificing the way the mailing list address is formatted.
Ideas?
Thank you in advance.
++Roddy
Roddy
August 17th, 2003, 03:04 PM
I am new to crystal reports so plz help me.
I want the previewed report to omit fields from the database based on what their value is.
For example, if we have a mailing list: The address is made from three seperate fields. If any of the fields are a certain value, like "NULL" (A string) then I don't want NULL to appear in the previewed report. It would be better if these values were filtered out in some way without sacrificing the way the mailing list address is formatted. (Ie, no NULL's and no blank lines.)
Ideas?
Thank you in advance.
++Roddy
K.Babu
August 19th, 2003, 09:09 AM
Hi,
Enable Supress Blank Lines in section format
Thanks.
Originally posted by Roddy
I am new to crystal reports so plz help me.
I want the previewed report to omit fields from the database based on what their value is.
For example, if we have a mailing list: The address is made from three seperate fields. If any of the fields are a certain value, like "NULL" (A string) then I don't want NULL to appear in the previewed report. It would be better if these values were filtered out in some way without sacrificing the way the mailing list address is formatted. (Ie, no NULL's and no blank lines.)
Ideas?
Thank you in advance.
++Roddy
Confucius
August 21st, 2003, 09:16 AM
Babu,
I posted this earlier on the main page, I'm hoping you may be able to help me with this. I looked through your responses and didn't find anything that matched this problem:
Can you pass a formula from a SubReport back to a main report?
I have a report with tables with one to many relationship. Header table with many detail records. The subreport is currently calculating an amount on the many to one detail table and I would like to pass that figure back to the main report for further use.
The problem is that my main report does not have access to the subreport's formulas that I can see nor vice versa.
Any help will be appreciated.
Thanks
Duman
August 21st, 2003, 12:26 PM
Hi Babu, Hi All
I am VB-Developer and I Designed a large set of Reports which are accessed from a VB-Application and a ISAPI Application ... works very good.
Well, now we get multilingual, and this Reports should this functionality too.
I implemented this functionality in that way:
I open a Report in the Runtime DesigneComponent (8.5) and I replace the translated text in all TextObjects.
Works fine too ... but unless I have to Replace The Text in a TextObject, which includes at least one Field object.
TextObject-Example with including FieldObject (View in the ReportDesigner):
"Your Invoice No. [InVoiceNo] amounts [Amount] EURO."
I had no chance to get any info about this extendet Properties of a TextObject.
The only chance i have is the Text-Property of the TextObject. But this only replies (for the example I mentioned) the Value: "Your Invoice No. [] amounts [] EURO."
My Question is: How can I cance the Text in an extendet Textbox, without loosing the including FieldObjects?
dl29200
August 21st, 2003, 12:38 PM
Hi - just posted a CrystalReport thread at
http://www.codeguru.com/forum/showthread.php?s=&threadid=260497
Meant to add it to this thread but it went to VB programming...
Duman
August 21st, 2003, 01:13 PM
Hi Confucius,
you can easyly solve your problem with shared variables, which are valid within MainReport and SubReports.
Do it this way:
use a Formula in head of the MainReport:
Shared currencyVar x := 0;
a Formula at end of your SubReport :
Shared currencyVar x ;
x = {@Amount}
and a Formula on the place in the MainReport, where you need the Sum:
Shared currencyVar x ;
x
All this are Crystal-Syntax
____________________________
Confucius
Junior Member
I posted this earlier on the main page, I'm hoping you may be able to help me with this. I looked through your responses and didn't find anything that matched this problem:
Can you pass a formula from a SubReport back to a main report?
I have a report with tables with one to many relationship. Header table with many detail records. The subreport is currently calculating an amount on the many to one detail table and I would like to pass that figure back to the main report for further use.
The problem is that my main report does not have access to the subreport's formulas that I can see nor vice versa.
Any help will be appreciated.
Thanks
Duman
August 21st, 2003, 01:20 PM
Sorry i forgot to mention that you have to declare the variable in every Formula, in which you need it.
But it has the last value which was assigned.
Shared Variables have the sane memory area for a variable in Report-SubReports.
Confucius
August 21st, 2003, 01:44 PM
Thanks Duman, I'll give it a shot.
bsoundar
August 22nd, 2003, 01:58 AM
Hi,
The Output what you have shown is one column with many rows... ... Right ?
One small solution can be given: see to that how you use to your situation..
1. Group that Column
2. If needed no data's can be displayed in that Group.
3. Create a Formula. Inside the formula, introduce a Variable and concatenate that Field values.
4. In Group Footer Show that Formula.
Just check with this. If not just attach your .Rpt files. Let me solve it, if possible..
Okay, Just try with the above Solu:
Alll the Best !!!
Originally posted by Shinyee
Hello,
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
The number of data in the field various.
Thanks.
bsoundar
August 23rd, 2003, 07:59 AM
Hi,
Iam creating an Report using Crystal Report. In the Formula Editor a get this error
"The remaining text does not appear to be part of the Formula":
Check the Attachment for clear understanding:
Do reply for this.... !!! :confused: and :(
thank U!!
robot96
August 26th, 2003, 12:24 AM
I have created a crystal SQL queire to select my data for a report however when I use the queire in the report I only get the option to group by the numeric feilds where as when I make a connection to the data base through the report I can chose any feild to group by.
Also if I create a report using a specific database can that be changed using a VB or Borland builder to change the source location.
Alexey931
August 27th, 2003, 06:41 AM
Hi,
For VS2002 they used to build a runtime for the subject with the following megre modules:
managed.msm
database_access.msm
database_access_enu.msm
regwiz.msm
VC_CRT.msm
VC_STL.msm
It was also a known issue about ATL.msm, which updated atl.dll, in orderd to eliminate the Load report failed error. All this used to work fine, until I was forced to upgrade to VS2003. I discovered, that the names of all the merge modules had changed, but tried my best guess:
Crystal_Database_Access2003.msm
Crystal_Database_Access2003_enu.msm
Crystal_Managed2003.msm
Crystal_regwiz2003.msm
VC_User_ATL71_RTL_X86_---.msm
VC_User_CRT71_RTL_X86_---.msm
VC_User_STL71_RTL_X86_---.msm
However, this leaves me with the Load report failed error. I tried to find the atl.dll on the target system, and found atl.dll in the system directory (the old one, I suspect), and some atl71.dll in the Application Folder of the installation. To me this looks a bit suspicious, but I can guess no further. Will anybody who knows for certain please help? BTW, the target system is w98.
Grateful in advance, Alexey
Duman
August 28th, 2003, 07:29 AM
Hi robot96
the onyl fieldtype you cant group on is MEMO.
If you still want to Group on that fields, convert them in your SQL-Clause as Varchar.
Originally posted by robot96
I have created a crystal SQL queire to select my data for a report however when I use the queire in the report I only get the option to group by the numeric feilds where as when I make a connection to the data base through the report I can chose any feild to group by.
Also if I create a report using a specific database can that be changed using a VB or Borland builder to change the source location.
xIRC
September 1st, 2003, 12:06 PM
About 1 month ago I demonstrated an application written in VB.
In this software I included crystal reports, because the standard reports don't have that kind of functionality.
Now the demo went really fine, no issues or such things. I did not change anything to the application, BUT, now when I wanted to install the full application, the reports don't wanna work.
1. I get the error: 'Physical Database not found!'
2. The report references a location eg. 'c:\program files\app\app.mdb
3. This report is using the CRViewer control, and the actual report designed in VB -> 'Designers'...
For some reason the reports don't wanna see the Database, BUT the actual Database, is refelecting, at the location, that the report points to, I have verified the Database, and I also made sure to set the location of the report to the directory where the report resides...
I am using the MyReport.DataSource = (ado recordset). (As explained by Crystal Reports, this actually did work). But now it does not work....?
Question: Is there maybe a property that I can use to programmatically "Set" the report's database location?
The Values for the first line is not in first record. Each and every item will be a record.
Solution for this, required ..... Thank You..
Soundar
jasmine03
September 3rd, 2003, 05:12 PM
I am using Crystal Reports through a Rational product - ClearQuest. All fields have been defined in ClearQuest and I just insert the field objects in the report design. The fields that I use are of type text and vary in their size (and could be 1 line or 50 lines). When I place these fields one below the other, they get overwritten. The second field that comes below the first one should start a couple of lines on completion of the first one.
What should I do to prevent this?
eba
September 6th, 2003, 11:07 PM
Hello Babu,
I am new in programming, especially in Crystal Reports! From a web form, I am sending few parametrs to another web form where I will use them to create a crystal report.
I have the database connection, parametrs and evrything added for Crystal report to be generated, but an user can select only 1 choice and 1 parameter can be sent to the other form. Maybe all 3 choices or different combinations of 2 parameters!
How do I write or where do I put the logic for crystal report to expect different numbers of parameters?
I thought Crystal Report was simple, but it's making me crazy.
Right now, I have a report set up that requires all 3 parametrs.
I need to create reports, according to what user selects! With 1 , 2 or all 3 parameters. Also sorting by a certain parameter.
One more thing, I need to display the report in .PDF format in webform. (vb.net)
Please help. Thanks in advance.
xIRC
September 8th, 2003, 02:15 AM
The project I created in VB 6, using MS Access.
Now redistributing this project to a client's PC works fine. I use the MDAC version 2.6. I created an installation file, and installed the application on the client's PC. I used the standard references, to dll included by the setup wizard. This works fine.
Now testing the application on the client's PC this actually run 100% fine, until I reach the reports, then I get the error: "Physical database not found.". This error, is 'caused by some dll files not being included on the client's PC. Now using Crystal reports I use, the RDC Model, and it's v 8.0. So I read up on this, and included these files on the client's pc, and it worked ... it got past this error. At this stage I'm faced with another error. "Can not create DAO DBEngine". I went on to install MS Access on the client's PC, and tested the application once more. It worked :)
My question stand at, this stage, according to Crystal Reports one needs to include 3 .dll files for this to work, when Access IS present. But what happens when the client does not have MS Access, installed, and he/she won't be able to install MS Access, remember the application does work when comunicating with the .mdb file. it's only the reports not working, so I thought this must be .dll files from Crystal Reports itself that I also need to distribute with the installation CD ????
Any help on this, I did read an article explaining this, but I tried that, and it did not work ...
Thanx in advance ...
xIRC
Tangengot
September 8th, 2003, 09:45 PM
I would like to know how can I do printing, by scaping the preview. I'M currently using Crystal Report 8.5. IF I do printing without doing the preview, I dont get any data that should repect in my prinout.
winomonkey
September 10th, 2003, 03:20 PM
Greetings Babu -
I was wondering if you could help me with some dynamic reporting issues that I have at the moment. I am working in C#, and am currently designing a program that will pull data from a SQL table (most likely into a dataset, so that each query run won't have the total roundtrip cost...I am still looking into it), and then allow the user to select to query the data using either pre-created queries, or by creating their own, and then selecting the report that they would like to see the data displayed in.
My problem is this - I have seen the dynamic report example for C#, and I can see what is being done in the code, but I do not understand how to create Formulas and such with the report designer that will allow me to pass parameters from the user into the report.
So: I have the application- / programming-level knowledge to utilize a user-defined field, but I do not know how to actually create the field within the Crystal Reports Designer included with .NET 2003. Can you help me with this?
Many thanks for your time.
Ciao,
Garret
K.Babu
September 18th, 2003, 06:36 AM
Hi,
You have to install ODBC Data Source to your client machine, it's free download available in microsoft, make sure the file name MDAC_TYP.exe version 2.6.
so, you no need to install ms access.
yours friendly,
K.Babu
Originally posted by xIRC
The project I created in VB 6, using MS Access.
Now redistributing this project to a client's PC works fine. I use the MDAC version 2.6. I created an installation file, and installed the application on the client's PC. I used the standard references, to dll included by the setup wizard. This works fine.
Now testing the application on the client's PC this actually run 100% fine, until I reach the reports, then I get the error: "Physical database not found.". This error, is 'caused by some dll files not being included on the client's PC. Now using Crystal reports I use, the RDC Model, and it's v 8.0. So I read up on this, and included these files on the client's pc, and it worked ... it got past this error. At this stage I'm faced with another error. "Can not create DAO DBEngine". I went on to install MS Access on the client's PC, and tested the application once more. It worked :)
My question stand at, this stage, according to Crystal Reports one needs to include 3 .dll files for this to work, when Access IS present. But what happens when the client does not have MS Access, installed, and he/she won't be able to install MS Access, remember the application does work when comunicating with the .mdb file. it's only the reports not working, so I thought this must be .dll files from Crystal Reports itself that I also need to distribute with the installation CD ????
Any help on this, I did read an article explaining this, but I tried that, and it did not work ...
Thanx in advance ...
xIRC
K.Babu
September 22nd, 2003, 11:40 PM
Dear Friends,
The following files are required at runtime, when using Crystal ActiveX Control Version 8.0
CRYSTL32.OCX Crystal Reports ActiveX Control
MFCANS32.DLL OLE2ANSI Library
OLEPRO32.DLL OLE Property Support DLL
CRPE32.DLL Interface to the Crystal Report Engine
CRPAIG80.DLL Crystal Reports text object support
IMPLODE.DLL Compression Library
MFC42.DLL Microsoft Foundation Class Libraries
MSVCIRT.DLL Runtime Library
MSVCP60.DLL Runtime Library
You have to register crystl32.ocx using with regsvr32.exe.
Thanks,
K.Babu
fahedksa
September 23rd, 2003, 06:30 AM
I have reports in my visual basic project and i but database oben by code in project to example server1
and also when create reports i assign server1 to report in my project
but how i can change from server1 to another server have the same database and tables and everything without gfo to each report to change server name
K.Babu
September 23rd, 2003, 07:03 AM
Hi,
1. From your vb application Which method you are using to access the crystal report engine?
2. What type of backend you want to connect (Backend Name)?
3. crystal report version?
4. Paste your sample code of connection database source?
Thanks
K.Babu
Originally posted by fahedksa
I have reports in my visual basic project and i but database oben by code in project to example server1
and also when create reports i assign server1 to report in my project
but how i can change from server1 to another server have the same database and tables and everything without gfo to each report to change server name
K.Babu
September 23rd, 2003, 07:47 AM
Dear Friends,
I received more emails regarding problem while crystal report export to PDF format.
This problem happens when distribute the vb application using with crystal report to client machine.
This problem may occurs file missing (PDF export relation) or not registered properly in windows.
Export PDF format (Crystal Report Ver 8.0)
Following files are required run time.
CRXF_PDF.DLL PDF format.
EXPORTMODELLER.DLL Creates a representation of the Crystal Encapsulated Page Format (EPF). The representation is used by the export format DLL as a basis when translating to it’s own format.
CRTSLV.DLL Used by EXPORTMODELLER.DLL to process the EPF.
Note: ExportModeller.dll and Crtslv.dll should regester using with regsvr32.exe
Thanks
K.Babu
fahedksa
September 24th, 2003, 03:09 AM
1-The code i use to connect visual basic to SQL Database
then i can use deal with my projrct without any problem here.
2-Connect database to crystal report
i assign the databsed in report by choosing the oledbsql from add database
to report and thats it.
My problem as i said is :
my report work fine with my project ,when i was initalize these report
i but sql server (Server1) and to these points every thing Ok.
But if i want change from server1 to server3 should i go to all
reports to do these.
I use crystal report 8.5
O.S XP,2000
Visual Basic 6
zhel
September 25th, 2003, 05:04 AM
hi babu !
please help me,,,am still a newbie in crystal reports.
i want to ask what particular control should i use in a form to run a crystal report,,, the crviewer seems to have a problem. i get an error when registering the crystl32.ocx
if you can discuss to me how should i start..please! thanks very much in advance! ;)
zhel
cherylwong
September 25th, 2003, 11:24 AM
I am using VB.NET. Firstly I created a crystal report(a rpt file) in it, Then I created a new form, where I drag teh crystal report viewer into the new form. Then I link the souce of the rpt file to the database which I want to retrive the data from.
But when I ran the report, I could only see the table with the fields..no data appeared. What is the problem?
greg007
September 26th, 2003, 03:23 AM
Hello all,
I've got a problem with my crsytal report.
Actually iI display a crystal report in a crystal report viewer, that works very well on my development machine which is my web server too (web server used is IIS).
But when I want to consultate the report from another machine ( a client machine) the report doesn't work:
the report is loaded, I can see the toolbar and the tree, but the graph can't be loaded and displayed.
I primary thought the problem was a bad dll, but finaly I think the problem is due to a access/permissions configuration.
If someone can help me...
In advance thanks.
mpsudheer
September 27th, 2003, 03:58 AM
hi Babu,
I have a main report which contains details of users like First name, last name ,address etc. This i am selecting directly from a table (database is SQL Server) . I have a sub report which should display the transaction details done by the user in between FromDate and ToDate. For this subreport i have written a parametrised sql query which accepts the From and To dates and selects details of all the users and transactions in that period. I have linked the main report and sub report on Firstname and lastname fields. In the query i am casting the date to smalldatetime. When i run the report it is giving ODBC error.. saying error in converting string to datetime.. . when i use the same query for a main report it is giving results.. Only when the same query is used in subreport and the sub report when called from main, it is giving the error.... please help me .
Thanks
Sudheer
joule
September 29th, 2003, 04:13 AM
Hey Babu
Two quite urgent questions!
First I have created a CR from a ADO.Net Dataset (filled using a ODBC connection and DataAdapter) and I am passing it to the Report.... at first everything is working fine but when I want to refresh the Report every Minute the changes in the Dataset do not occur in the ReportViewer.
Could you give me a hint why this problem appears?
Secondly I have to report the results from 7 Machines and not every machine returns a result at runtime, still I want to have seven parts on the x-axis. Is that possible?
Thanks a lot
joule
jigarzon
October 2nd, 2003, 12:44 PM
Hi, i stored a JPG file (i tried with a BMP too) in a Blob field on a Sql Server 2000 db using a program in Visual Basic 6.
I simply read the file as binary, and put the data on the field using AppendChunk. When i want to retrieve the data in VB, i get it using GetChunk, i write it on a temp file, and use LoadPicture to display the temp jpg file on a PictureBox... All this works fine...
The problem appears in the Crystal Report 8.5 Report: it doesn't display anything. I'm sure i stored "something" because i can read data from my VB program. I tried with the Northwinds database (it has a Table with image data), and CR works fine with it... I think im not saving the data in the right way, does CR use a different manner as my program to read the image from a blob???
Please help me urgently ,
thanks in advance...
Thiyagu76
October 6th, 2003, 06:50 PM
Hello there,
I am working with CR 9 evaluation package. I have a main report with 4 subreports. I created 4 details section and each section has a subreport.
I want to supress the main report itself if none of the four subreport have any data. My main report have header and footer too. I just dont want to have the report which is not having any data in the subreports.
And also I want to know whether exporting the report into pdf into separate individual files based on account ID
Expecting earlier reply
Thanks
Thiyagu
K.Babu
October 7th, 2003, 04:34 AM
Hi,
Refer the NoData event.
Event NoData(pCancel As Boolean)
Member of CRAXDRT.Report
Fires this event when there is no data
Thanks.
Originally posted by Thiyagu76
Hello there,
I am working with CR 9 evaluation package. I have a main report with 4 subreports. I created 4 details section and each section has a subreport.
I want to supress the main report itself if none of the four subreport have any data. My main report have header and footer too. I just dont want to have the report which is not having any data in the subreports.
And also I want to know whether exporting the report into pdf into separate individual files based on account ID
Expecting earlier reply
Thanks
Thiyagu
K.Babu
October 7th, 2003, 04:41 AM
Dear Friends,
I received more mail (in my personal email) regarding, how to connect database to subreport. Here i paste the sample code for subreport, I hope this will be help all.
'prompt for location of xtreme sample database
CommonDialog1.ShowOpen
'the following code sets the report tables to a different database
CRReport.Database.Tables(1).Location = CommonDialog1.FileName
'set the value for a text object in the header of the main report
CRReport.Text1.SetText "This is the main report"
'this code works through the RDC object model to identify a subreport object
'in the main report
Dim crSecs As CRAXDRT.Sections
Dim crSec As CRAXDRT.Section
Dim crRepObjs As CRAXDRT.ReportObjects
Dim crSubRepObj As CRAXDRT.SubreportObject
Dim crSubReport As CRAXDRT.Report
Dim i As Integer
Set crSecs = CRReport.Sections
For i = 1 To crSecs.Count
Set crSec = crSecs.Item(i)
Set crRepObjs = crSec.ReportObjects
For X = 1 To crRepObjs.Count
If crRepObjs.Item(X).Kind = crSubreportObject Then
Set crSubReport = CRReport.OpenSubreport(crRepObjs.Item(X).SubreportName)
'the following code sets the subreport table to a different database
crSubReport.Database.Tables(1).Location = CommonDialog1.FileName
'set the value for a text object in the header of the subreport
CRReport.Subreport1_Text2.SetText "This is the subreport"
'within this loop you can set other properties of the subreport and
'the field objects and sections in it.
I am new to CR and I dunno VB too. I couldnt able to find the CRAXDRT.Report anywhere in the CR 9 evaluation package. How to get this enabled or where should i find this. More details would be helpful to me.
Thanks
Thiyagu
davidzhu
October 7th, 2003, 11:15 AM
Hi,
I want to dynamiclly load several datasets.
Make graph on crystalreport changing by different datasets.
How to handle in C#?
Thanks!
K.Babu
October 9th, 2003, 12:54 AM
Hi,
Add Crystal Report x.x Designers Module in your project, then find the class CRAXDRT in object browser window in view menu.
Regards,
K.Babu
Originally posted by Thiyagu76
Hi Mr. Babu,
I am new to CR and I dunno VB too. I couldnt able to find the CRAXDRT.Report anywhere in the CR 9 evaluation package. How to get this enabled or where should i find this. More details would be helpful to me.
Thanks
Thiyagu
Thiyagu76
October 9th, 2003, 10:40 AM
Hi Babu,
Thanks very much for you reply. Is CR designer module comes with the evaluation package or I have to download separately :0(
sorry for asking such a simple question.
Thanks
Thiyagu
davidzhu
October 9th, 2003, 12:16 PM
hi,Babu
How to set
ReportDocument.DataDefinition.SortFields[0].Field.FormulaName
like "Sum({Table.column1},{Table.column2})" , and Field.kind like SummaryField in Code.
I am so puzzled.
Thanks very much
mpsudheer
October 10th, 2003, 10:38 AM
Hi ,
In crystal Report can i be able to connect to different servers based on the user input. Eg- User will select a location (Chennai, Bangalore etc..) based on which i have to connect to SQL Server on that location. I don't have a front end like VB or ASP. I have to do it directly in Crystal Report. Is it possible to do this????
Please suggest a solution
Thanks in advance
Sudheer
Thiyagu76
October 10th, 2003, 12:17 PM
Hello,
I have two subreports and merged them in a main report. I need to get the Grand Total from both the subreports and pass them into third subreport and also place it in the main report.. hope I am not confusing, :-)
Sub-Report1 having debit/credit column for some activites
Sub-Report2 having debit/credit coulmn for some other activites
MainReport = subreport1 + subreport2
I need to include the Grand Total from both subreport1 + subreport2 and place it in the main report.
How can i achieve this. Pls reply
Thanks
Thiyagu
lam0620
October 14th, 2003, 12:35 AM
Hi all,
I want to ask all of you a problems.
I using VB6 + Crystal Reports 8.5.
In my VB application, I make a report which developed Crystal Reports. In screen report, I export this report to Microsoft Word.
My problem is my report designed is nice, have rows and columns, but they disappear in word file that I exported.
I'm newbie VB and CR. I dont know how to be exported file has rows and cols as designed report.
Maybe this problems not be in VB, it is in CR.
For example, my report as
|----------------------------------------|
|ID | CustomerName | Date |
|-----|----------------------|-----------|
|001| David James | 10/9/03 |
|-----|----------------------|------------|
|002| Lam nguyen | 11/8/03 |
|-----|----------------------|------------|
|003 | Yamamoto | 7/20/03 |
|-----------------------------------------|
Exported word file is:
ID CustomerName Date
001 David James 10/9/03
002 Lam nguyen 11/8/03
003 Yamamoto 7/20/03
rows and cols disappeared in exported Word file.
What do I do to format of word file as in my report
Any hints are appreciate.
lam0620.
K.Babu
October 14th, 2003, 01:50 AM
Hi,
yes, crystal report had LogOnServer method it contains server connection string, so that you can change the sql server location.
In crystal report design time, you can use "logon/off server" and "set location" to change the server location.
Regards,
K.Babu
Originally posted by mpsudheer
Hi ,
In crystal Report can i be able to connect to different servers based on the user input. Eg- User will select a location (Chennai, Bangalore etc..) based on which i have to connect to SQL Server on that location. I don't have a front end like VB or ASP. I have to do it directly in Crystal Report. Is it possible to do this????
Please suggest a solution
Thanks in advance
Sudheer
Patzer
October 16th, 2003, 10:48 AM
Hi,
I've created a VB exe, that dynamically opens existing *.rpt files, and exports them to pdf.
The user can add filter the data before the export (passed via the command line).
At some of the reports (at least when an unlinked subreport is included in the report), the decimal place seems to be snipped (1.23 becomes 1.00, and 1.67 also becomes 1.00).
Thus nearly any value is wrong.
When I open the report file in Crystal reports, everything is fine, but when I open it from Vb (also before the export, by using the CRviewer), the problem appears.
As the Seagate support was - to put it mildly - not very helpful - maybe one of you can help
I'm using CR 8.5, SQL-Server 7 and VB6.
bsoundar
October 17th, 2003, 07:10 AM
Hi.
What is the difference between "LogonServer" & "Connect" method.
"LogOnInfo" method is for connecting different Servers.
If any one could, clarify me.
And ... I created Balance Sheet report with a back-end has Oracle. I used DSN. How to reflect the Report if the Schema Object is changed.
Thank You
K.Babu
October 18th, 2003, 07:16 AM
Hi,
Use the LogOnInfo property when the report connects to multiple data sources that require different log on information. If the report connects to only a single ODBC data source or SQL server, and only a single set of log on information is required, simply pass 0 as the array index, or Connect, can be used instead.
Use a separate line of code for each table for which you want to change the logon info.
The order of tables in the array must conform to the order of tables in the report. (You can use the Database|Set Location command to determine the order of tables in the report.)
The first table in the report is array index (0), the second file is (1), etc. For example, to change the logon information of the first and third tables in a report to the NEW server, use the following syntax:
If You tick the check box of "verify on every print", it will automatically updates the schema object changes.
Originally posted by bsoundar
Hi.
What is the difference between "LogonServer" & "Connect" method.
"LogOnInfo" method is for connecting different Servers.
If any one could, clarify me.
And ... I created Balance Sheet report with a back-end has Oracle. I used DSN. How to reflect the Report if the Schema Object is changed.
Thank You
K.Babu
October 18th, 2003, 07:44 AM
Hi,
1. Use "SelectionFormula" to filter the data
Eg.
Cr.SelectionFormula = "{Table1.Field_name} = 'raja' "
------------
2. Make sure the backend field data type allow the decimal value
------------
3. May be the CRviewer runtime library files are not properly installed.
Originally posted by Patzer
Hi,
I've created a VB exe, that dynamically opens existing *.rpt files, and exports them to pdf.
The user can add filter the data before the export (passed via the command line).
At some of the reports (at least when an unlinked subreport is included in the report), the decimal place seems to be snipped (1.23 becomes 1.00, and 1.67 also becomes 1.00).
Thus nearly any value is wrong.
When I open the report file in Crystal reports, everything is fine, but when I open it from Vb (also before the export, by using the CRviewer), the problem appears.
As the Seagate support was - to put it mildly - not very helpful - maybe one of you can help
I'm using CR 8.5, SQL-Server 7 and VB6.
SayliJoshi
October 20th, 2003, 01:43 AM
Hi,
I have a report with crosstab. this crosstab appears per group. i want to export each crosstab on separate excel sheet. as the number of groups incerases, the excel sheet should also increase.
I will make it clear.
i have something as category. i create a group of this field category. now i create a crosstab and insert in detail section. so the output will be matrix report as per category. that is i will get as many crosstabs as there are categories in my table.
now i want to export this report into microsoft excel file. Microsoft Excel is a spreetsheet package. Each file is a workbook and there can be n number of worksheets into that workbook.
what i want is that each crosstab ir each group should appear in single worksheet of excel workbook. It means there should be as many worksheets in the excel workbook as there are categories or crosstabs in the report.
Looking forward for ur reply.
Thank You.
syedhassan4
October 20th, 2003, 03:48 AM
I used Crystal Report 9 (Crystal Report Service Pack 1) in my Visual Basic application and it working fine on my system (i am using Windows 2000 Pro - Service Pack 4, Visual Studio Service Pack 5).
Now I need to creat a Deployment wizard, which can be Run on Windows 2000 and also on WINDOWS 98 (second edition). After a long searching and working, and spending alot of time on the file required files for Crystal Report, i creat a setup. BUT that dose not work properly even though i put all the required files as per the given instruction in the Crystal Report Runtime help.
Please please help me on that matter.... GIVE me list of files which required for the setup, and also which file should be put on which Path, and which DLL should be registered.
And the most important part is WINDOWS 98, in windows 98 there is problem of UNICOWS, please also help me on that matter.
I will be really very very very very thankful to u....
I am really unable to solve the problem of Crytal Report 9.0.
K.Babu
October 20th, 2003, 05:39 AM
Hi,
What type of crystal report engine you are using in your vb app.
eg. (ActiveX control, RDC)
regards,
K.Babu
Originally posted by syedhassan4
I used Crystal Report 9 (Crystal Report Service Pack 1) in my Visual Basic application and it working fine on my system (i am using Windows 2000 Pro - Service Pack 4, Visual Studio Service Pack 5).
Now I need to creat a Deployment wizard, which can be Run on Windows 2000 and also on WINDOWS 98 (second edition). After a long searching and working, and spending alot of time on the file required files for Crystal Report, i creat a setup. BUT that dose not work properly even though i put all the required files as per the given instruction in the Crystal Report Runtime help.
Please please help me on that matter.... GIVE me list of files which required for the setup, and also which file should be put on which Path, and which DLL should be registered.
And the most important part is WINDOWS 98, in windows 98 there is problem of UNICOWS, please also help me on that matter.
I will be really very very very very thankful to u....
I am really unable to solve the problem of Crytal Report 9.0.
syedhassan4
October 20th, 2003, 05:44 AM
Sorry i missed this.... i am using RDC
bsoundar
October 20th, 2003, 06:07 AM
First of all I would like to Thank you for replying.... Babu..
I tested what you said.. but i get an error stating...
x20506 Invalid Table Number
This is my coding.... Check where I made the Mistake. {First I checked the 'Verify on Every Print' in the report at Design Time} I use sub-report too.
NOTE: You must register these DLLs using regsvr32.exe.
NOTE: The Crystal Report Viewer DLL needs to be distributed if reports are being printed to the screen. If the reports are being exported or printed to the printer, and not being viewed to a window, then this DLL is not required. Note: Embeddable Crystal Reports Designer Control accesses to the report engine through using CRAXDDRT.DLL (Crystal Reports ActiveX Designer Design and Runtime Support DLL
FILE LOCATION
IMPLODE.DLL \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32
SSCSDK80.DLL \PROGRAM FILES\SEAGATE SOFTWARE\SHARED
PG32CONV.DLL \PROGRAM FILES\SEAGATE SOFTWARE\SHARED
CRPAIG80.DLL \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32
MFC42.DLL \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32
MSVCRT.DLL \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32
NOTE: Include IMPLODE.DLL only for applications using reports created in versions previous to SCR 8.
The following files are also must register using with regsvr32.exe
Originally posted by syedhassan4
I used Crystal Report 9 (Crystal Report Service Pack 1) in my Visual Basic application and it working fine on my system (i am using Windows 2000 Pro - Service Pack 4, Visual Studio Service Pack 5).
Now I need to creat a Deployment wizard, which can be Run on Windows 2000 and also on WINDOWS 98 (second edition). After a long searching and working, and spending alot of time on the file required files for Crystal Report, i creat a setup. BUT that dose not work properly even though i put all the required files as per the given instruction in the Crystal Report Runtime help.
Please please help me on that matter.... GIVE me list of files which required for the setup, and also which file should be put on which Path, and which DLL should be registered.
And the most important part is WINDOWS 98, in windows 98 there is problem of UNICOWS, please also help me on that matter.
I will be really very very very very thankful to u....
I am really unable to solve the problem of Crytal Report 9.0.
K.Babu
October 20th, 2003, 07:11 AM
You have to specify all the information in logoninfo(n) property
DSN = Data Source Name
UID = User Logon ID
PWD = Logon password
DSQ = "c:\projects\data.mdb" [or server name]
Originally posted by bsoundar
First of all I would like to Thank you for replying.... Babu..
I tested what you said.. but i get an error stating...
x20506 Invalid Table Number
This is my coding.... Check where I made the Mistake. {First I checked the 'Verify on Every Print' in the report at Design Time} I use sub-report too.
In this report 1 main report, 2 Sub-report.
In the Main report I used 2 tables, in the Sub report, I used 1 report each.
Regards
Soundar
Note: Expecting your Early reply.. Thank You !!
K.Babu
October 20th, 2003, 07:17 AM
Hi,
In Crystal Report Viewer there is an option to filter the data while viewing the report, use the filter wizard to filter the exact data whatever you need then export the content which format you wish.
Originally posted by SayliJoshi
Hi,
I have a report with crosstab. this crosstab appears per group. i want to export each crosstab on separate excel sheet. as the number of groups incerases, the excel sheet should also increase.
I will make it clear.
i have something as category. i create a group of this field category. now i create a crosstab and insert in detail section. so the output will be matrix report as per category. that is i will get as many crosstabs as there are categories in my table.
now i want to export this report into microsoft excel file. Microsoft Excel is a spreetsheet package. Each file is a workbook and there can be n number of worksheets into that workbook.
what i want is that each crosstab ir each group should appear in single worksheet of excel workbook. It means there should be as many worksheets in the excel workbook as there are categories or crosstabs in the report.
Looking forward for ur reply.
Thank You.
K.Babu
October 20th, 2003, 07:22 AM
Is your problem solved?
Originally posted by syedhassan4
Sorry i missed this.... i am using RDC
SayliJoshi
October 20th, 2003, 07:35 AM
Hi
see i do not want to filter the data. i want all the groups or categories to appear in the report. while exporting i want each crosstab or category with the categoryname as name of sheet to appear in each sheet of excel file.
Pl Help .its really important.
Thank you
Originally posted by K.Babu
Hi,
In Crystal Report Viewer there is an option to filter the data while viewing the report, use the filter wizard to filter the exact data whatever you need then export the content which format you wish.
bsoundar
October 20th, 2003, 09:34 AM
hi..
I use Oracle has a Database .... so I left the DSQ portion,
What else i should do...
Originally posted by K.Babu
You have to specify all the information in logoninfo(n) property
DSN = Data Source Name
UID = User Logon ID
PWD = Logon password
DSQ = "c:\projects\data.mdb" [or server name]
mux
October 21st, 2003, 05:13 AM
Hi all,
I just started using Crystal Reports a few days ago and thus don't have any real experience with it. I'm trying to have checkboxes in my report, which will be checked or not depending on a boolean value in my database. What's the easiest way to achieve this with Crystal Reports ?
Thanks in advance,
Maxime
SayliJoshi
October 21st, 2003, 08:14 AM
Hi
i am writing code for exporting crystal report file. but get the following error:
Error in File C:\Inetpub\wwwroot\HR\SkillMatrix.rpt: Error detected by export DLL:
I received more emails regarding, how to view pictures in the database file.
The database table field contains picturename and its path. they want to display get pictures from the stored path.
I Attached VB 6.0 sample Code to this reply
Project used software:
Windows 2000
VB 6.0
Crystal Report using with RDC Method Engine 8.5
MS Access 97
Attach file name: CRPhoto.zip
I hope this sample code will help all developers.
Regards,
K.Babu
bharadwajrv
October 22nd, 2003, 09:16 AM
Hi,
how to open the Crystal report in the ASP page..
thanx in adv..
Venu
hrast
October 27th, 2003, 05:34 PM
Hello..
I'm new in Crystal Reports. I have a question..
I have a VB project, and on one form i have data in DataGrid.
This data are results of an SQL query. Database is Baza.mdb .
Are there on the forum (or WEB) any instructions how to print those data in DataGrid trough Crystal Report ???
Or maybe you can help me?
Thank you...
K.Babu
October 28th, 2003, 06:39 AM
You can find out the answers from the VB code for the following questions.
Q:
How to open MSAccess database file from select path in VB at run mode?
How to hide password prompt dialog box, from the protected database file?
How to open OCX report file to RDC method?
How to Export PDF format without Preview screen?
How to Hide export prompt dialog box?
How to Filter the data records in VB at Run mode?
How to open automatically Exported PDF file with acrobatreader?
Dim crrpt As New CRAXDRT.Report
Dim crapp As New CRAXDRT.Application
I am using Activex Viewer in Crystal reports 8 to show the reports on Web with ASP. The reports appears properly Crystal report environment.Even the report appears fine when used in Visual basic. But When seen on web the alignment of the report is changing.The text is not taking the pagesetup margins at all.
Looking forward from u...
ravi
Delamater
October 29th, 2003, 01:06 PM
Does anyone know of a utility that will compare the differences betweent two .RPT files?
Thanks,
Bob
WoodenSword
October 29th, 2003, 02:09 PM
Hello ,
I am using Crystal Reports Net with a cvs file through an DAO Connection.
When add the database file within the crystal report designer,everything is ok.Crystal reports recognize the file as text database and its fields.
However,when i bind the report to the crystal report viewer (at runtime) the login screen appears asking for password.The problem is that i have NOT used a secure logon.
I tried to use TableLogInfo but the dialog still appears!!
LOGIN FAILED :(((((
jake88
October 31st, 2003, 03:04 PM
I am currently using CR 7.0 on a winnt 4.0
platform (I know, I know, nothing I can
control) with sql 2000. I am getting the
following error
User Session has timed out, I have tried
everything suggested by crystal in the pdf
file outlining this error. From there they
suggested that I insert code to display the
true error code, which is:
On the web page (asp) I go in to the search
page and perform a search, it takes about 10
minutes but the report comes up. So far so
good...
Now if I do the search again and then have
another person login to the same search page
and perform a search (can be totaly
different searches) the second person will
get this error, while my search will
complete.
Can someone help me out? Thanks
Shafan
November 5th, 2003, 01:38 AM
Hi,
I'm trying to change the default display of a boolean field value so that it would display a String of my choice (in this case a different language than English).
I've tried using IIF in the formula of the Boolean Text property (in the Boolean tab in the field's Format Editor) but it says that the formula's result must be a number.
Any ideas?
Thanx
biswassurajit
November 6th, 2003, 12:38 PM
Dear Mr. Babu
Please help for the following problem.
I have designed a report in crystel report 8.0. with password protected MS Access database. When I save the report with save report with data, on prevewing through my VB project it opens up the report but did not refresh with any new data that is being added to dadabase. When I run the same report without saving with save with data option it gives me the error : error no 20535 Invalid secession parameter.
A am pasting the sample code that I used: where cr1 the crystel report control
with cr1
.reset
.reportfilename=app.path & "\report1.rpt"
.LogInfo="aaaa" '(this is the password)
.WindowParentHandle=MdiForm1.hwnd
.WindowState=crptMaximized
.Destination=crptToWindow
.Action=0
end with
This same code works fine with database without any password. And gives me updated data on previewing.
Please how can get refreshed report from a password protected database.
Thanks to you.
Biswas
skyliner
November 7th, 2003, 05:43 AM
Hi, Babu
Crystal Reports 8.5 makes a tmp file with size 0 kb when I open a
report. This is when I am developing and with the compiled version of my app.
CR puts the files in de lowest directory where the user has rights (not in the tempdir, but dir's like C-root) and doesn't delete them. Very annoying.
Do you know if there is a hotfix? Or do you have another solution?
I develop with Crystal Reports 8.5, Visual Basic 6.0 under Windows XP and 2000.
Regards,
John
murali_utr
November 8th, 2003, 01:52 AM
hi babu,
i using crystal report 6.0 for my project. i don't know what are the fiels needed to redistribute the crstal report with my application package. i take setup for the project using package & deployment of visual studioi .net. any one help to me. how to do this.
thanks in advance.
Murali.M
Shafan
November 9th, 2003, 08:53 AM
Hi Babu,
I've designed a report based on a ADO database using a connection string. While building the connection string I pointed out the database from which the data is extracted.
The report runs on the development machine no problems, but when I try to run it on a deployment machine I get a Database Error:
"[Microsoft][ODBC Microsoft Access Driver] '(Unknown)' is not a valid path. Make sure the path name is spelled correctly and that you are connected to the server on which the file resides".
I assume that the report tries to look for the database where it was at the design stage.
My question is: how can I set the database's path at run time?
Daxxad
November 16th, 2003, 02:47 AM
Hello everyone,in Crystal, when i make a report and preview it it shows al the data, the formules... etc... perfectly, but when i print it fails, dont even enter the queue... and if i print to a pdf (usin pdf writer of adobe acrobat 5) it prints characters of wrong type (like if i type "AAaa" then the text printed is "$$DD") i dont know if its bug, error or what. if someone can help... i use Crystal Reports 9, windows XP (or 2000 sp5) (oh, by the way the windings fonts print like the preview... and all the other apps work fine)
aan_handoko
November 18th, 2003, 11:08 PM
Hello Mr. Babu and dear friends al around the world. I'm new one to Crystal Report. I developed using VB 6.0, Crystal Report 8.5 and SQL Server 2000. Please take a look at my codes below (VB Code and SQL Code - Stored Procedure) :
'The code in VB
Private Sub cmdPrint_Click()
If cmbAccount.Text = "All Account" Then
NoAccount = "%"
Else
NoAccount = cmbAccount.Text
End If
'The code in SQL, I generated CrystalReports1 from this stored procedure which has 3 parameters, using standart expert report wizard. (i'm using "add Crystal Report 8.5" from VB Menu :
This is my store procedure in SQL Server 2000 :
PROCEDURE PrintDeposit
@NoAccount nvarchar(10), @StartDate datetime,
@EndDate datetime
AS
SELECT * FROM Deposit
WHERE NoAccount LIKE @NoAccount AND
(DAY(MarginTime) BETWEEN DAY(@StartDate) AND DAY(@EndDate)) AND
(MONTH(MarginTime) BETWEEN MONTH(@StartDate) AND MONTH(@EndDate)) AND
(YEAR(MarginTime) BETWEEN YEAR(@StartDate) AND YEAR(@EndDate))
Order By MarginTime
Error Message in VB : "The Server has not yet been opened !" and i can not see the report in the viewer!
What did I do wrong? Please note that this is my server info :
data source=aan
user id=aan
password=icandoit
initial catalog=MoneyMall
Please, tell me the answers! I almost blown up to think all these!
Thank U so much for your help!
aan_handoko
November 19th, 2003, 04:25 AM
Mr Babu, or someone else, are you still around to help me.... please, i need the answer very soon.... Please, solve the problem. I'm running out of time here....... Thank You!:(
K.Babu
November 19th, 2003, 06:16 AM
Hi,
1. ParameterFields(n), index should start from 0,1,2,...
Originally posted by aan_handoko
Hello Mr. Babu and dear friends al around the world. I'm new one to Crystal Report. I developed using VB 6.0, Crystal Report 8.5 and SQL Server 2000. Please take a look at my codes below (VB Code and SQL Code - Stored Procedure) :
'The code in VB
Private Sub cmdPrint_Click()
If cmbAccount.Text = "All Account" Then
NoAccount = "%"
Else
NoAccount = cmbAccount.Text
End If
'The code in SQL, I generated CrystalReports1 from this stored procedure which has 3 parameters, using standart expert report wizard. (i'm using "add Crystal Report 8.5" from VB Menu :
This is my store procedure in SQL Server 2000 :
PROCEDURE PrintDeposit
@NoAccount nvarchar(10), @StartDate datetime,
@EndDate datetime
AS
SELECT * FROM Deposit
WHERE NoAccount LIKE @NoAccount AND
(DAY(MarginTime) BETWEEN DAY(@StartDate) AND DAY(@EndDate)) AND
(MONTH(MarginTime) BETWEEN MONTH(@StartDate) AND MONTH(@EndDate)) AND
(YEAR(MarginTime) BETWEEN YEAR(@StartDate) AND YEAR(@EndDate))
Order By MarginTime
Error Message in VB : "The Server has not yet been opened !" and i can not see the report in the viewer!
What did I do wrong? Please note that this is my server info :
data source=aan
user id=aan
password=icandoit
initial catalog=MoneyMall
Please, tell me the answers! I almost blown up to think all these!
Thank U so much for your help!
Kaan
November 19th, 2003, 10:19 AM
Hello Mr. Babu and everyone;
I'm relatively new to CR. I'm using CrustalReportViewer for windows forms to view a report. The report has subreports in it, they are not on-demand so they appear as a large,single,multiple-section report to the user.
When I perform a text search on this report, the data of the subreports are not searched, their titles are searched only. Is it possible to make the find dialog (or crystalreportviewer.SearchForText()) search the whole report?
Thanks everyone in advance
aan_handoko
November 20th, 2003, 12:34 AM
Hi, Mr. Babu. Thanks to reply. I highly appreciate that, really! :). I finally solve my problems. My problem is actually not on my parameterfield index, because I'm starting from 1 is correct, in fact if I started from 0, the error message will be "Subscribe out of range!".
My problem is, I can not connect to the server because I use the wrong method. This is the biggest misunderstood of method. To connect to server, I supposed not to use LogOnServer method. This method works like an active connection in ADO, that made only once, and used for many times. That's why I got error message "Server has not been opened yet!" But i must use SetLogOnInfo method. This syntax of the method is like this (for SQL server) :
report.database.tables(1).SetLogOnInfo Servername as string, databasename as string, userid as string, password as string.
Then I can view my report on viewer. I found this method and the explanation from technical books from this site (if I wish anyone would like to download) :
'For Crystal reports 9 and above :
http://support.crystaldecisions.com/communityCS/TechnicalPapers/cr_rdc9_connectionproperties.pdf
'For version before 9 :
http://support.crystaldecisions.com/communityCS/TechnicalPapers/cr_rdc_dbconnectivity.pdf
Now, Mr. Babu, how is the way to set up some text during the run time. Let's say, I have a text that I must set according to the user's choice (this text will be on the Report header section). For example : if the user choose all branch (from combo box in VB), the text will be printed all branch, if the user choose Surabaya, the text will be printed "Surabaya". How do I set this? Thank You for answering. I do really happy to join this forum with you and all friends around the world. I'm waiting for your reply! Thank You once again!
:cool:
K.Babu
November 21st, 2003, 02:29 AM
Hi,
1. Insert the formula field in crystal report design mode.
2. Validate the string value for the formula field in vb run mode.
eg.
if the user choose all branch
CrystalReport1.Formulas(0) = "MyFormula = 'all branch'"
Else,
CrystalReport1.Formulas(0) = "MyFormula = 'Surabaya'"
Originally posted by aan_handoko
Hi, Mr. Babu. Thanks to reply. I highly appreciate that, really! :). I finally solve my problems. My problem is actually not on my parameterfield index, because I'm starting from 1 is correct, in fact if I started from 0, the error message will be "Subscribe out of range!".
My problem is, I can not connect to the server because I use the wrong method. This is the biggest misunderstood of method. To connect to server, I supposed not to use LogOnServer method. This method works like an active connection in ADO, that made only once, and used for many times. That's why I got error message "Server has not been opened yet!" But i must use SetLogOnInfo method. This syntax of the method is like this (for SQL server) :
report.database.tables(1).SetLogOnInfo Servername as string, databasename as string, userid as string, password as string.
Then I can view my report on viewer. I found this method and the explanation from technical books from this site (if I wish anyone would like to download) :
'For Crystal reports 9 and above :
http://support.crystaldecisions.com/communityCS/TechnicalPapers/cr_rdc9_connectionproperties.pdf
'For version before 9 :
http://support.crystaldecisions.com/communityCS/TechnicalPapers/cr_rdc_dbconnectivity.pdf
Now, Mr. Babu, how is the way to set up some text during the run time. Let's say, I have a text that I must set according to the user's choice (this text will be on the Report header section). For example : if the user choose all branch (from combo box in VB), the text will be printed all branch, if the user choose Surabaya, the text will be printed "Surabaya". How do I set this? Thank You for answering. I do really happy to join this forum with you and all friends around the world. I'm waiting for your reply! Thank You once again!
:cool:
Cyrus
November 21st, 2003, 09:21 AM
I created a parameter passing in crystal reports so user can enter what records need to be printed i.e idnumber, is there a way to capture the parameter passed to a textbox.
10x
cyrus
alfiya
November 21st, 2003, 05:17 PM
Hi,
I am trying to use a Crystal Report Viewer Control 9 (that comes with Crystal Reports 9 Developers Vs) in my VB.NET application.
I have Crystal Reports 9.0 developers installed on my development machine, so I think I have all of the necessary dlls.
In my project, I got into toolbox - Components, browse to add Crystal Report Viewer Control 9 to my components list(crviewer9.dll).
I put the control on my form,
Friend WithEvents AxCRViewer92 As AxCRVIEWER9Lib.AxCRViewer9
it's initialized,
and then I add my own code to view the report after the user selects the report from the dialog box:
it all compiles,
but when I run this app, first of all, my control comes up on the screen as a white rectangle.
and after I try to open the report, I get the following:
An unhandled exception of type 'System.InvalidCastException' occurred in axinterop.crviewer9lib.dll
Additional information: No such interface supported
I'm new to Crystal Reports, and I would really appreciate any help on using this Crystal Report Viewer Control 9. So far, I hasn't been able to find any info about it from Crystal Decisions. I need to use this control, and not the CrystalReportsViewer that comes with .NET because of some internal company issues.
Thanks.
kristine2002
November 22nd, 2003, 02:50 AM
Im using Crystal report 8 and VB6, my problem is how can i make the Crystal report get the record from the recordset i made. The problem is when i run the report it shows all the record from the table. How can i make the report show only the content of the recordset?
Below is the code im using. dcCategory is datacombo.
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Set cnn = New ADODB.Connection
cnn.Open "File name=c:\Product.udl"
Set rst = cnn.Execute("select item_no,item_category,Item_desc,Item_unit,item_price from tblitems where item_Category ='" & dcCAtegory.Text & "'")
Dim crystal As CRAXDRT.Application
Dim treport As CRAXDRT.Report
When i design the report using crystal report designer i use the table as the datasource and i did not set anything else. Could this be the problem?
Thanks in advance!!!
aan_handoko
November 27th, 2003, 12:05 AM
Hello Babu, thanks for your last help. Even if the property dosn't match at all (I'm using property of report.formulafields(1).text to set the formula) but it does gave me the idea. thanks a lot :)
Now, I'm having a new problem. When I tried to package and deploy my VB-Project that contains CR inside, I found that there is "nothing happened", means that in the Package folder, the Package and Deployment Wizard doesn't make any files for installation setup, not even one!!!!
But when I try to package a project that doesn't contain CR inside, it does works! Why so strange?
Please notice that I'm using Crystal report 8.5, Visual basic 6.0 SP 5. Why the package and deployment wizard doesn't work for my project with cr inside? Please, reply this soon... I'm also surfing to another web to get the answers... thank you!
Regards
Aan Handoko
K.Babu
November 27th, 2003, 01:40 AM
Hi,
Yes, I also face the same problem, which you mention bellow regarding package wizard, I don't want to R&D why package wizard not support that, so that, i written the setup script in Install Shield.
You can try by change the VB setup project manually. you have to Include all the crystal report runtime files in cab file. which is mentioned in Crystal Report Developer Runtime help document.
Note: Keep in mind, what are the files you have to register with regsvr32.exe, This details are mentioned in Developer runtime help document file.
Thanks,
K.Babu.
Originally posted by aan_handoko
Hello Babu, thanks for your last help. Even if the property dosn't match at all (I'm using property of report.formulafields(1).text to set the formula) but it does gave me the idea. thanks a lot :)
Now, I'm having a new problem. When I tried to package and deploy my VB-Project that contains CR inside, I found that there is "nothing happened", means that in the Package folder, the Package and Deployment Wizard doesn't make any files for installation setup, not even one!!!!
But when I try to package a project that doesn't contain CR inside, it does works! Why so strange?
Please notice that I'm using Crystal report 8.5, Visual basic 6.0 SP 5. Why the package and deployment wizard doesn't work for my project with cr inside? Please, reply this soon... I'm also surfing to another web to get the answers... thank you!
Regards
Aan Handoko
K.Babu
November 27th, 2003, 02:37 AM
Hi,
You can't assign report file name directly to reportsource.
me.AxCRViewer92.ReportSource = dlg.FileName
Use the following code sample
Dim crrpt As New CRAXDRT.Report
Dim crapp As New CRAXDRT.Application
Originally posted by alfiya
Hi,
I am trying to use a Crystal Report Viewer Control 9 (that comes with Crystal Reports 9 Developers Vs) in my VB.NET application.
I have Crystal Reports 9.0 developers installed on my development machine, so I think I have all of the necessary dlls.
In my project, I got into toolbox - Components, browse to add Crystal Report Viewer Control 9 to my components list(crviewer9.dll).
I put the control on my form,
Friend WithEvents AxCRViewer92 As AxCRVIEWER9Lib.AxCRViewer9
it's initialized,
and then I add my own code to view the report after the user selects the report from the dialog box:
it all compiles,
but when I run this app, first of all, my control comes up on the screen as a white rectangle.
and after I try to open the report, I get the following:
An unhandled exception of type 'System.InvalidCastException' occurred in axinterop.crviewer9lib.dll
Additional information: No such interface supported
I'm new to Crystal Reports, and I would really appreciate any help on using this Crystal Report Viewer Control 9. So far, I hasn't been able to find any info about it from Crystal Decisions. I need to use this control, and not the CrystalReportsViewer that comes with .NET because of some internal company issues.
Thanks.
K.Babu
November 27th, 2003, 03:16 AM
Hi,
Instead of parameter, display dialog form with text box for user interface, and then pass the value to "parameter" Or "formulas" to crystal report.
Originally posted by Cyrus
I created a parameter passing in crystal reports so user can enter what records need to be printed i.e idnumber, is there a way to capture the parameter passed to a textbox.
10x
cyrus
aan_handoko
November 28th, 2003, 02:18 AM
Hello K.Babu, I've tried your suggestion. These files : craxdrt.dll, craxddrt.dll, crpe32.dll crviewer32.dll, crystl32.ocx, rdwiz.dll had been included in the list of files to be installed. But after I've tried, the error message is "Physical database not found" Can you find out, which file that I missed to be included in my installation files.. Eh, I 've also tried to install crystal report 8.5 to the destination computer and my program was working. I think, there must be a file or some files that I missed, like I mention above. Can you tell me which file is it, according to error message " Physical database not found"? Thank you for your kindly help!
Regards,
Aan H.
Originally posted by K.Babu
Hi,
Yes, I also face the same problem, which you mention bellow regarding package wizard, I don't want to R&D why package wizard not support that, so that, i written the setup script in Install Shield.
You can try by change the VB setup project manually. you have to Include all the crystal report runtime files in cab file. which is mentioned in Crystal Report Developer Runtime help document.
Note: Keep in mind, what are the files you have to register with regsvr32.exe, This details are mentioned in Developer runtime help document file.
Thanks,
K.Babu. :rolleyes: :rolleyes:
K.Babu
November 28th, 2003, 03:12 AM
Hi,
I think you are using RDC Method, that's no required crystl32.ocx, Find out the RDC Method Engine Runtime Requirement Files.
IF you have not, i will give you ok.
Regards,
K.Babu
Originally posted by aan_handoko
Hello K.Babu, I've tried your suggestion. These files : craxdrt.dll, craxddrt.dll, crpe32.dll crviewer32.dll, crystl32.ocx, rdwiz.dll had been included in the list of files to be installed. But after I've tried, the error message is "Physical database not found" Can you find out, which file that I missed to be included in my installation files.. Eh, I 've also tried to install crystal report 8.5 to the destination computer and my program was working. I think, there must be a file or some files that I missed, like I mention above. Can you tell me which file is it, according to error message " Physical database not found"? Thank you for your kindly help!
Regards,
Aan H.
:rolleyes: :rolleyes:
napoleao
December 1st, 2003, 06:46 AM
hello :rolleyes:
i m using vb6 and cr9
i need to automatic print a report to a printer
Private Sub Form_Load()
Dim mum As Integer
num = Vendas_clientes.txtID_VENDA.Caption
num = num + 0
Screen.MousePointer = vbHourglass
If Not (Report.ParameterFields.item(1).CurrentValue = num) Then
Report.ParameterFields.item(1).AddCurrentValue (num)
how can i based on the printer name (but if need more information is easy aquired)
select a printer for the report to be printed in runtime
i have selected a specifeid printer for each report but i may need to print the report to a network printer and same times a local printer
i easaly get the printer names
Dim pr As Printer
'
'
'
'Private Sub CmdPrinter_Click()
' For Each pr In Printers
' Combo1.AddItem pr.DeviceName
' Next
'End Sub
now i need to send the report for one of the printers
tks for your help
and keep on the good work you have done
Qatester
December 1st, 2003, 10:07 AM
Two questions:
1. I have a field in an Access database that is a Date/Time field and contains times. When I add this field to my Crystal Report it is displayed as a date instead of a time. How do I change the formatting?
2. The report has a summary field that adds all of the minutes that have elapsed but because the field is a numeric field, rather than a time field, the summary will show things like 253 minutes. How can I get the report to calculate minutes before printing?
The version of Crystal I am using is 4.6.1.0
Thanks
codeguru.com
Copyright WebMediaBrands Inc., All Rights Reserved.