Crystal Report

[K.Babu]

Hi,

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

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
shuzz7@yahoo.com

[K.Babu]

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.

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?

[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

[K.Babu]

Hi,

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

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

[atul_tak]

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

[K.Babu]

Hi,

Save Print output to .prn file,

do the following command in DOS Mode

C:\>copy myfile.prn lpt1

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

[thienloclt]

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

[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!

[K.Babu]

Refer

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

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!

[thienloclt]

Hi K.Babu,

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

[K.Babu]

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"

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

[K.Babu]

PDSODBC.DLL".

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

Originally posted by thienloclt
Hi K.Babu,

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

[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.

[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-

[K.Babu]

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.

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.