LouisNet77
New member
- Joined
- Sep 8, 2005
- Messages
- 1
- Programming Experience
- 3-5
Hi, friends.
I have a dataset, inside there exists a datatable, which already this leaked(filtered) through a dataview, and I can see this from a GridControl, but when sending (parcel) the "datatable" leaked(filtered) to a report (CR) shows me the complete table, since I can solve this problem?
This code is:
Dim MyFilter As String = "sod_userdef4 = '9' AND sod_userdef5 = '2005'
DsFechas.Tables("TblFechaRepos").DefaultView.RowFilter = criterio
Dim MyTable As CrystalDecisions.CrystalReports.Engine.Table
Dim InfoFechas As New CrDate
InfoDates.SetDataSource(DsDates)
For Each MyTable In InfoFechas.Database.Tables
If MyTable.Name = "TblFechaRepos" Then
MyTable.SetDataSource(DsFechas)
MyTable.LogOnInfo.ConnectionInfo.ServerName = "servername"
MyTable.LogOnInfo.ConnectionInfo.UserID = "userid"
MyTable.LogOnInfo.ConnectionInfo.Password = "password"
End If
Next
CrystalView.ReportSource = InfoDates
Very much his help
Louis
I have a dataset, inside there exists a datatable, which already this leaked(filtered) through a dataview, and I can see this from a GridControl, but when sending (parcel) the "datatable" leaked(filtered) to a report (CR) shows me the complete table, since I can solve this problem?
This code is:
Dim MyFilter As String = "sod_userdef4 = '9' AND sod_userdef5 = '2005'
DsFechas.Tables("TblFechaRepos").DefaultView.RowFilter = criterio
Dim MyTable As CrystalDecisions.CrystalReports.Engine.Table
Dim InfoFechas As New CrDate
InfoDates.SetDataSource(DsDates)
For Each MyTable In InfoFechas.Database.Tables
If MyTable.Name = "TblFechaRepos" Then
MyTable.SetDataSource(DsFechas)
MyTable.LogOnInfo.ConnectionInfo.ServerName = "servername"
MyTable.LogOnInfo.ConnectionInfo.UserID = "userid"
MyTable.LogOnInfo.ConnectionInfo.Password = "password"
End If
Next
CrystalView.ReportSource = InfoDates
Very much his help
Louis
