Crystal Report

[K.Babu]

Dear All,

If you have any doubt in Seagate Crystal Reports contact me, i will help you my level best.

Babu


Present EMail : kbabu@qmaxtest.com
Permanent EMail : k_babs@hotmail.com
WebSite : qmaxtest.com

[tsl]

Hi,
How to send a crystal report directly to printer by using ASP.
Thanks.

[K.Babu]

hi

use property Destination = 1(to printer) this will send output directly to printer without preview screen.

Babu.

MailID: k_babs@hotmail.com

[Bezzie]

Hi

How do I open a password protected .mdb database in Crystal when the report is called from a VB application. I can't get it opened.


Bezzie

[theghost]

this is not an answer. If you get an answer to your problem could you please forward it to me. i am also intrested in creating an opening a .mdb database with a password from my vb code. From what I read (your question) it souds like you are already doing this. thanks

theghost@bellsouth.net

[K.Babu]

hi

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

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

MailID: k_babs@hotmail.com

[Bezzie]

Thanks

I get it to work with reports that hasn't got subreports in them but the ones with subreports still crashes. How will i get them to work.

Bezzie

[NasirAbbas]

I want to build a report on the basis of sql server 2000 udf which is a parameterized function directly without involing any stored procedure in.. problem is that normal driver of sql server does not recognize function .. and if i used ado or other drivers it does not give any parameters instead it allowed me to write a Query like
select * from aUDFunction ('01-Jul-2001', '30-Jun-2002') and all the times this working with the same values ... I am working in VB now a days.. I also tried to change the Query by SQLQuery property of OCX Control but a report create with ADO etc does not allow to use this Property... Please Help.. Thanx.. Nasir

AITG

[K.Babu]

hi,
Normally, SqlQuery Property accurs any error in your Sql statement it will skip and reset the default design value.

In SqlQuery Property you can't change the select columns, you can changle only FROM WHERE GROUP Class.

Thanks,
K.Babu

MailID: k_babs@hotmail.com

[Rita Leoci]

I need to print bitmap for any products on a catalog. The database (file .dbf) field contents the path of the bitmaps.
Is it possible to print the bitmap for the products from Crystal Report 5.0.
If yes, how can I do ?
thanks

[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

[programmer_in_la]

I am having problem designing crystal report using a generic printer driver.
The fields shown ok viewing on the screen, but when print out, the data is out of place.

Example
Field 1 on line 4 printed on line 3.

Any suggestions?

[nvm]

I want to design a report with unicode data.
My datatbase use unicode).
but Crystal report use ANSI.
Help me,
Thank you.

[K.Babu]

hi,

Try changing fonts, Printer font or windows Courier New font.

yours,
K.Babu

MailID: k_babs@hotmail.com

[K.Babu]

hi,

if your database support ODBC Driver, you can use ODBC DSN name in crystal report.

yours,
K.Babu

MailID: k_babs@hotmail.com