[ MarkoBalkan @ 22.09.2007. 11:09 ] @
imam crystal report.
ako podacima pristupam preko dataseta, onda ne vidim podatke.
bez obzira sto punim crystal report preko sql upita.
ako koristim sql server preko oledb-a, vidim i prikaze mi podatke.
ali ako hocu filtrirati pomocu sql upita i prikazati u crystal reportu, onda mi opet prikaze sve, a ne filtrirano.


Dim con As New SqlConnection("Data Source=localhost ;Initial Catalog=marko;User Id=;Password=;Integrated Security=True;")

Dim ad As New SqlDataAdapter("select * from tablica where ID like 15 ", con)

Dim dt As New Data.DataTable
con.Open()
ad.Fill(dt)
con.Close()
Dim cr As New CrystalReport1


cr.SetDataSource(dt)

Me.CrystalReportViewer1.ReportSource = cr