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 ?
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
Last edited by K.Babu; October 28th, 2003 at 06:44 AM.
Please avoid sending emails to my personal mail:
write your doubts as thread in Codeguru
Crystal Reports Forum.
This will help all people having similar matters, and will let people who know solutions on the specific topic
share their knowledge.
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.
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!!
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.
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
Last edited by Shafan; November 9th, 2003 at 04:23 AM.
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.
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.
* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.