水晶报表查看器选择公式错误 [英] crystal report viewer selection formula error

问题描述

你好

我想使用选择公式创建水晶报表
我写了

hello

i want to create crystal report with selection formula
i wrote

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

它显示错误
这里需要一个字符串
请帮助我找出问题所在

it shows error
a string is require here
please help me find out what''s wrong

推荐答案

如果该公式在Crystal报表的公式编辑器"中，则
几个月前我自己遇到了这样的问题.

我是这样的:

{Customer.LastYearSales}> ToText("11000")AND MID({Customer.CustomerName}，1,1)= ToText("A")

If the formula is in Formula Editor of Crystal report then
I got this sort of problem myself a few months ago.

I did it like this:

{Customer.LastYearSales} > ToText("11000") AND MID({Customer.CustomerName},1,1) = ToText("A")

你好

终于我做到了这一点，并且没有显示任何错误，我得到了结果

字符串selectFormula =" ToNumber ({Customer.LastYearSales})> 11000.00" +
"和Mid({Customer.CustomerName}，1，1)= \"A \";

hello

finally i did like this and shows no error and i get the result

string selectFormula = " ToNumber( {Customer.LastYearSales} )> 11000.00"+
" and Mid({Customer.CustomerName}, 1, 1) = \"A\"";

这篇关于水晶报表查看器选择公式错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！