Click to See Complete Forum and Search --> : Steps for creating Crystal reports in VB.net


ALREMTULLA
September 15th, 2006, 08:07 AM
Dear Friends,
On my vb.net 2003 and crystal reports 10. I have taken the following steps inorder to view the report.

1) added reference crviewer.dll.

2) I have other references also these are:
a) CrystalDecisions.CrystalReports.Engine
b) CrystalDecisions.Shared
c) CrystalDecisions.reportsource
d) CrystalDecisions.windows.forms
e) Crystalkeycodelib

3) In my form2 named as "form2" I added AxCrystalActiveXReportViewer1 for viewing the report.

4) others inside my form2:
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared

5) added the following procedure:

Private Sub Process1()
Dim param1Fileds As New CrystalDecisions.Shared.ParameterFields
Dim param1Field As New CrystalDecisions.Shared.ParameterField
Dim param1Range As New CrystalDecisions.Shared.ParameterDiscreteValue
Dim CRYRpt1 As New CrystalReport2
param1Field.ParameterFieldName = "COUNTRY_NO"
param1Range.Value = COUNTRY_NUMBER.Text
param1Field.CurrentValues.Add(param1Range)
param1Fileds.Add(param1Field)
AxCrystalActiveXReportViewer1.ParameterFieldInfo = param1Fileds
AxCrystalActiveXReportViewer1.ReportSource = CRYRpt1
AxCrystalActiveXReportViewer1.Refresh()
End Sub

6) Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Call Process1()
End Sub




before running this its showing me the following errors:-
a) CrystalReport2 is not defined

b) param1Range.Value = COUNTRY_NUMBER.Text --------> "name this not declared"

c)AxCrystalActiveXReportViewer1.ParameterFieldInfo = param1Fileds ----------> ParameterFieldInfo is not a member of AxCrystalActiveXReportViewerlib10.AxCrystalActiveXReportViewer1

d) more error may be after updating these errors.


NOTE:

1) I have the database password as "mypass" in "access". which is at c:\myprogram\data\

2) my report name is "CITIES.RPT" which is at c:\myprogram\report\

3) If I run the cities.rpt report seperately the data is been displayed.

Thanks