Crystal Report

When using a record selection formula on a large database table (~60,000 records) it takes several minutes for the CRViewer to come up if it is searching for more than one record. If I remove the record selection formula and just let it do the whole MS Access Table I get the same slow response. The report is not a simple one. I am using the Crystal Report ActiveX Designer within my VB application because there are two different pictures that get loaded onto each report. The report uses info from four tables and also contains a subreport. If the recordselectionformula states a field and a unique value that only returns one record the report comes up in seconds. If two or more records meet the recordselectionformula then it takes several minutes. If you have any thoughts on how to improve its performance please let me know.

Hello babu.

Please help me how i can access password protected database in crystal reports 8.0 with vb6 .how i can pass password at runtime to crystal reports please answer me soon.

Thanx in Advance.
Nazim

I manually added a new column in my XML file.

I put it in both my schema and in the data section.

The new column does not show up in field explorer even though I disconnected and reconnected to the database, as well as, leaving and restarting Crystal.

Any ideas?

Thanks
Gary

Never Mind.

My bad.

I had to choose verify database from the database menu for it to see the changed XML schema.

hi

Use the following small code to access login and password from crystal report.

crCommon.LogonInfo(0)= "dsn=;uid=;pwd=Hello;dsq="
crCommon.DataFiles(0)= "C:\Mydata.mdb"

yours friendly,
k.Babu

Quote:

---

Originally posted by nazimocp
Hello babu.

Please help me how i can access password protected database in crystal reports 8.0 with vb6 .how i can pass password at runtime to crystal reports please answer me soon.

Thanx in Advance.
Nazim

---

hi Friends,

Make sure your database path was correct, when using "verify database" this may change the database full path of the report file.

This will cause problem when at distribute other computers.

yours friendly,
K.Babu

Quote:

---

Originally posted by ghoran
Never Mind.

My bad.

I had to choose verify database from the database menu for it to see the changed XML schema.

---

hi Friends,

Use stored query from your database, filter records using with parameters(), This will filter number of records when at using crystal report.

yours friendly,
k.Babu

Quote:

---

Originally posted by masonad
When using a record selection formula on a large database table (~60,000 records) it takes several minutes for the CRViewer to come up if it is searching for more than one record. If I remove the record selection formula and just let it do the whole MS Access Table I get the same slow response. The report is not a simple one. I am using the Crystal Report ActiveX Designer within my VB application because there are two different pictures that get loaded onto each report. The report uses info from four tables and also contains a subreport. If the recordselectionformula states a field and a unique value that only returns one record the report comes up in seconds. If two or more records meet the recordselectionformula then it takes several minutes. If you have any thoughts on how to improve its performance please let me know.

---

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

Hello babu ,

from where i can download crystal report ...

could you give me links ?


thankx ,,,

Does anyone have an sample to show me how it works with visual c++?

HI ,
i want to send array to crystal reports to print some information. Is it possible to pass an array to crystal report ?
plz suggest.

piter

Hi,

When i want to print a report, windows nt tells me that crpaige(32).dll not found on path.

i put file named crpaig32.dll in system path. I try to register it by regsvr32 but DllRegisterServer entry point was not found. I imagine that this dll have not to be registered.

I don't known how to correct the problem since i use visual basic 6 instead of 5 version.

The problem appear only on client station where my soft is installed by Package deployment, there is no problem on the development computer.

Thanks for your help

I have a problem. While using Crystal reports 4.6 with VB 6, I have to print a recipt with just one record. At times Crystal report shows an empty report. If I debug the report activation in VB, it works fine. I increase the time gap between the record fetching and report activation, i have put a loop of doevents: but still it fails at times. What do I do?:confused:

hi babu, i have the same problem as i want to add image of parties on report . as you told to put picture field..does it mean the field from my table or from insert menu of crystal report.

plz help.
Zankhesh

Quote:

---

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: [email protected]

---

hi babu, i have the same problem as i want to add image of parties on report . as you told to put picture field..does it mean the field from my table or from insert menu of crystal report.

as i am using the ms-access2000 as back-end and it that for ole data type it just store some number for any picture and if i put that picture fields from table the same number is visible in report in stead of actual image...
plz help.
Zankhesh

Quote:

---

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: [email protected]

---

