vb.netcrystal-reports

Crystal Reports RecordSelectionFormula does not work


It's my code:

CrystalReportViewer1.Zoom(75)
Dim rpt As New CrystalReport1
rpt.RecordSelectionFormula = "{members.id} ='3232'"
CrystalReportViewer1.ReportSource = rpt
CrystalReportViewer1.Refresh()

It shows all records, I don't know why


Solution

  • Dim CrReport As New CrystalDecisions.CrystalReports.Engine.ReportDocument
    CrReport = New CrystalDecisions.CrystalReports.Engine.ReportDocument()
    CrReport.Load(Application.StartupPath & "\CrystalReport1.rpt")
    CrReport.SetDataSource("HERE YOUR DATASET USED IN DA DESIGN OF CRYSTALREPORT1.rpt")
    CrystalReportViewer1.ReportSource = CrReport
    CrReport.RecordSelectionFormula = "{members.id} ='3232'"
    

    Your CRYSTALREPORT1.rpt must be located at \\BIN\DEBUG OF your appath and it must be almost created before. Like an object by the designer from Visual Studio... .. > ADD NEW ITEM > CR