crystal reports new bee,how to fetch data to crystal report thorugh vb.net classes?

V

vijju

New member
Joined
May 16, 2003
Messages
3
hi,

iam working as a software engineer in vb.net
iam very new to vb.net

i have been given a task of populating data to crystal report from vb.net classes,printing should be very fast.

i have done some pretty work on displaying crystal reports from vb.net using crystal report viewer.

but now i had a very tough situation...

i need to do the following things
1)Design a windows form with a simple combobox which takes all the batch ids from foxpro database.
2)When a batchid is selected and a button called "Print Orders" is Clicked,this batch id should be passed as a parameter to class.

2)The data should be fetched from more than three tables

3)All the data should be populated to crystal report through classes,so that there is no coupling of database and report directly.


so what is the meaning of populating data from classes to crystal reports?

could any body please tell me how to go forward to make it successfull.i have been trying to find out the approach from the last two days.can any body give me the idea.....

if would be very thankful if somebody provides me a some sample code.......

iam drawing the flow....


windows forms(Reports)
|
|
|
vb.net class (which should fetch data for the report)
|
|
|
Foxpro database

regards
varma
 
after you have created your dataset pass it to the form that will display your report and set the forms private dataset variable to the dataset being passed to the form

Code: 
    Private m_dsReportSource As System.Data.DataSet


   
Public Sub New(ByVal dsReportSource As System.Data.DataSet)
        MyBase.New()


        This call is required by the Windows Form Designer.
        InitializeComponent()


        Add any initialization after the InitializeComponent() call


          set the forms dataset variable to passed dataset


        m_dsReportSource = dsReportSource


    End Sub

then setup your report as follows....

Code: 
 Private Sub CrystalReportViewer1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles CrystalReportViewer1.Load

         myReport = New repWhatEver()


         myReport.SetDataSource(m_dsReportSource)


         Me.CrystalReportViewer1.ReportSource = myReport


End Sub
 
getting query engine error,crystal reports,vb.net,foxpro

hi,
iam working on an orderprocessing application.
i wrote the following code
Dim empReport As New PackSlip()
Dim cnn As New OdbcConnection()
Dim empAdapter As OdbcDataAdapter
Dim empDS As DataSet
Dim strQryString As String
Dim strQryString1 As String
strQryString = "Select Orders.order_num,Orders.status,Orders.batch_id,Orders.cost_code,Orders.st_fname,Orders.st_mname,Orders.st_lname,Orders.st_add1,Orders.st_add2,Orders.st_add3,Orders.st_city,Orders.st_state,Orders.st_zip,Orders.st_zip4,Orders.st_cntry,Orders.st_intzip,Orders.deliv_inst,Orders.comments,ship_methods.descrip from orders,ship_methods"
strQryString1 = "Select ship_methods.descrip from ship_methods"

Try
cnn.ConnectionString = "DSN=Visual FoxPro Database;UID=;PWD=;SourceDB=C:\Bowne\POC\temp\data
1. dbc;SourceType=DBC;Exclusive=No;BackgroundFetch=No
;Collate=Machine"
cnn.Open()
empAdapter = New OdbcDataAdapter(strQryString, cnn)
empDS = New DataSet()
empDS.EnforceConstraints = False
empAdapter.Fill(empDS, "Orders")
empAdapter.Fill(empDS, "ship_methods")
empDS.EnforceConstraints = True
empReport.SetDataSource(empDS)
Catch oleEX As OdbcException
MessageBox.Show(oleEX.Message)
Catch RepEX As Exception
MessageBox.Show(RepEX.Message)
End Try
CrystalReportViewer1.ReportSource = empReport

the above code prints orders whose shipping method is same
the relation is
orders.reg_or_on=ship_methods.id.

i created this relation in the xsd file.
i created the crystal reports with this xsd file as data source.
i created the same relation with crystal database linking export.

the main aim is to get the data for the reports using relation between two tables.

but iam getting
Query Engine Error:C:|Docume~1\buddha.r\LOCALS~1\Temp\temp_4a6fc71-4a9d-403c-beb1-388c-4b23a16d.rpt

what may be the problem with this .
should i need to do any thing other than creating relation ships or use joins.

if so how should i create relation...

please give suggestions...

regard
varma
 
I create a single dataset with the an SQL statement that returns all the required records from multiple tables.

I think that was is easier than the way you are doing it
 
Originally posted by hog
I create a single dataset with the an SQL statement that returns all the required records from multiple tables.

I think that was is easier than the way you are doing it
Click to expand...
piggybacking on this thread..

do we have to add the dataset and dataadapter from the toolbox or can we declare them in the code?

really confused now.. :-\

-ashrobo
 
I start off with adding a dataset and data adapter on the form to be used at design time in order to get all the fields I require at design time. I then create the dataset and data adapter at run time which will contain the users required data knowing the field names exist on the form.
 
Back
Top