I have a vb .dll that invokes the crystal report view .OCX to view
reports before exporting them. I have added an 'export' button that
runs the following code:


m_oRpt.ExportOptions.Reset

m_oRpt.ExportOptions.PromptForExportOptions

'If the destinationType is not set then cancel must have been
pushed
If m_oRpt.ExportOptions.DestinationType <> crEDTNoDestination Then
m_oRpt.Export False
End If

The preview correctly displays the intended report and on dev system
this code runs fine.

On the site however there are two systems, a test system and a live
system. They both use different databases but the ODBC connection name is the same for each. The reports were developed on the live system and they work
fine on that system.

On the test system however, when the user exports the report (chooses .pdf
format, all pages, and a filename), the report fails to export and an
error is generated:

'No pages were exported'

This is even though the preview correctly displays the report and data.

In addition, if the report is *not* previewed ie the report viewer is
not loaded but the report just exported, it works fine.

Can anyone shed some light as to what this error message means and how
to fix it?

Thanks

Lindsay

hi friends,

Both can be posible, if you had table with generalOLE field you can use the field directly to the crystal report to view the pictures.

Quote:

---

Originally posted by zjain
hi babu, i have the same problem as i want to add image of parties on report . as you told to put picture field..does it mean the field from my table or from insert menu of crystal report.

plz help.
Zankhesh

---

Hi!

I have a bit of problems when I try to pass a string(in C#, about 10000 characters) to a parameter field. It seems like the maximum datasize of a field is 255 characters. Is there any other way to pass dynamical data from a C# program and into the Crystal report.

Why do I want to do this? The report is supposed to show some kind of a program log so there is not a static amount of data. There is no database in the background of this program. The program itself collects the log data in its memory and then I want to pass it to the report.

All help and tips appreciated :)

/Anders


P.s I'm using the .Net Crystal Report together with C# D.s

Hi,

if you want to pass more data to crystal report

Make the formula field given bellow concept

1. Fulldata
2. Data1
3. Data2
4. Data3
...

in Crystal report design time mode insert FullData formula field and add all the data1+data2+data3.

Note: This is one of the simplest way to pass more data, But it was not recommended for huge blob data.

Quote:

---

Originally posted by Anders Jansson
Hi!

I have a bit of problems when I try to pass a string(in C#, about 10000 characters) to a parameter field. It seems like the maximum datasize of a field is 255 characters. Is there any other way to pass dynamical data from a C# program and into the Crystal report.

Why do I want to do this? The report is supposed to show some kind of a program log so there is not a static amount of data. There is no database in the background of this program. The program itself collects the log data in its memory and then I want to pass it to the report.

All help and tips appreciated :)

/Anders


P.s I'm using the .Net Crystal Report together with C# D.s

---

Hi,

You have to install files which type of export format you have choosen, for eg. if you want to export option for pdf format at run time you should install pdf export related file in your testing machine

for more details refer the crystal report documentation for destribute files

Quote:

---

Originally posted by lsmith
I have a vb .dll that invokes the crystal report view .OCX to view
reports before exporting them. I have added an 'export' button that
runs the following code:


m_oRpt.ExportOptions.Reset

m_oRpt.ExportOptions.PromptForExportOptions

'If the destinationType is not set then cancel must have been
pushed
If m_oRpt.ExportOptions.DestinationType <> crEDTNoDestination Then
m_oRpt.Export False
End If

The preview correctly displays the intended report and on dev system
this code runs fine.

On the site however there are two systems, a test system and a live
system. They both use different databases but the ODBC connection name is the same for each. The reports were developed on the live system and they work
fine on that system.

On the test system however, when the user exports the report (chooses .pdf
format, all pages, and a filename), the report fails to export and an
error is generated:

'No pages were exported'

This is even though the preview correctly displays the report and data.

In addition, if the report is *not* previewed ie the report viewer is
not loaded but the report just exported, it works fine.

Can anyone shed some light as to what this error message means and how
to fix it?

Thanks

Lindsay

---

Hi,

Disable Stored Data with Report option in your crystal report design mode, and refresh preview data.

Quote:

---

Originally posted by zjain

as i am using the ms-access2000 as back-end and it that for ole data type it just store some number for any picture and if i put that picture fields from table the same number is visible in report in stead of actual image...
plz help.
Zankhesh

