Comments by KimAugust (Top 2 by date)

KimAugust 11-Oct-12 6:44am View

hello thank u for your reply

here i test it with this
string selectFormula = "Mid({Customer.CustomerName}, 1, 1) = \"A\"";
no problem there it shows report customerName that starts with A

problem part is
if i wrote this
" {Customer.LastYearSales} > 11000" it says a number is required here
if i wrote change it to this
" {Customer.LastYearSales} > \"11000\"" it says a string is required here

help me my error thanks a lot

KimAugust 10-Oct-12 23:08pm View

hello thank you for your reply

the formula is not in Formula Editor

i use like this

string selectFormula =" {Customer.LastYearSales} > ToText(\"11000\") AND Mid({Customer.CustomerName}, 1, 1) = ToText(\"A\")";

crystalReportViewer1.SelectionFormula = selectFormula;
crystalReportViewer1.ReportSource = reportPath;

but the same error is pop up

and i test it in formula editor still the same error is popped up
please help me with this