crystal report need help

[kerek2]

Hi Alls,

I need your help regarding crystal report....i have access database, application form,crystal report.rpt......the application form i build it with VB.net.....
Crystal Report already done...but i need to link data into it and print...Assume i keep in the data like student id , name into Application form..then i need to print the form to get sign .....so how to do that?..please help me

[kvprajapati]

kerek2,
Did you create typed or untyped dataset?

[kerek2]

So sorry bro...confuse with ur question....actually i already got dataset from mdb database....what mean create tped or untyped?...please help me....

[kvprajapati]

I presume that you have a report named "test.rpt" that used one table (emp).

Dim Ds as new DataSet1
 Dim a as new DataSet1TableAdapters.empDataTable
 a.Fill(ds.Emp)
 Test1.setDataSource(a)

[kerek2]

Bro,
I can display my data value into the crystal report..thanks for you...but still got problem because it will display all data in my form in many2 form.....it mean all data of student will display into application form report continuesly...actually i need to display only student id that i need to print it...how to sort or create a main frame template then fill it with query student id only?...

[Piya27]

I presume that you have a report named "test.rpt" that used one table (emp).

Dim Ds as new DataSet1
 Dim a as new DataSet1TableAdapters.empDataTable
 a.Fill(ds.Emp)
 Test1.setDataSource(a)

thanks...
I had the almost same problem regarding crystal reports...
now solved.. :)

[kvprajapati]

Use RecordSelectionForumla property or CrystalReport parameters.

[kerek2]

Still stuck bro....how to use parameter? i newbie in vb.net...this my final project year...can u guide me plz

[kvprajapati]

For Numeric field type

Test1.RecordSelectionFormula="{TableName.ColNumeric}=" & txtVal.Text

For Varchar or string field type

Test1.RecordSelectionFormula="{TableName.ColName}='" & txtVal.Text & "'"

For DateTime or Date field type

Test1.RecordSelectionFormula="{TableName.ColName}=#" & txtVal.Text & "#"

[kerek2]

Bro,
where to write this coding?...in crystal viewer form?...

[kvprajapati]

Dim Ds as new DataSet1
 Dim a as new DataSet1TableAdapters.empDataTable
 a.Fill(ds.Emp)
  Test1.setDataSource(a)
 Test1.RecordSelectionFormula="{TableName.ColNumeric}=" & txtVal.Text