---

Hi,

Make sure the problem was only for the time delay, Are you sure with that don't use "doevents" use API Delay or use timer control for a time delay show wait screen form, after release the timer control, view the crystal report.

Quote:

---

Originally posted by amyn_d
I have a problem. While using Crystal reports 4.6 with VB 6, I have to print a recipt with just one record. At times Crystal report shows an empty report. If I debug the report activation in VB, it works fine. I increase the time gap between the record fetching and report activation, i have put a loop of doevents: but still it fails at times. What do I do?:confused:

---

Thanks for your answer Babu. :)

Do you know any other solution as I do have huge blob data :(

/Anders

hi,

im workin on a invoicing program , i was told to make the current reports fit in the pre-printed invoice paper.

the problem is:

as i print jus one invoice i ill turn out ok,
but if i print more than 4 invoices, the report will slowly start going down just a little bit each invoice so when it gets to the 4 invoice the printed report will be off like for a line...

dont know if i explained well enough,

ex:
1 invoice:
________________________

[notice there are two lines]
zzzzz
qwqqwe
fgdddfd

{details}
totals
_________________________
2 invoice:
_________________________


zzzzz
qwqqwe
fgdddfd

{details}
totals
_________________________
3 invoice:
_________________________


zzzzz
qwqqwe
fgdddfd

{details}
totals
_________________________
4 invoice:
_________________________
[notice there is just one line now]
zzzzz
qwqqwe
fgdddfd

{details}
totals
_________________________

if any of you know how to solve this or has any ideas...
please let me know
[email protected]

Hi, Babu, look, i got this problem: I have built an application in VB6 with crystal report 8.0. the report works fine, but when trying to export it (.xls, .doc, and others..) using the envelope button, it seems to be exporting but it does nothing. Only i get is a file 0 bytes long. Any ideas?

Hi,

Measure your preprinted invoice height, change page setting to custom (width/height) at crystal report design time.

Quote:

---

Originally posted by shuzz
hi,

im workin on a invoicing program , i was told to make the current reports fit in the pre-printed invoice paper.

the problem is:

as i print jus one invoice i ill turn out ok,
but if i print more than 4 invoices, the report will slowly start going down just a little bit each invoice so when it gets to the 4 invoice the printed report will be off like for a line...

dont know if i explained well enough,

ex:
1 invoice:
________________________

[notice there are two lines]
zzzzz
qwqqwe
fgdddfd

{details}
totals
_________________________
2 invoice:
_________________________


zzzzz
qwqqwe
fgdddfd

{details}
totals
_________________________
3 invoice:
_________________________


zzzzz
qwqqwe
fgdddfd

{details}
totals
_________________________
4 invoice:
_________________________
[notice there is just one line now]
zzzzz
qwqqwe
fgdddfd

{details}
totals
_________________________

if any of you know how to solve this or has any ideas...
please let me know
[email protected]

---

Hi,

Make sure all the crystal report export envelope option fails or not, if it's all export fails this may export related files correption reinstall crystal report and then try again.

Quote:

---

Originally posted by VTDrakull
Hi, Babu, look, i got this problem: I have built an application in VB6 with crystal report 8.0. the report works fine, but when trying to export it (.xls, .doc, and others..) using the envelope button, it seems to be exporting but it does nothing. Only i get is a file 0 bytes long. Any ideas?

---

hi Babu,

i already set the size of the paper, but the printer on the first invoice at the begining of the page will make a little jump...
like this::


-------------------------------------top of the page[the cut]
[this one line is the one that the printer makes]
start of the printing



-------------------------------------top of the page[not he cut,
start of the printing [here it starts printing]



thanks again..
Esteban Rojas

Hi,

Hide report title, summay sections. make sure your printer configuration preload lines are correctly set in first(zero) row.

Quote:

---

Originally posted by shuzz
hi Babu,

i already set the size of the paper, but the printer on the first invoice at the begining of the page will make a little jump...
like this::


-------------------------------------top of the page[the cut]
[this one line is the one that the printer makes]
start of the printing



-------------------------------------top of the page[not he cut,
start of the printing [here it starts printing]



thanks again..
Esteban Rojas

---

i am also using crystal report ..
but dont know how to print report in dos mode
can u help me sir
plz

Hi,

Save Print output to .prn file,

do the following command in DOS Mode

C:\>copy myfile.prn lpt1

Quote:

---

Originally posted by atul_tak
i am also using crystal report ..
but dont know how to print report in dos mode
can u help me sir
plz

---

Please help me how to crystal report connect to database(SQL Server) within code Visual Basic.
Thanks!

Please help me how to crystal report connect to database (SQL Server) within code Visual Basic.

Ex:
in MS Access:
crCommon.LogonInfo(0)= "dsn=;uid=;pwd=madras;dsq="
crCommon.DataFiles(0)= "C:\Mydata.mdb"

in SQL Server?
crCommon.LogonInfo(0)= ?
crCommon.DataFiles(0)= ?

Login info:
Server name: THIENLOC
Database name: PAYROLL
UserID: sa
Password:

Thanks!

Refer

cr.LogonServer (dllName$, ServerName$, DatabaseName$, UserID$, Password$)

Quote:

---

Originally posted by thienloclt
Please help me how to crystal report connect to database (SQL Server) within code Visual Basic.

Ex:
in MS Access:
crCommon.LogonInfo(0)= "dsn=;uid=;pwd=madras;dsq="
crCommon.DataFiles(0)= "C:\Mydata.mdb"

in SQL Server?
crCommon.LogonInfo(0)= ?
crCommon.DataFiles(0)= ?

Login info:
Server name: THIENLOC
Database name: PAYROLL
UserID: sa
Password:

Thanks!

---

Hi K.Babu,

Please tell me what is the "dllname$"?
Would you give me a example of "dllname$"?
Thanks!

Logs on to a SQL server.

Usage

[form.]Report.Connect[= Name;UserID;Password;DatabaseQualifier$]
For example:

Report1.Connect = "DSN = Accounting;UID = 734;PWD = bigboard;DSQ = Administration"

Quote:

---

Originally posted by thienloclt
Please help me how to crystal report connect to database(SQL Server) within code Visual Basic.
Thanks!

---

PDSODBC.DLL".

PDB*.DLL for standard (nonSQL) databases
PDS*.DLL for SQL/ODBC databases.

Quote:

---

Originally posted by thienloclt
Hi K.Babu,

Please tell me what is the "dllname$"?
Would you give me a example of "dllname$"?
Thanks!

---

hi Mr. Balu,

i am working with a VB/Crystal Reports project. I want to print payslips using Crystal Reports. My problem is it is becoming difficult for me to contain some payslips in one page. Payslip has 3 sections a group header, Details and group section. All the 3 sections should be together. The "Keep Together" property is not working. how do i do this? how can i force a page break whenever i need while printing?

please help. thanks in advance.

Hello Babu,

I was wondering if there is a way that I could type in some text in VB 6.0 and post that data from a Textbox into a field or label in a Crystal Reports Page/Report Header?


Thanks,
John-

Hi,

Right Click the Format Section and tick the option check box called as "New Page After"

Keep Together the option scope for current section.

Quote:

---

Originally posted by N Vikram
hi Mr. Balu,

i am working with a VB/Crystal Reports project. I want to print payslips using Crystal Reports. My problem is it is becoming difficult for me to contain some payslips in one page. Payslip has 3 sections a group header, Details and group section. All the 3 sections should be together. The "Keep Together" property is not working. how do i do this? how can i force a page break whenever i need while printing?

please help. thanks in advance.

---

Cr.BoundReportHeading = "Report Title Message"

Quote:

---

Originally posted by vbjohn
Hello Babu,

I was wondering if there is a way that I could type in some text in VB 6.0 and post that data from a Textbox into a field or label in a Crystal Reports Page/Report Header?


Thanks,
John-

---

hi,
I designed file .rpt in crystal report (add in) within VisualBasic

Currently, crystal report shows following form:

Order_Code Quantity
ma001 10
ma001 5
ma001 7
ma002 8
ma002 12

How to crystal report will show following form (group):

Order_Code Quantity
ma001 10
5
7
ma002 8
12

Thansks.

Hi,

a. Insert Group Section for Order_Code

1. Paste the order_code field in "order_coder header section"

b. In Details section paste the quantity field.

Quote:

---

Originally posted by thienloclt
hi,
I designed file .rpt in crystal report (add in) within VisualBasic

Currently, crystal report shows following form:

Order_Code Quantity
ma001 10
ma001 5
ma001 7
ma002 8
ma002 12

How to crystal report will show following form (group):

Order_Code Quantity
ma001 10
5
7
ma002 8
12

Thansks.

---

Hi,
1.
Please help me solve bug:
I have code:
If crystal.LogOnServer("PDSODBC.DLL", "MQIS", "PAYROLL", "SA", "") Then
crystal.ReportFileName = App.Path & "\reports\" & "contact.rpt"
crystal.Action = 1
End If

on line "crystal.Action = 1" --> error: "Cannot open SQL Server"

2. What are differences between cr.Connect and cr.LogOnServer?

Thanks!

Hi,
Please help me!
I have SQL statement:

SELECT e1.FullName, (SELECT e2.FullName FROM EmployeeTb AS e2 WHERE e2.EmployeeId = a1.AppraiserId) AS AppraiserName
FROM EmployeeTb e1 INNER JOIN AppraisalTb a ON e1.EmployeeId = a.EmployeeId

How to I design in crystal report to show following form:

EmployeeName AppraiserName
A C
B E
C
D F
E A
F

Thanks!

I tried...

Cr.BoundReportHeading = "Report Title Message"

But nothing printed on the report. I think you kind of mis-understood what I was going for...

As you can see on the .gif image. Where it says *testing* I need to have text in a textbox in VB and post that text into a field or label in a Crystal Reports Page/Report Header?

I hope this clears things up more.


John-

Hi,

"Connect" is cr property which is log on to SQL Servre, it must required ODBC driver

"LogonServer" is a method it returns connection id, This connection id used for "LogoffServer" method. you can use DSN ODBC Data Source here.

Quote:

---

Originally posted by thienloclt
Hi,
1.
Please help me solve bug:
I have code:
If crystal.LogOnServer("PDSODBC.DLL", "MQIS", "PAYROLL", "SA", "") Then
crystal.ReportFileName = App.Path & "\reports\" & "contact.rpt"
crystal.Action = 1
End If

on line "crystal.Action = 1" --> error: "Cannot open SQL Server"

2. What are differences between cr.Connect and cr.LogOnServer?

Thanks!

---

Create formula fields in crystal report design time

eg. RepTitle (assume your formula field name is RepTitle)

in vb

cr.formulas(0) = "RepTitle = 'Hello world'"

Quote:

---

Originally posted by vbjohn
I tried...

Cr.BoundReportHeading = "Report Title Message"

But nothing printed on the report. I think you kind of mis-understood what I was going for...

As you can see on the .gif image. Where it says *testing* I need to have text in a textbox in VB and post that text into a field or label in a Crystal Reports Page/Report Header?

I hope this clears things up more.


John-

---

hi K.Babu,

I designed file .rpt in crystal report (add in) within VisualBasic

Currently, crystal report shows following form:

Order_Code ------------------------- Quantity
ma001 -------------------------------- 10
ma001 -------------------------------- 5
ma001 -------------------------------- 7
ma002 -------------------------------- 8
ma002 -------------------------------- 12

How to crystal report will show following form (group):

Order_Code ------------------------- Quantity
ma001 -------------------------------- 10
------------------------------------------ 5
------------------------------------------ 7
ma002 -------------------------------- 8
------------------------------------------ 12

Thansks.

Hi,

1. method:
Right Click the Order_Code field, click the change format, tick the suppress if duplicated option check box.

2. method:
Create new Group for Order_Code field in crystal report design mode, insert the order_code field in new created order_code group.

Quote:

---

Originally posted by thienloclt
hi K.Babu,

I designed file .rpt in crystal report (add in) within VisualBasic

Currently, crystal report shows following form:

Order_Code ------------------------- Quantity
ma001 -------------------------------- 10
ma001 -------------------------------- 5
ma001 -------------------------------- 7
ma002 -------------------------------- 8
ma002 -------------------------------- 12

How to crystal report will show following form (group):

Order_Code ------------------------- Quantity
ma001 -------------------------------- 10
------------------------------------------ 5
------------------------------------------ 7
ma002 -------------------------------- 8
------------------------------------------ 12

Thansks.

---