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
Jump to Postkerek2,
Did you create typed or untyped dataset?
Jump to PostI 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)
Jump to PostI 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.. :)
kerek2,
Did you create typed or untyped dataset?
So sorry bro...confuse with ur question....actually i already got dataset from mdb database....what mean create tped or untyped?...please help me....
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)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?...
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.. :)
Use RecordSelectionForumla property or CrystalReport parameters.
Still stuck bro....how to use parameter? i newbie in vb.net...this my final project year...can u guide me plz
For Numeric field type
Test1.RecordSelectionFormula="{TableName.ColNumeric}=" & txtVal.TextFor Varchar or string field type
Test1.RecordSelectionFormula="{TableName.ColName}='" & txtVal.Text & "'"For DateTime or Date field type
Test1.RecordSelectionFormula="{TableName.ColName}=#" & txtVal.Text & "#"Bro,
where to write this coding?...in crystal viewer form?...
Dim Ds as new DataSet1
Dim a as new DataSet1TableAdapters.empDataTable
a.Fill(ds.Emp)
Test1.setDataSource(a)
Test1.RecordSelectionFormula="{TableName.ColNumeric}=" & txtVal.TextWe're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.