Crystal report i sql server
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
 |  |
 |
