Question Selection Formula

gate7cy

Well-known member
Joined
May 11, 2009
Messages
119
Programming Experience
3-5
I am trying to filter out data from my report but I am having problems when I try to use multiple criteria. For example the folowing formula needs to get data with that technician that are completed. The technician is a text column and the completed is a boolean column.

VB.NET:
  CrystalReportViewer1.SelectionFormula = "{AllServices.Technicians} = 'paris'" And "{AllServices.Completed} = True"
            CrystalReportViewer1.RefreshReport()

I have tried different variations of this formula but always I get errors, different ones each time. For this one on top I get this error

VB.NET:
Option Strict On disallows implicit conversions from 'String' to 'Long'.

Thank you for your time. :confused:
 
Back
Top