Re: Re: Re: Clarification needed ... to Babu
hi..
I use Oracle has a Database .... so I left the DSQ portion,
What else i should do...
Quote:
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]
Checkboxes in Crystal Reports ?
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
Re: Exporting Crystal Report
This problem is solved
Thanks
Quote:
Originally posted by SayliJoshi
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 am pasting code.
ReportDocument crReportDocument =new ReportDocument();
crReportDocument.Load"C:\\Inetpub\\wwwroot\\HR\\SkillMatrix.rpt");
CRSkillReport.ReportSource = crReportDocument;
ExportOptions exportOpts = new ExportOptions();
DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
exportOpts = crReportDocument.ExportOptions;
exportOpts.ExportFormatType = ExportFormatType.Excel;
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
diskOpts.DiskFileName = "c:\\abc.xls";
exportOpts.DestinationOptions = diskOpts;
try
{
crReportDocument.Export ();
}
catch (Exception err1)
{
Response.Write("<br>");
Response.Write(err1.Message.ToString());
}
Thanks
1 Attachment(s)
View Pictures from database.Table.field contains picture filename with path.
Dear Friends,
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
Open Crytal file in ASP Page
Hi,
how to open the Crystal report in the ASP page..
thanx in adv..
Venu
Sample VB Code for Export PDF Format from Crystal Report 8.5 in VB at Run Mode.
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?
Code:
Dim crrpt As New CRAXDRT.Report
Dim crapp As New CRAXDRT.Application
Set crrpt = crapp.OpenReport("C:\Projects\quotation.rpt")
crrpt.Database.Tables(1).Location = "C:\Projects\BrCusinfo.mdb"
crrpt.Database.Tables(1).SetLogOnInfo "CRSS", "BrCusinfo.mdb", "Admin", "hello"
crrpt.RecordSelectionFormula = "{quequotation.QuotationNo} = " & 58
crrpt.ExportOptions.ApplicationFileName = "C:\Projects\expquotation.pdf"
crrpt.ExportOptions.DestinationType = crEDTApplication
crrpt.ExportOptions.DiskFileName = "C:\Projects\expquotation.pdf"
crrpt.ExportOptions.PDFExportAllPages = True
crrpt.ExportOptions.FormatType = crEFTPortableDocFormat
crrpt.Export False
'Remarked Viewer Report Output
'CRViewer1.ReportSource = crrpt
'CRViewer1.ViewReport
NET Crystal Reports Login Text Database
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 :(((((
Error returned: 20614 meaning: Starting
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:
Error returned: 20614 meaning: Starting
background processing failed
Here is how I got this error
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
changing the default display for Boolean fields in Crystal Reports **RESOLVED**
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