Visual Basic :: How To Display Crystal Report

Display Image On Crystal Report
i need to display an image on a crystal report. the report will print the image without being viewed by the user when a button is clicked. i have tried doing this using a dataset and xml schema, but it is not working. below is some of the code i was using. can someone please help?
Dim ds As New DataSet
Dim dt As New DataTable
Dim values(0) As Object
dt.Columns.Add("ImageColumn", GetType(Image))
If Not ipNotes.Image Is Nothing Then values(0) = Image.FromStream(ipNotes.Image)
dt.Rows.Add(values(0))
ds.Tables.Add(dt)
ds.WriteXmlSchema("c:PSI
eportschema.xsd")

Using One Crystal Viewer To Display Each Report
I have several crystal reports that I've created in VB with the .dsr extension. Do I have to create a separate form with a CrystalViewer control on it for each .dsr report or can I just have each one load up in that one control as each report is called by the user?

Data Display In Crystal Report ???
Hey I`m sorry for asking again and again, but I have not worked on Crystal Repots before this.

What is basic concept of showing data in Crystal Report. When I select tables and fields in a report. Then all available data is displayed in that report OR can it be changed as per requirements. If yes then how ?

e.g. I am having data of attendance (date / time) of Employees. And I want to display data only for specific month. In short how can I customize display in Cryst. Repo. ?

One more que. : Format of a field is Date/Time and I stored time in it. (e.g. 14:00:00) but report is showing Date value at random (e.g. 99/12/30)

Please Guide !

Cannot Display Graph Of Crystal Report In VB
I create a graph report in crystal report 6.0 , it's OK .
But the report does not display on VB 6.0. ( I use the same way as tabular report). The report show only tabular data how i can fix it..

Display String In Crystal Report
How can i display a string from other form in the crystal report v7.0?

Eg...i have accept a date (string) in a form then when i display the report, i want to show that date inside there.
What method can i use?

Disorder Display In Crystal Report
Dear all,

Please help me out when I am selecting conditioned record in Form
Flexgrid it is showing selected records correctly but when i am
executing same selecting condition formula in crystal reports
the crystall reports view gets sometimes correctly & sometime it
incorrectly. why?

Thank you & grateful
Santosh

Display More Than 256 Characters In Crystal Report
Hi

I am facing problem in displaying text in Crystal Report. It displayspart of string (256 characters). i have a long text to display can anyone help me.

P.R.Krishnan
Web Traverse India Ltd.
Ph:91-22-8577025

Crystal Report Data Display
Hi all
I have made Report by using recordselectionformula but when i am previewing the report that is coming correct and suppose i have closed the preview and without unloading the project i want to see the report for some another record i have to click on the refresh button without this i am not getting data display
and if i stop the execution and execute the s/w then again once it is working o.k. for once and again the same procedure if anybody of u can suggest me sol.
Dinesh

Crystal Report 8.5 Display Problem
hey ppl.

i m using crystal reports 8.5 and VB6 . whenever i pass a value the whole report comes out blank. this is my code

Code:
Dim Report As New CrystalReport1
Public jobno As String

Private Sub Form_Load()

    Report.Database.LogOnServer "p2ssql.dll", "T2T2", "JBSurvey1", "sa", ""
    Screen.MousePointer = vbHourglass
    CRViewer1.ReportSource = Report

        jobno = frmJobDet.txtJobNo.Text
    Report.ParameterFields.Item(1).AddCurrentValue jobno

    CRViewer1.ViewReport

    Screen.MousePointer = vbDefault

End Sub

Private Sub Form_Resize()
CRViewer1.Top = 0
CRViewer1.Left = 0
CRViewer1.Height = ScaleHeight
CRViewer1.Width = ScaleWidth

End Sub

Quick Display Crystal Report 8
i m new be with crystal report 8.
i have few conf abt crystal report 8 with vb6.
my project have connection object is created dynamic not Data Enviornment.
IN project v generally use Recordset to query db , i want to show such query int o crystal report. I want to use a single report for all Reports like invoice , product master, party master etc.
1) How to create a crystal report on basis of query ? v give dynamically generated query i.e. recordset to crystal report and it display those records.
2) what is fastest way to populate data in crystal report ??

thanx in advance.

It May seem Impossible, But Possibly We don't know the way how to reach there ????

Crystal Report - Bottom To Top Display
I want display the word from Bottom to Top in crystal subreport, is it possible.

i attach my file, it more easy to understand what i mean.

In deposit received: if more than 1 deposit, maybe 1 pay by cash, another pay by cheuqe, then my record "DEPOSIT" will be grow,

normally record was grow from Top to Bottom, but i want it grow from Bottom to Top, is it possible ?

How To Display Crystal Report 8.5 In VB6 Application??
Hi All,

    I am newbies in integration of Crystal Report 8.5 with VB6 application.

Code:
Private Sub Command1_Click()
    CR.PrintReport
    CR.LogOnServer "PDSODBC.DLL", "DNS NAME", "DATABASE NAME", "USERID", "PASSWORD"
End Sub

CR is Crystal Report Control.

When i run it, it will prompt me to set the Parameter for crystal Report as usual. After parameter has been set, the report is gone after few milisecond.

Can anyone help me on that?

Thanks!

Display HTML Tag In Crystal Report
Quote:

Originally Posted by dragon_ballz96
Basically, i allow user to enter some free text (part of the content) which can contain html in a quoutation. It will then be exported to PDF using VS .Net Crystal Report. I understand that crHTMLText is currently not working properly. Is there any other work around?

Rgds
Ryan

hello please i have the same probleme, i have customers that send me a fragment of an HTML code on an XML file, and when i generate the with crystal report, i also do the interpretation with crHTMLText but the result is not formated corretly.
so i want to know if you have resolve your probleme by any way.
thank you (excuse me for my bad en english, i speak french).
thanks a lot

Crystal Report 8- Cannot Display The Chart
Well, things were all going fine, until I upgraded my Crystal repports from version 7.0 to 8.0.
I am able to open a report (that does not have a chart) perfectly alright from VB. But if the report has a chart, it is giving an error 'run time error 20998'.

Why is this happening? Is there a dll I/m missing? Why does it open a report but not a chart? Please let me know. It's kinda urgent here.

thanks

Display Text In The Crystal Report
Hi,
i want to enter a text in the text box on the VB like'Employee Detail" and show this in the crystal report without using table.

how can i do this..

thanx in advance..

subas

Display HTML Tag In Crystal Report
Hi,

I am using VB .Net to export a crystal report to PDF. Seems like one of the fields which contains HTML tags didn't display correctly even i have set the property of the field to crHTMLText. I have applied the latest patch for VS .Net 2003 but it don't seems to work. Anyone has any idea to get this one fixed? Let me know. Thks.

Rgds
Ryan

Display 20 Rows Per Page In Crystal Report
Hi
1. How can i display 20 records in detail section per page in crystal reports.

2. I have put Urdu data in my access 2003 database. How can i get that data in Crystal Report.

If anybody got clue could please email me.

Thanks
Best Regards
Farooq

Help With Crystal Report - Display Only Needed Data
i'm really new to crystal reports. i have a database which saves payroll information every 15th day, now i want to come up with reports on a specified paydate only... how do i go about it?

say, i have payroll records each employee for the last 5 paydates, so how do i go about having only to print one of these paydates instead of having all existing paydates in my report?

any suggestion, links? tnx.

Display Variable Value In Crystal Report Text Box
In my application I have certain calculated values stored in variables. I am using Visual Basic 6 and Crystal Reports 8.5 and my Report has certain Text Boxes where I want to display the calculated values. I don't want to use the Data Fields. I want to do like this:

Code:
Dim C as ...CrystalReport1
Dim var1, var2 As String

Set C = New CrystalReport1

C.txtName.Text = var1
C.txtNumber.Text = var2
But the Crystal Report displays an error at lines "C.txtName", saying that it is a Read-Only field.

Display Crystal Report VIA Visual Basic
How do I display a Crystal Report through Visual Basic code? What is the syntax to display the report ?

Crystal Report : Restrict Second Instance From Display
Hi

In one of my project when user clicks 'Print Preview' button it will displays the report, but when user clicks again the 'Print Preview' button it displays the second instance of the same report even though the first one is on the screen

How to avoid displaying the second instance of the same report OR how can i restrict this.

Thanks.

How To Display Selected Records In Crystal Report
hello...

i have a prb ... is regarding to display crystal report....means... how to get the crystal report display the selected records??
ex...
i have these Stocks
A001,A002,A003,A004, A005
i only select the A002, A003 and A004 to be display
and this is my code...
my database name is Inven.mdb

thanks
swiss

********************************************************
Private Sub cmdPrint_Click()
Dim sCondition, sTemp As String

sCondition = ""
sTemp = ""

mOK = True

If optSpecificStockCode.Value = True Then
sTemp = ("{stocktake.StockCode} >= " & cbStockCodeFrom.Text & _
" and {stocktake.StockCode} >= " & cbStockCodeTo.Text & "")
If sCondition = "" Then
sCondition = sTemp
Else
sCondition = sCondition & " and " & sTemp
End If
End If

If optPreview.Value = True Then
mDestination = crptToWindow
Else
mDestination = crptToPrinter
End If

Debug.Print "f=" & sCondition
With rpt
.Reset
.DataFiles(0) = (App.Path & "Inven.mdb")
.ReportFileName = (App.Path & "
ptst.rpt")
.WindowTitle = "Stock Take Report"
.WindowState = crptMaximized
.WindowShowRefreshBtn = True
.SelectionFormula = sCondition
.Destination = ToDestination
If .PrintReport() <> 0 Then
MsgBox "Error #: " & .LastErrorNumber & vbCrLf & .LastErrorString
End If
End With
End Sub
**********************************************

Crystal Report Will Not Display Multiple Values
I am using the code below to display employee payroll information
depending on the value entered for a parameter named department.
In the code below I use the value 1234 for the department number
as an example.

I would like to be able to display information from multiple
departments, departments 1234, 2222 and 9876 for example.
Ideally, the report would be setup to show department 1234's
payroll information, then on a new page department 2222's
information, then on another new page department 9876's
information.

I have tried setting the parameter to accept multiple values, but
when I do that only the information for the lowest value (1234
in this case) is shown. The lowest value problem is probably a
reflection of the department field being a numerical value, but
even if I change it to be a string I think I would probably just
end up getting information for the first entered value.

If anyone knows how to get a crystal report to display
information for multiple discrete values, passed
programmatically, please advise. I'm using Visual Studio 2005
Professional.

Private crReportDocument As New PayrollReport()

Private Sub frmPayroll_Load(ByVal sender As Object, ByVal e
As System.EventArgs) Handles MyBase.Load

crReportDocument.SetDataSource(DsEmployeesPayroll1)

Dim crParameterFieldDefinitions As
ParameterFieldDefinitions
Dim crParameterFieldDefinition As
ParameterFieldDefinition
Dim crParameterValues As ParameterValues
Dim crParameterDiscreteValue1 As ParameterDiscreteValue

Dim crParameterDiscreteValue2 As ParameterDiscreteValue

' Get the current ParameterFields collection from the
ReportDocument.
crParameterFieldDefinitions crReportDocument.DataDefinition.ParameterFields

' Get the "Department" ParameterField from the
collection.
crParameterFieldDefinition crParameterFieldDefinitions.Item("Department")

' Get the current values from the ParameterFields
crParameterValues crParameterFieldDefinition.CurrentValues

crParameterDiscreteValue1 = New ParameterDiscreteValue()
crParameterDiscreteValue1.Value = "1234"
crParameterValues.Add(crParameterDiscreteValue1)

crParameterDiscreteValue2 = New ParameterDiscreteValue()
crParameterDiscreteValue2.Value = "2222"
crParameterValues.Add(crParameterDiscreteValue2)

' Apply the current values.

crParameterFieldDefinition.ApplyCurrentValues(crPar ameterValues)

crvPayroll.ReportSource = crReportDocument
End Sub

Display Dynamic Data In Crystal Report
hello Sir,
i m using vb6 and access 2000,crystal report 9.
i would like to display changed access table data at run time. my problem is report is not accepting data from database.
actualy i stored data in access table from text file.
but it not reflecting when i create exe of project and run it.it display records from local disk,where project sored.
pls help me. my code is as

Open App.Path & " est.txt" For Input As #1
Line Input #1, cname
Line Input #1, ccity
Line Input #1, sno
Close #1
str1 = "Delete * from Table2"
Set rs = New ADODB.Recordset
cn.Execute str1
rs.Open "Select * from Table2", cn, adOpenDynamic, adLockOptimistic
rs.AddNew
  rs.Fields(0) = Trim(cname)
  rs.Fields(1) = Trim(ccity)
  rs.Fields(2) = Trim(sno)
rs.Update
rs.Requery
cr1.Database.SetDataSource rs
DoEvents
cr1.DiscardSavedData
cr1.ReadRecords
rs.Close
For i = 1 To cr1.Database.Tables.Count
cr1.Database.Tables(i).SetDataSource (App.Path & "sample.mdb")
cr1.Database.Tables(i).Location = App.Path & "sample.mdb"
cr1.Database.Tables(i).SetLogOnInfo "", App.Path & "sample.mdb", "", ""
Next i
cr1.Database.Verify

Help! Display Bit Value On Crystal Report As A Group Header In VB.net
Hi! I have some problems trying to display a column with bit data 1,0, Null values to a readable text description like 1 = True, 0 = False, Null value = 'Others' in the crystal report group header. Anyone can help?

Edited by - spritescream on 9/4/2004 12:14:43 AM

Display Image In Crystal Report From Database
hello
sir

i am desperately in need of suggestion or say i want to know how to display image (ie pic of students) in a crystal report to print their admit cards.
Sir i have a databese field name (picture datatype - ole object ) in STUDENT_mas table
and the data stored in the database is Long binary data

sir now i want the report off all students for their admit card with their pic stored in the database on the report . iam able to display the same in vb in image control
but not able to display it in crystal pls
pls
pls
pls
help

thanking u in advance

hussain

How To Display Data From Database SQL In Crystal Report?
i'm new in VB.NET and need help in crystal report.
i've tried but i still face problem in binding the crystalreport viewer and crystal report. i get error when i put this source code: "CrystalReportViewer1.DataBind" in method CrystalReportViewer1_load.
i would be grateful if anyone can help me in this... please...
thanks

Using ADO, Fill Out A Crystal Report And Display It In Access.
I am a complete newbie with crystal reports and i am still getting to grips with ADO. What i need to do is access customer information in my database (access) and load it into a form to make a sort of mail merge letter for a selected user eg...

Dear [CustomerName]
Did you get your [OrderItem]
From
[SalesAssistent]

Something like that. A tutorial or very simple source code would be ideal. please help!

Link Table Not Display In Crystal Report
I have two MS Access database. i linked a table from database1 to database2 but i am not getting the linked table name in crystal report List.can anyone ple help me out. thank you in advance.

regards
raj

-----Resolved ----- Display Crystal Report Viewer In Max Size
How to set crystal report viewer display in max size ? Thanks.

Crystal Reports 10 Takes Too Long To Display Report
We are updating our software to use Crystal Reports version 10. We have converted our reports to version 10. When we put them into VB thay take way too long to display. We havent changed anything in our reports since version 8.5. Why should the NEW version of Crystal Reports take longer to display the reports than the old one? Has anyone else encountered this problem before?

Display Picture (load From Path) In Crystal Report 10
Hello,
I would like to display the Photo in Crystal Report 10.
I store path of photo in a field with "Text" data type (NOT OLE Ojbect) in MS Access Database table.
How can I view the Photo in CR?
Thanks,
Sal.

How To Display Selected (between Two Dates) Records In Crystal Report.
Hello Sir,

I am new to crystal report section.

I want to know how to display selected (between two dates) records in crystal report.

e.g.
If user wants to print records between two selected dates (dates selected by DTPicker1 component)

I tried several times to solve the problem. But in crystal report only few fields are displaying.

So please give the suggestion step by step.

Software used:
Front End: VB5
Back End: MS Access 97
Crystal Report: 4.6

Text Field Does Not Display For Crystal Report After Saving It To A File
In my VB 6 code I do the following to a text field on my report.

VB Code:
CigUnitRpt.Text2.SetText "From " & Trim(Main.DTPicker1.Value) & " to " & Trim(Main.DTPicker2.Value)

After the report is created in vb, I save the report to a file like this.

VB Code:
Report.SaveAs "C:CigUnits.rpt", cr80FileFormat

When I open the file I created, this text field shows nothing in it even though I know there is data placed in the field.

Anyone know why this is happening and how to get around this problem?

Thanks

How To Display The Crystal Report 11 Using VB6.0 - Error Message Invalid TLV Record ...
Hello VB & CR users,

I have upgraded my Crystal Report 8.5 to 11. I know how to use CR 11.0
with VB.NET.

But one of my applications is still using VB 6.0 but I want to upgrade
all the reports to 11.0. I have added the "Component ->Crystal Activex
Report viewer library 11.0" and named crviewer1. Using below method
previous 8.5 reports displays correctly but the new report which is
creates using 11.0 gives message "Invalid TLV record". Please anyone
guide me here what else is required or which is correct code for the
below procedure????

ReportName = NPath & "oilcustomer.rpt"
Set CrxReport =
crxApplication.OpenReport(ReportName)
CrxReport.DiscardSavedData
CrxReport.VerifyOnEveryPrint = True
For i = 1 To CrxReport.Database.Tables.Count
Set CRTABLE = CrxReport.Database.Tables.Item(1)
CRTABLE.SetLogOnInfo "ServerName", DatabaseName", "Username",
"Password"
Next i
CrxReport.DisplayProgressDialog = True
CrxReport.VerifyOnEveryPrint = True
CrxReport.UseIndexForSpeed = True
CRViewer1.ReportSource = CrxReport
CRViewer1.ViewReport
CRViewer1.ShowFirstPage

Regards
Arun

What's The Property To Display Date In Pageheader In Crystal Report Which I Pass From VB
Hai friends,

I want to display the date in the Page header of Crystal Report which I pass from VB. I am passing the date as below in Record selection formula.
in the command button iam calling the function according to the Option button the user clicks. the report shows as the code in the function. How I will pass the From Date and To Date to display in the top of the report which I am sending from VB, and it should be displayed in the page header because I need to print the date in all the pages which print .

Thank you very much,
Chock.
itchocks@rediffmail.com

<HTML>
<B><font color="#008000">HAVE A NICE DAY !</font></B>
<HTML>

Edited by - chs on 2/25/2003 1:09:29 AM

Error On Selection Formula To Display Data On Crystal Report From SQL Database
I have a problem on selection formula to display data from SQL database on crystal report it produce an error like this:
error A number, currency amount, date, time, date-time or string is expected here

Code:

Dim Ap As New Application
Dim Rep As Report

Private Sub CRV_Click()

End Sub

Private Sub Form_Load()

Dim RepFileName
RepFileName = App.Path & "LeaveForm2.rpt"
Set Rep = Ap.OpenReport(RepFileName)
Rep.RecordSelectionFormula = "{tblLeaveApp.EmpNo}=" & ndEmpNo ->error is here
Rep.DiscardSavedData
CRV.ReportSource = Rep
CRV.ViewReport
CRV.Zoom 100

'frmcrs.Enabled = False
End Sub

Private Sub Form_Unload(Cancel As Integer)
Form6.Show
End Sub

anyone can help me....

How To Display Comma(,) For Total While Adding,Searching,Printing Using Crystal Report
Hai Friends,

Good Morning.

While Adding a record, i am in need of my total to be displayed as 11,20,990.80 like that. for that i used, Code:'" & Val(Format(Trim(Textnetamt), "#####0.00")) & " '. While adding a record its showing me comma's but its displaying as 1,120,990.80 which i want that to be displayed as 11,20,990.80 (as this is our format of specification for the totals).

Also, while searching its not displaying comma's for me.

And Another major problem is with Printing Crystal Report.

Can any one rectify me.

I hope , in printing, we have to do some coding for Customizing in the Format Field of the Net Amount Text.

is that so,

help needed

Regards

Geetha

How To Display Jpg File In Crystal Report Using File Path From Sql Table ?
hello friends,
i want to display jpg file in crystal report using file path from sql table,

if you have any idea please guid me.

Unable To Open The Crystal Report Exported In Crystal Report Format
Hi,
Sub: Unable to open the Crystal report exported in Crystal Report Format

1)    I have used Oracle Native connection, while designing the report.
2)    I have passed the record set to the report at run time.
3)    Exported the report to Crystal Report Format, But I could n’t able to open report, while opening , the report asks for OLEDB information, even though I used Native connection at design time.
4)    In Crystal Report 8.5, connect driver property, but I am using crystal reports XI and in Visual Basic 6.0, Is there any method or property to convert the connection?. As I have to export report to crystal format and emailed to user, so that user can open it.
Any assistance in this regard is highly appreciated

The code is as follows:
Public Sub Aging_REPORT(strSQL As String, sReportName As String, sDestFileName As String, ReportTitle As String)

On Error GoTo Err
Dim CrAppl As CRAXDRT.Application
Dim crrep As CRAXDRT.Report

Dim rsCrystal As ADODB.Recordset

    Set CrAppl = New CRAXDRT.Application
    Set crrep = CrAppl.OpenReport(sReportName) 'Opens the report

   Set rsCrystal = New ADODB.Recordset


    rsCrystal.Open strSQL, Conn, adOpenStatic, adLockReadOnly
    rsCrystal.Requery


     With crrep
     .DiscardSavedData
    .Database.LogOnServer "crdb_oracle.dll", strServerName, "", strUserName, strPassword
     .ReportTitle = ReportTitle
     .Database.SetDataSource rsCrystal, 3 'LINK REPORT TO RECORDSET
     .VerifyOnEveryPrint = True
     End With

   With crrep.ExportOptions
    .DestinationType = crEDTDiskFile
    .FormatType = crEFTCrystalReport
    .DiskFileName = sDestFileName
   End With


   crrep.Export (False)
    Set crrep = Nothing
    Set CrAppl = Nothing
    Exit Sub
Err:
MsgBox Err.Description

End Sub

Thanks,

How To Pass Format String To Crystal Report From VB And How To Use It In Crystal Report?
Hi,

I am working on VB 6.0 and using crystal report 7 as reporting tool.
In report, some clients are asking 3 decimal places(Eg. 2000.500) while other clients are asking 2 decimal places(Eg. 2000.50) for numeric fields.
I want to pass the amount of decimal places for numeric fields to crystal report from VB.
How should I implement this using VB.
Pls any one can help me?

Thanks in vance,
Soundar

How To Replace Crystal Report Control With Crystal Report Designer
Hi,

I want to replace crystal report control with crystal report designer in vb. report files are ready.
and parameters have passed by crystal report control to the actual repors which are made in segate crystal report.
now i want to keep the re[prt files as it is. but instead of control,
i want to use designer.

plesae help me

thanks
mital

Crystal Report ActiveX Vs Crystal Report Wrapper.bas
When print a report via Visual Basic, is it recommended to use the methods and properties of the ActiveX or using the functions provided by the wrapper, such as PEOpenPrintJob and etc.? If there's no diff in using both, then I have a question. There is a PEClosePrintJob function in the wrapper, however, there isn't any methods or properties in the ActiveX to perform such function. What will happen if PEOpenPrintJob (called by ActiveX's ReportFileName) is executed x times but the print job is not closed at all?

Regards.

Brandon

Connecting SQL Db From Crystal Report (through VB Crystal Report Control)
VB -> Crystal Report -> SQL database
I need to use VB to call CR (Crystal REport) to access data in an SQL server.

SETUP:
1) Over at the SQL server, I have created a login account, login ID = "RMS", and password = "9999".
2) I have created a ODBC - System DSN (in the control panel), with the login ID, password as in (1).
3) I have run-time CR installed on the client PC.
4) At the click of a button in my VB application, the CR (.rpt) will open (via Crystal Report Control in VB) and retrieves data from the SQL server database through the System DSN created in (2).

PROBLEM:
MY VB application FAILS to open up a CR file (.rpt) No error message though.

I realise that the VB CAN only open the CR (.rpt) when the PASSWORD in (1) is LEFT BLANK.

QUESTION:
It seems that I have to Hardcode the password somewhere.
1) HOw do I pass the password to CR so that the CR will not fail to display itself?

Really appreciate your good karma!

Thanks in advance!